Database Development

database

Great Reads

Model-driven REST or GraphQL API for CRUD and More

by Evoluteur

Generic REST or GraphQL endpoints for CRUD and more, written in JavaScript, using Node.js, Express, and PostgreSQL

Using Redis for Storing and Working with Geospatial Data

by Aleksandr Ulanov

Learn how to use Redis and its geospatial indexes and commands for complex geo calculations

Dynamically Add Access Database Columns at Runtime using VB.NET

by Rob Culhane

How to dynamically add access database columns at runtime using VB.NET

Getting Started with PouchDB - Part 1

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

Understanding Vector Databases

by Nicolas DESCARTES

What are vector databases?

Introduction to B-trees: Concepts and Applications

by Ștefan-Mihai MOGA

How to solve real-life problems using B-trees

SqlServer & EF7: Using datetime vs datetime2 date type

by Mark Pelf

Showing problems with limited accuracy of SqlServer data type “datetime” in .NET7 EF7 environment

Entity Framework 7 – Code First – Using CLI

by Mark Pelf

Tutorial on EF7 – Code First approach using Command Line (CLI)

All Articles

top

Database Development

.NET Application Modeling Language

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

.NET

database

server

application

4db: A Dynamic File-based NoSQL Database for C++

22 Nov 2021 by Michael Sydney Balloni

Wanna add basic database functionality to your C++ app? Too lazy to use SQLite directly? Read on!

A Coder Interview With Vanessa Hurst

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

All-Topics

data

database

A Database Initialiser for SQLite and NPoco

5 Jun 2021 by Private Dobbs

How to initialise a database and then automatically keep it up to date with version releases

A Practical Approach of Time Travel Concept in Business Intelligence Scenarios using Temporal Tables on Data Warehouses

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.

An All purpose database manager

14 Apr 2015 by Menci Lucio

I wrote a class to have an access to all databases in the simplest and smartest way

.NET

VS2013

database

Android Data Storage

14 Sep 2014 by Varavut

Lean about how to manage the data

Android dynamic Sqlite database management v.2

16 Oct 2014 by Pavel Durov

Article about dynamic Sqlite database management on Android platform using Java class reflection.

Article 8 - Handling Input and Storage on Android

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

ASP Repeater Control and Export to Excel

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

ASP

table

database

ASP.NET Core cross platform development with 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.

Autogenerate Unit Tests For Your Database Objects - Visual Studio 2019 & 2022 (amd64) Extension

4 Jan 2023 by Bert O Neill

Features and functionalities associated with Autogenerate DB Unit Test app

Automating the SQL Database Mirroring Setup

30 Dec 2019 by Dathuraj Pasarge

Database mirroring setup without any DBA effort - on every new database creation

Basic Handling and Types of Database Relationships in Entity Framework

25 Jul 2012 by Ws Hu

This article tries to fit all levels of readers by covering both basic database concept and practical tips for handling Entity Framework.

Big Data MapReduce Hadoop Scala on Ubuntu Linux by Maven intellj Idea

12 Sep 2017 by Mahsa Hassankashi

This article is the most complete essay about big data from scratch to practical.

Binary Relational Modeling

28 Sep 2011 by Ivan Vodišek

An alternative approach to database modeling.

Binding Grid View Control

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

Build Your Own Database

14 Sep 2015 by nam1234567

Build your own database class library with C#

VS2013

database

Bulk Insert a .NET List to Database

31 Jan 2018 by Praveen P R

This article presents a simple and efficient way to bulk insert any .NET list to the database.

C#.NET – Removing Duplicate Records From DataTable

13 Feb 2013 by Noor Ahmad Feroozi

A function to remove and select unique records from a DataTable in C#.NET and return a clean and duplicate-free DataTable

DataTable

database

Cachalot DB as a Distributed Cache with Unique Features

16 Apr 2019 by Dan Ionescu (USINESOFT)

LINQ extensions that allow to describe and to safely query cached data

Conditional filtering in SQLAlchemy and Python

3 Jul 2022 by DiponRoy

Conditional filter query example in SQLAlchemy and Python

Configuring SQL Server

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

Create a div based grid functioning on JSON data using MVC with Entity Framework and MySQL

5 Jun 2013 by Rajat Bittharia

Grid based on JSON data using MVC with Entity Framework and MySQL.

Create First SSRS Report with SQL Server Analysis Services OLAP Cube

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

create LINQ to database in the .NET Compact Framework 3.5

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

LINQ

database

Create OData endpoint for MongoDB on MEAN stack

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.

Creating a Custom De/Serializer

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.

Creating a custom membership provider

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

Creating a Full Text Service and Searching items from Code behind

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

Creating a Transaction (Enterprise Libraries)

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

Creating Menus with JavaScript, LINQ, and SqlDataAdapter

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

database

Database Export Wizard for ASP.NET and SQL Server

20 May 2010 by Evoluteur

A step wizard for ASP.NET to export database objects to CSV, TXT, HTML, XML, or SQL

Database Worst Practices – New Town and New Job and New Disasters

14 Jul 2011 by pinaldave

5 Database Worst Practices which can be fatal to any business

DataProvider - A Static Library for Handling Databases from C++

8 Jan 2022 by Michael Haephrati

A Static Library which can be used for all kinds of database related needs

Dev's User Guide To SqlLocalDb (Sql Express)

14 Aug 2017 by raddevus

Learn the basics (and challenges) of using LocalDb to make your SQL dev easier and localized using tools like SqlLocalDb, sqlcmd and built-in Visual Studio server explorer. Now, also includes SqlCmd scripting.

SQL

.NET

database

Developing Automated Data Purge Solution

30 Nov 2013 by DaveAuld

Too much data is breaking the system, we need a fix!

SQL

database

Developing Semantika Client Application

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

Displaying Update progress at center of gridview

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

grid

Binding

database

Documenting MS SQL Server Databases

27 Jun 2021 by Evgeniy Gribkov

The examples of SQL Server database documentation using both the extended properties and a third-party utility.

SQL

database

Dynamically Add Access Database Columns at Runtime using VB.NET

21 Apr 2013 by Rob Culhane

How to dynamically add access database columns at runtime using VB.NET

EF Code First and WPF with the Chinook Database. Part 3 – Styles and DataTemplates 101

12 Jan 2015 by Leom Burke

EF Code First and WPF with the Chinook Database - Styles and DataTemplates

database

Employee Info Starter Kit - Getting Started

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

SQL

server

database

Enterprise Application Architecture: Designing Applications and Services in .NET - Part II

15 Nov 2010 by venugopalm

Database and Library Design for Customer Order Management System

Entity Framework 7 – Code First – Using CLI

1 Jun 2023 by Mark Pelf

Tutorial on EF7 – Code First approach using Command Line (CLI)

.NET

entity-framework

database

Entity Framework 7 – Database First – Using CLI

25 May 2023 by Mark Pelf

Tutorial on EF7 – Database First approach using Command Line (CLI)

.NET

entity-framework

database

Entity Framework 7 – Database First – Using EFCorePowerTools

25 May 2023 by Mark Pelf

Tutorial on EF7 – Database First approach using GUI tools EFCorePowerTools

.NET

entity-framework

database

Entity Framework with nHydrate

14 Jul 2010 by Christopher R Davis, Michael S Knight

Generate an Entity Framework data access layer using an nHydrate model.

Fast External Sort in C#

14 Feb 2011 by Stefan Savev 2

Fast External Sort in C#: sort 30 GB of integers on an external USB drive in one hour

Windows

Dev

database

Fast Typo-Insensitive String Matching in a Program and a Database

12 Jul 2021 by David Wincelberg

Strings that differ by typos can be matched.

FlatFile Database System

2 Apr 2014 by Anand Gunasekaran

Working with text file as database can querying as RDBMS with SQL Queries.

Friday the 13th - JSON is Coming to SQL Server

8 Dec 2015 by Jovan Popovic(MSFT)

Overview of built-in support for JSON text processing in new SQL Server

Generated Columns in PostgreSQL

19 Sep 2019 by Shameel

This article describes different ways of setting up generated (computed) columns in different versions of PostgreSQL.

PostgreSQL

database

Generic Repository with SQLAlchemy and Python

5 Jul 2022 by DiponRoy

Example of Generic Repository Class with SQLAlchemy and Python

Python

ORM

database

Getting started with MongoDB

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

Getting Started with PouchDB - Part 1

15 Jan 2019 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.

Getting Started with PouchDB - Part 2

20 Jan 2019 by Paul D. Sheriff

In this 2nd part of my series on PouchDB, you learn how to perform multi-document inserts and reads.

Getting Started with PouchDB - Part 3

21 Jan 2019 by Paul D. Sheriff

In this article, the 3rd in a multi-part series, you are going to learn how to query data within a PouchDB database.

GraphQL: Evolution of Modern Age Database Management System

21 Aug 2019 by David Cuelogic

GraphQL: Evolution of Modern Age Database Management System

DBMS

graphql

database

Hidden Gems of DEFAULT TRACE in SQL Server

21 Mar 2016 by Sergii Syrovatchenko

Starting from SQL Server 2005, the default trace is enabled by default on every SQL server. Default trace is a lightweight system trace, which stores a lot of useful information about the changes in the system...

How to Create a Relevance Based Search Query for SQL

31 Dec 2010 by Manan J

Arrange Results to get the most relevant result first...

SQL

database

How to create Umbraco database on shared hosting.

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

How to do some magic with indexedDB

26 Mar 2014 by David Fahlander

Discover the hidden features of indexedDB!

How to Manipulate Hierarchical Information in Flat Relational Database Tables

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.

How to Save Object Graph in Master-Detail Relationship with One Stored Procedure

26 May 2023 by Vadim Loboda

A way to persist C# object graph to database with single procedure using ADO.NET and table valued parameters

SQL

DBA

database

How to stop creating the aspnetdb.mdf database

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.

iDb2Connection - How to cancel a long running query

7 Jun 2010 by Dylan Morley

Describes how you can run multiple queries against an iSeries DB2 and cancel long running queries.

Implement a Distributed Database to Your Java Application

7 Oct 2021 by Sam B. Brown

Interference open cluster is a simple Java framework that enables you to run a distributed database service within your Java application

Implementing a CQRS-based Architecture with MVC and Document DB

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.

Indexed Views and How It Can Help in Improving Query Performance

23 Mar 2019 by Minh Tuan Do

A considerable method to speed up query running time

Input, Output and Input/Output SqlParameter Behavior Explained

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.

Integrate Firebase Phone Authentication With Laravel

13 Aug 2018 by Member 13935194

In this article, I will demonstrate how to integrate Firebase phone number authentication in Laravel.

Introduction to B-trees: Concepts and Applications

20 Jan 2024 by Ștefan-Mihai MOGA

How to solve real-life problems using B-trees

Iterators and Snapshots for LevelDB UWP

13 Mar 2016 by Zohaib Sibte Hassan

A more detailed look into Iterators and Snapshots in LevelDB UWP

Jatalog: A Datalog Deductive Database in Java

27 Jul 2016 by Werner Stoop

A Java implement of Datalog, a subset of the Prolog programming language that is used as a query language in deductive databases

Kerosene ORM Dynamic Records In Depth

1 Mar 2015 by mbarbac

A deep dive tutorial on Kerosene ORM Dynamic Records and other core concepts of the library

Kerosene ORM Maps In Depth

1 Mar 2015 by mbarbac

A deep dive into the Kerosene ORM Entity Maps operational mode that provides full real support for POCO objects.

Kerosene ORM: a dynamic, configuration-less and self-adaptive ORM for POCO objects supporting a SQL-like syntax from C#

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.

LINQ to SQL Relationships

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

SQL

LINQ

database

LiteDB - A .NET NoSQL Document Store in a Single Data File

18 Oct 2017 by Mauricio David

Simple, fast and free embedded .NET NoSQL Document Store in single data file

LiteDB - A .NET NoSQL Document Store in a Single Data File

14 Oct 2015 by Terence Wallace

Alternative VB.NET version of "LiteDB - A .NET NoSQL Document Store in a single data file"

Locks and Duration of Transactions in MS SQL Server

8 Mar 2012 by Manjuke Fernando

Locks and duration of transactions in SQL Server

Manage Entity Framework Code First in Real Time Projects

28 Jul 2014 by DiponRoy

How to manage Entity Framework Code First in Real Time Projects

Manage SQL Server Database

23 Jan 2011 by Pranay Rana

Manage SQL Server Database within Visual Studio Team System

Visual-Studio

SQL-Server

database

Masking Sensitive Data with SQL Server 2016

15 Aug 2016 by Suvendu Shekhar Giri

How sensitive data in SQL Server 2016 can be masked from the outer world using Dynamic Data Masking

SQL-Server-2016

SQL-Server

database

Merge Data in Database

28 Jun 2022 by DiponRoy

How to use MERGE statements in different databases

metastrings: A Simple File-based Dynamic NoSQL Database

9 Aug 2021 by Michael Sydney Balloni

Learn about the inner workings of a dynamic database, and how SQLite is a great fit

Microsoft Access Application Development Guidelines

15 Jan 2013 by Marco Sorich

Some guidelines for developing better MS Access solutions.

Model-driven REST or GraphQL API for CRUD and More

11 May 2022 by Evoluteur

Generic REST or GraphQL endpoints for CRUD and more, written in JavaScript, using Node.js, Express, and PostgreSQL

Mongo DB Tutorial and Mapping of SQL and Mongo DB Query

18 Mar 2021 by VijayRana

A tutorial for MongoDB Tutorial

MongoDB Installation Scripts for Windows

17 Mar 2014 by x3F

Batch scripts that help install MongoDB on a Windows PC

MongoDB Tutorial - Day 2

11 Apr 2016 by VijayRana

MongoDB Tutorial - MongoDB specific queries

MongoDB Tutorial - Day 3 (Performance - Indexing)

18 Apr 2016 by VijayRana

Performance - Indexing in MongoDB

.NET

Dev

database

MongoDB Tutorial Day 4: Aggregation

21 May 2016 by VijayRana

Aggregation in MongoDB

SQL

MongoDB

database

MySQL Auto Failover using Keepalived on CentOS

5 Dec 2019 by Renz Ladroma

A tutorial on how to setup Keepalived for MySQL Auto Failover

Linux

MySQL

database

NodeJS REST server trials to validate effective scripting

7 May 2012 by Jason Rudland

Trial of popular REST implimentations for NodeJS including the measuring of MongoDB insertion rates.

NoSQL: MongoDB for Beginners

21 Feb 2016 by adityaswami89

NoSQL: MongoDB for beginners

SQL

NoSQL

database

NoSqlJsonFile - .NET lightweight Document Store

13 Mar 2013 by PraiseTheSun

A NoSQL-like document store in JSON format.

JSON

database

One to Zero/One Relation in Entity Framework Code First

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

Options for Database Backup and Restore - How to Export BACPAC using SSMS?

6 Apr 2021 by Satya Karki

This article describes the options to restore and backup database in SQL Server and explains how to Export BACPAC from SQL Server Management Studio.

database

migration

application