Click here to Skip to main content
15,867,835 members
Everything / Database Development

Database Development

database

Great Reads

by Evoluteur
Generic REST or GraphQL endpoints for CRUD and more, written in JavaScript, using Node.js, Express, and PostgreSQL
by Aleksandr Ulanov
Learn how to use Redis and its geospatial indexes and commands for complex geo calculations
by Rob Culhane
How to dynamically add access database columns at runtime using VB.NET
by Paul D. Sheriff
As more and more users interact with web applications on their mobile devices, it is becoming increasingly important for software developers to allow them to work offline; PouchDB can help.

Latest Articles

by Nicolas DESCARTES
What are vector databases?
by Ștefan-Mihai MOGA
How to solve real-life problems using B-trees
by Mark Pelf
Showing problems with limited accuracy of SqlServer data type “datetime” in .NET7 EF7 environment
by Mark Pelf
Tutorial on EF7 – Code First approach using Command Line (CLI)

All Articles

Sort by Updated

Database Development 

22 Jun 2013 by Adam Tibi
A typical implementation of a CQRS pattern ASP.NET MVC 4, Ninject and MongoDB. I will be demonstrating a sample applications that acts as a base building block for a CQRS-based architecture.
21 Feb 2016 by adityaswami89
NoSQL: MongoDB for beginners
9 Sep 2014 by Ahmed Alaa El-Din
This articles provides a brief description of different methods that Android platform can provide for a developer to save different data types with different storage methods like Shared Preferences, Internal Storage, External Storage, SQLite DB, and Web Services
21 May 2020 by Akshay Srinivasan2
This article describes a technique to quickly retrieve and present hierarchical information from a flat relational database table with only one table scan.
13 Apr 2018 by Alaa Ben Fatma
In this article, we will walk through the basic concepts of de/serialization and how to create a very basic de/serializer.
10 Aug 2022 by Aleksandr Ulanov
Learn how to use Redis and its geospatial indexes and commands for complex geo calculations
6 Aug 2010 by Alexander Maximov, Apriorit Inc
The aim of this article is to create the library for writing e-mail messages in the *.pst format (used by Microsoft Outlook) to the file.
22 Sep 2016 by Alexandros Pappas
This project provides utilities for SQL server, such as executing a list of SQL scripts, exporting data to an SQL script, and displaying relationships between records.
2 Apr 2014 by Anand Gunasekaran
Working with text file as database can querying as RDBMS with SQL Queries.
6 Mar 2023 by Andriy Protskiv
Workaround for performance issues with AT TIME ZONE
10 Jan 2018 by ASkaeff
A simple yet powerful tool to analyze SQL object dependencies in quite a fast and reliable manner.
11 Oct 2013 by ASP.NET Community
Most ASP.NET sites talk to SQL Server or a backend SQL Database and there's a number of ways to manage that configuration.I always start with the
11 Oct 2013 by ASP.NET Community
LINQ to SQL is an interesting Object-Relational Mapper because it remembers the relationships objects have between each other.  As usual, LINQ to SQL
2 Mar 2014 by ASP.NET Community
In my case, I use  a FileUpload Control(Id:->FileUpload1), an ImageButton(ImageButton1) or you can use the Image,  a Button Control(Id:->Updatebttn)
11 Oct 2013 by ASP.NET Community
Let see an example of using the database in LINQ and C#.netcf We will using classCustomer Here'ssome sample
11 Oct 2013 by ASP.NET Community
I had to create Umbraco database on my shared hosting (I am using Winhost at the moment) couple of days ago.After checking few examples on
11 Oct 2013 by ASP.NET Community
Employee Info Starter Kit is an open source ASP.NET project template that is intended to address different types of real world challenges faced
11 Oct 2013 by ASP.NET Community
For ASP.NET developers, there is good news from Microsoft with the latest SQL Server release, Denali CTP3.Many developers like ASP.NET developers
11 Oct 2013 by ASP.NET Community
Getting started with MongoDBMongoDB is a famous representative of NoSQL databases. It is a document-oriented database, which means that data will
11 Oct 2013 by ASP.NET Community
If you use the asp.net membership providers, having visual studio keep this sql database file around for deployment can sometimes be convenient.
14 Jan 2014 by ASP.NET Community
IntroductionnAML (.NET Application Modeling Language, pronounced as “namel”) is a visual modeling semantics to model .net applications with wide
11 Oct 2013 by ASP.NET Community
When working with an ASP.NET site that requires some sort of user authentication (almost every time, I'd say), we often need to establish our own
11 Oct 2013 by ASP.NET Community
In this article I will sharing how to bind with GridView control with Database and without database using Data Table.Bind GridView with DatabaseI
11 Oct 2013 by ASP.NET Community
A RadioButtonList can be used to select 1 option within several options. The item "Pizza with egg" is selected by default.   
11 Oct 2013 by ASP.NET Community
 ASP Repeater ControlThe Repeater control is used to display a repeated list of items that are bound to the control. The Repeater control may
11 Oct 2013 by ASP.NET Community
In this article I am explaining about how to show Loading... image using Update Progress at center of grid view. for  this article i have used North
11 Oct 2013 by ASP.NET Community
Basic Hard Coded Cascading MenusTechnically your menus won't need javascript to be utilized. Just some basic CSS that will help with everything and
11 Oct 2013 by ASP.NET Community
Providers factory provides us indepandent database access where we can connect to any database sources(SQLServer,DB2,Oracle,MS-Access).Provider
11 Oct 2013 by ASP.NET Community
Following is an example of creating a transaction when require to save on many tables at once. I used Microsoft Enterprise Libraries. I assume one to
11 Oct 2013 by ASP.NET Community
Stored Procedure should look like thisCREATE PROCEDURE [dbo].[Purchases_Insert]    (@SupplierID     bigint,     @ReferenceNo     NVARCHAR(20),    
11 Oct 2013 by ASP.NET Community
DAL Should like following when inserting a image. I used the Enterprise Library to data access. Data type of EmployerImage is image @ SQL Server
11 Oct 2013 by ASP.NET Community
Open SQL Server and open a database (Already created) . On the Storage section find the Full Text Catalog. Right click and create a New
16 Mar 2014 by ASP.NET Community
This example will show how is possible to upload files to SQL server database using C# and asp.net. For demostration purposes database will have only
19 Jan 2016 by Avron Polakow
This article presents a client-side, JavaScript Relational Database Simulator in the browser, using SQL commands to Create, Read, Insert, Update and Delete in-browser table data, as well as formatting the output as HTML objects in a Webpage.
11 Feb 2015 by Aydin Homay
In the software implementing business synchronizing structures/templates of the database entities with Data Access Layer SQL (commands/Transactions) is the most expensive thinks because you need to re-implement when you have change/s in your entities structure's such as Data-type, Name, and etc.
4 Jan 2023 by Bert O Neill
Features and functionalities associated with Autogenerate DB Unit Test app
1 Nov 2016 by Bob Crowley
In this article, I will explain the sometimes surprising behavior of  the ADO.NET SqlParameter and particularly the effects of ParameterDirection, null value and DBNull.Value on how the parameter is sent to the database.
12 Sep 2017 by Bruce Yang CL
Develop an ASP.NET Core NES Game website on Linux with cross platform Database, and deploy to Ubuntu & Windows which have no .NET Core runtime installed.
3 Jul 2017 by Christian Del Bianco
SqlTableDependency is a component used to receive database notifications containing the record values inserted, deleted or update on a database table.
14 Jul 2010 by Christopher R Davis, Michael S Knight
Generate an Entity Framework data access layer using an nHydrate model.
8 Aug 2012 by CodeProject, DBNess
Welcome to our continuing series of Code Project interviews in which we talk to developers about their backgrounds, projects, interests and pet peeves. In this installment we talk to Vanessa Hurst, founder of Developers for Good, co-founder of Girl Develop It!, and a consultant and advisor to startu
16 Apr 2019 by Dan Ionescu (USINESOFT)
LINQ extensions that allow to describe and to safely query cached data
30 Dec 2019 by Dathuraj Pasarge
Database mirroring setup without any DBA effort - on every new database creation
30 Nov 2013 by DaveAuld
Too much data is breaking the system, we need a fix!
21 Aug 2019 by David Cuelogic
GraphQL: Evolution of Modern Age Database Management System
26 Mar 2014 by David Fahlander
Discover the hidden features of indexedDB!
12 Jul 2021 by David Wincelberg
Strings that differ by typos can be matched.
28 Jul 2014 by DiponRoy
How to manage Entity Framework Code First in Real Time Projects
13 Aug 2014 by DiponRoy
Here, we will see how to configure one to zero/one relation between two entities in Entity Framework Code First
15 Sep 2014 by DiponRoy
Some queries to find generation of each row, all possible children, all possible parents, managing recursion
5 Jul 2022 by DiponRoy
Example of Generic Repository Class with SQLAlchemy and Python
28 Jun 2022 by DiponRoy
How to use MERGE statements in different databases
3 Jul 2022 by DiponRoy
Conditional filter query example in SQLAlchemy and Python
7 Jun 2010 by Dylan Morley
Describes how you can run multiple queries against an iSeries DB2 and cancel long running queries.
27 Jun 2021 by Evgeniy Gribkov
The examples of SQL Server database documentation using both the extended properties and a third-party utility.
8 Jun 2010 by Evoluteur
Looking at the possibility of using CRUD applications to manage other CRUD applications inside a web browser and without any hand-coding. Also, presenting a step wizard deriving the database structure from the UI rather than the opposite.
20 May 2010 by Evoluteur
A step wizard for ASP.NET to export database objects to CSV, TXT, HTML, XML, or SQL
11 May 2022 by Evoluteur
Generic REST or GraphQL endpoints for CRUD and more, written in JavaScript, using Node.js, Express, and PostgreSQL
21 Sep 2016 by GhostHost
Use SQL Server to manage completely databases backups, network copy and deletion using only stored procedures
15 May 2013 by h_wiedey
Implementation of relative database constraints and permissioning using triggers and shadow tables.
7 Feb 2017 by hamdenvogel
Learn how to implement a real stream file based dataset descendant with blob support and much more
28 Sep 2011 by Ivan Vodišek
An alternative approach to database modeling.
3 Jun 2022 by Ivan Yakimov
How to use single database to store information from several microservices with the help of FluentMigrator
23 Jan 2012 by Jaganathan Bantheswaran
A tool to generate SQL server DB script from the LightSwitch internal database
7 May 2012 by Jason Rudland
Trial of popular REST implimentations for NodeJS including the measuring of MongoDB insertion rates.
10 Feb 2016 by Jesus Carroll
SQL Server 2016 introduces support for system-versioned temporal tables as a database feature that brings built-in support for providing information about data stored in the table at any point in time rather than only the data that is correct at the current moment in time.
11 Jul 2016 by Jesus Carroll
Despite the references of several sources of unattended installation of Microsoft SQL Server Database Engine, in this article describes a script tested in real production environments and it can be used with minimal or - perhaps - no modifications.
25 Jun 2014 by Josef Hardi
This is the third and final article about Semantika. This article will guide you to develop a simple "hello-world" query application
8 Dec 2015 by Jovan Popovic(MSFT)
Overview of built-in support for JSON text processing in new SQL Server
18 Aug 2019 by koolprasad2003
SQL 2017 new features
13 Jan 2020 by koolprasad2003
New features of SQL 2019
12 Jan 2015 by Leom Burke
EF Code First and WPF with the Chinook Database - Styles and DataTemplates
20 Jun 2013 by Levente Kupás
If you have big reports which run slowly, you may use this T-SQL based engine to speed-up them.
12 Sep 2017 by Mahsa Hassankashi
This article is the most complete essay about big data from scratch to practical.
31 Dec 2010 by Manan J
Arrange Results to get the most relevant result first...
8 Mar 2012 by Manjuke Fernando
Locks and duration of transactions in SQL Server
25 Oct 2014 by Marc Clifton
No word has a value that can be identified independently of what else is in its vicinity.
15 Jan 2013 by Marco Sorich
Some guidelines for developing better MS Access solutions.
1 Jun 2023 by Mark Pelf
Tutorial on EF7 – Code First approach using Command Line (CLI)
8 Jun 2023 by Mark Pelf
Showing problems with limited accuracy of SqlServer data type “datetime” in .NET7 EF7 environment
25 May 2023 by Mark Pelf
Tutorial on EF7 – Database First approach using Command Line (CLI)
25 May 2023 by Mark Pelf
Tutorial on EF7 – Database First approach using GUI tools EFCorePowerTools
18 Oct 2017 by Mauricio David
Simple, fast and free embedded .NET NoSQL Document Store in single data file
1 Mar 2015 by mbarbac
The seventh version of the dynamic, configuration-less and self-adaptive Kerosene ORM library, that provides full real support for POCO objects, natural SQL-like syntax from C#, and advanced capabilities while being extremely easy to use.
1 Mar 2015 by mbarbac
A deep dive into the Kerosene ORM Entity Maps operational mode that provides full real support for POCO objects.
1 Mar 2015 by mbarbac
A deep dive tutorial on Kerosene ORM Dynamic Records and other core concepts of the library
10 Oct 2013 by Mehdi Gholam
Even faster Key/Value store nosql embedded database engine utilizing the new MGIndex data structure with MurMur2 Hashing and WAH Bitmap indexes for duplicates. (with MonoDroid support)
13 Aug 2018 by Member 13935194
In this article, I will demonstrate how to integrate Firebase phone number authentication in Laravel.
14 Apr 2015 by Menci Lucio
I wrote a class to have an access to all databases in the simplest and smartest way
15 Feb 2013 by Michael Haephrati
The DataTune system was one of the earliest data cleansing systems.
8 Jan 2022 by Michael Haephrati
A Static Library which can be used for all kinds of database related needs
9 Aug 2021 by Michael Sydney Balloni
Learn about the inner workings of a dynamic database, and how SQLite is a great fit
22 Nov 2021 by Michael Sydney Balloni
Wanna add basic database functionality to your C++ app? Too lazy to use SQLite directly? Read on!
23 Mar 2019 by Minh Tuan Do
A considerable method to speed up query running time
5 Sep 2013 by Mr. xieguigang 谢桂纲
Easy way to map the table in the mysql database.
20 Jul 2014 by Mubin M. Shaikh
This Article will give you a good start for Creating SSRS Report First time with SQL Server Analysis Services OLAP Cube
14 Sep 2015 by nam1234567
Build your own database class library with C#
28 Nov 2016 by Neal Pandey
This article is a tutorial on creating a basic OData (Open Data Protocol) endpoint for a MongoDB database using MEAN stack.
9 Feb 2024 by Nicolas DESCARTES
What are vector databases?