Click here to Skip to main content
13,897,037 members


Great Reads

by Rob Culhane
Dynamically add access database columns at runtime using
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.
by Nikola M. Živković
Introduction to NoSQL and Polyglot Persistence
by Ed Wiebe
Can't we obtain the benefit of using bitwise operators for SQL many-to-many relationships AND maintain referential integrity?

Latest Articles

by nickdenker
An ORM style layer which turns Azure Table Storage into a cheap and scalable indexed noSQL database - without the costs associated with Azure CosmosDB.
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.
by Paul D. Sheriff
In this 2nd part of my series on PouchDB, you learn how to perform multi-document inserts and reads.
by Evoluteur
RESTful generic endpoints for CRUD and more, written in JavaScript, using Node.js, Express, and PostgreSQL

All Articles

Sort by Updated


22 Feb 2016
NoSQL: MongoDB for beginners
10 Sep 2014
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
13 Apr 2018
Alaa Ben Fatma
Within this article, we will walk through the basic concepts of de/serialization and how to create a very basic de/serializer.
6 Aug 2010
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
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
Anand Gunasekaran
Working with text file as database can querying as RDBMS with SQL Queries.
10 Jan 2018
A simple yet powerful tool to analyse SQL object dependencies in quite fast and reliable manner.
11 Oct 2013
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
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
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
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
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
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
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
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
ASP.NET Community
If you use the membership providers, having visual studio keep this sql database file around for deployment can sometimes be convenient.
14 Jan 2014
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
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
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
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
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
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
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
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
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
ASP.NET Community
Stored Procedure should look like thisCREATE PROCEDURE [dbo].[Purchases_Insert]    (@SupplierID     bigint,     @ReferenceNo     NVARCHAR(20),    
11 Oct 2013
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
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
ASP.NET Community
This example will show how is possible to upload files to SQL server database using C# and For demostration purposes database will have only
20 Jan 2016
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
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.
1 Nov 2016
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.
7 Nov 2017
Bruce Yang CL
A distributed system architecture, mobile devices around the world, free charge to construct your global application.
12 Sep 2017
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.
14 Mar 2013
A NoSQL-like document store in JSON format.
3 Jul 2017
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
Christopher R Davis, Michael S Knight
Generate an Entity Framework data access layer using an nHydrate model.
8 Aug 2012
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
26 Jul 2018
Dathuraj Pasarge
Mirroring setup without any DBA effort - on every new DB creation on the SQL Server !!!
30 Nov 2013
Too much data is breaking the system, we need a fix!
14 May 2015
Using SIML, a language designed for Digital Assistants, to create a Natural Language Interface to an SQL Database.
26 Mar 2014
David Fahlander
Discover the hidden features of indexedDB!
29 Jul 2014
How to manage Entity Framework Code First in Real Time Projects
13 Aug 2014
Here, we will see how to configure one to zero/one relation between two entities in Entity Framework Code First
15 Sep 2014
Some queries to find generation of each row, all possible children, all possible parents, managing recursion
7 Jun 2010
Dylan Morley
Describes how you can run multiple queries against an iSeries DB2 and cancel long running queries.
26 Jul 2017
Ed Wiebe
Can't we obtain the benefit of using bitwise operators for SQL many-to-many relationships AND maintain referential integrity?
8 Jun 2010
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
A step wizard for ASP.NET to export database objects to CSV, TXT, HTML, XML, or SQL
15 Jan 2019
RESTful generic endpoints for CRUD and more, written in JavaScript, using Node.js, Express, and PostgreSQL
21 Sep 2016
Use SQL Server to manage completely databases backups, network copy and deletion using only stored procedures
1 Jul 2018
DotNet.Core.SQLite - A lightweight performance wrapper library for working with SQLite including usage examples in C# & VB
15 May 2013
Implementation of relative database constraints and permissioning using triggers and shadow tables.
7 Feb 2017
Learn how to implement a real stream file based dataset descendant with blob support and much more.
28 Sep 2011
Ivan Vodišek
An alternative approach to database modeling.
24 Jan 2012
Jaganathan Bantheswaran
A tool to generate Sql server DB script from the LightSwitch internal database
7 May 2012
Jason Rudland
Trial of popular REST implimentations for NodeJS including the measuring of MongoDB insertion rates.
10 Feb 2016
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
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
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
Jovan Popovic(MSFT)
Overview of built-in support for JSON text processing in new SQL Server
31 Oct 2017
SQL 2017 New features
12 Jan 2015
Leom Burke
EF Code First and WPF with the Chinook Database - Styles and DataTemplates
20 Jun 2013
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
Mahsa Hassankashi
This article is the most complete essay about big data from scratch to practical.
31 Dec 2010
Manan J
Arrange Results to get the most relevant result first...
8 Mar 2012
Manjuke Fernando
Locks and duration of transactions in SQL Server
25 Oct 2014
Marc Clifton
No word has a value that can be identified independently of what else is in its vicinity.
15 Jan 2013
Marco Sorich
Some guidelines for developing better MS Access solutions.
18 Oct 2017
Mauricio David
1 alternative  
A simple, fast and free embedded .NET NoSQL Document Store in a single data file. Inspired on MongoDB, supports collections, POCO classes, Bson Documents, indexes, stream data and LINQ expressions.
11 Oct 2013
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)
14 Aug 2018
Member 13935194
In this article, I will demonstrate how to integrate Firebase phone number authentication in Laravel.
14 Apr 2015
Menci Lucio
I wrote a class to have an access to all databases in the simplest and smartest way
16 Feb 2013
Michael Haephrati
The DataTune system was one of the earliest data cleansing systems.
21 Dec 2017
Miguel Diaz Kusztrich
A database tool for search text in procedures, views and tables using regular expressions
2 Mar 2015
Moises Barba
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
Moises Barba
A deep dive into the Kerosene ORM Entity Maps operational mode that provides full real support for POCO objects.
1 Mar 2015
Moises Barba
A deep dive tutorial on Kerosene ORM Dynamic Records and other core concepts of the library
5 Sep 2013
Mr. xieguigang 谢桂纲
Easy way to map the table in the mysql database.
20 Jul 2014
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
Build your own database class library with C#
28 Nov 2016
Neal Pandey
This article is a tutorial on creating a basic OData (Open Data Protocol) endpoint for a MongoDB database using MEAN stack.
13 Feb 2013
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
15 Jan 2019
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.
21 Jan 2019
Paul D. Sheriff
In this 2nd part of my series on PouchDB, you learn how to perform multi-document inserts and reads.
21 Jan 2019
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.
16 Oct 2014
Pavel Durov
Article about dynamic Sqlite database management on Android platform using Java class reflection.
26 Feb 2016
Pavel Sinkevich
How to programmatically change schema name in database project before deployment
14 Jul 2011
5 Database Worst Practices which can be fatal to any business
23 Jan 2011
Pranay Rana
Manage SQL Server Database within Visual Studio Team System
1 Feb 2018
Praveen P R
This article presents a simple and efficient way to bulk insert any .NET list to the database.
2 Feb 2018
Private Dobbs
How to initialise a database and then automatically keep it up to date with version releases
6 Sep 2018
QxOrm C++ library: Persistence (based on QtSql Qt library) - Serialization (based on boost::serialization library) - Reflection (introspection)
14 Aug 2017
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.
5 Jun 2013
Rajat Bittharia
Grid based on JSON data using MVC with Entity Framework and MySQL.
10 Apr 2015
Rajeesh Madambat
Refer and write your own business logic in C# and add it to SSIS script task.
11 Jul 2016
This article will surely give an idea how to develop a self-controlled, self-connected smart home/building.
21 Dec 2018
Renz Ladroma
A tutorial on how to setup Keepalived for MySQL Auto Failover
6 May 2016
Riccardo Cervelli
Sample for custom entity data model and jSon query with SqlServer 2016
21 Apr 2013
Rob Culhane
Dynamically add access database columns at runtime using
4 Dec 2013
Sergey Syrovatchenko
This article includes examples of T-SQL capabilities that allow to perform string concatenation flexibly and effectively through the use of different constructs.
21 Mar 2016
Sergey 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...
24 Oct 2014
Shivprasad koirala, Marla Sukesh
This is the part 3 of the series Learn MSBI step by step
5 May 2014
Shuqian Ying
Client side data provider for data importing to a relational data service build for StackExchange data dump.
23 Feb 2016
Sreekanth Mothukuru
In this article, we are going to look at one of the most useful features in Visual Studio that is often ignored or to be frank, many people don’t even know about its existence. We are going to look at Free SQL Server Schema Comparison Tool in Visual Studio 2013.
24 Oct 2017
Sreekanth Mothukuru
Create a Data-Tier Application Package (DacPac) to easily manage, deploy and deliver chronological database changes onto multiple environments
14 Feb 2011
Stefan Savev 2
Fast External Sort in C#: sort 30 GB of integers on an external USB drive in one hour
16 Aug 2016
Suvendu Shekhar Giri
We'll see how sensitive data in SQL Server 2016 can be masked from outer world using Dynamic Data Masking.
24 Aug 2016
Suvendu Shekhar Giri
Introduction of new useful features in SSMS 2016
7 Nov 2015
Syed Hasan Hyder
Provides plausible and high performing data display, for very large data ( over a million records ).
14 Oct 2015
Terence Wallace
This is an alternative VB.NET version of "LiteDB - A .NET NoSQL Document Store in a single data file"
11 Jun 2013
Tom Glick Philadelphia, US
Using WCF REST Service to call Stored Procedures and run queries on SQL Server.
30 Oct 2014
Vaclav Naydenov
How C++ library YB.ORM can help manipulate the data stored in RDBMS using domain classes. Basic concepts of ORM are explained by examples.
28 Jan 2015
Vaclav Naydenov
Comparing the performance of two similar CRUD server apps, one written in Python and SQLAlchemy, the other in C++ and YB.ORM.
14 Sep 2014
Lean about how to manage the data
21 Nov 2013
Fetching complex data from multiple table using nested MySQL queries, JOIN operations, LIKE operator and aggregate functions(eg. GROUP BY, GROUP_CONCAT, etc.)
19 Apr 2016
Mongo DB Tutorial and Mapping of SQL and Mongo DB Query
11 Apr 2016
MongoDB Tutorial - MongoDB specific queries
19 Apr 2016
MongoDB Tutorial - Day 3 (Performance - Indexing)
21 May 2016
MongoDB Tutorial Day 4 :- Aggregation
27 Jul 2016
Werner Stoop
A Java implement of Datalog, a subset of the Prolog programming language that is used as a query language in deductive databases
25 Jul 2012
Wilson Hu 1
This article tries to fit all levels of readers by covering both basic database concept and practical tips for handling Entity Framework.
17 Mar 2014
Batch scripts that help install MongoDB on a Windows PC
27 May 2018
Yuancai (Charlie) Ye
Application of SocketPro onto various databases for continuous inline request/result batching and real-time stream processing with bi-directional asynchronous data transferring
13 Mar 2016
Zohaib Sibte Hassan
A more detailed look into Iterators and Snapshots in LevelDB UWP

Advertise | Privacy | Cookies | Terms of Service
Web02 | 2.8.190306.1 | Last Updated 20 Mar 2019
Copyright © CodeProject, 1999-2019
All Rights Reserved.
Layout: fixed | fluid