Click here to Skip to main content
65,938 articles
CodeProject is changing. Read more.
Everything / database

Database

database

Great Reads

by ASP.NET Community
IntroductionnAML (.NET Application Modeling Language, pronounced as “namel”) is a visual modeling semantics to model .net applications with wide
by JasonShort
Here are 10 things to make your desktop database apps better
by Michael Sydney Balloni
Wanna add basic database functionality to your C++ app? Too lazy to use SQLite directly? Read on!
by SrikantSahu
This tip gives basic commands to import table from Mysql to Hadoop File system and Import the files from HDFS back to Mysql.

Latest Articles

by ASP.NET Community
IntroductionnAML (.NET Application Modeling Language, pronounced as “namel”) is a visual modeling semantics to model .net applications with wide
by JasonShort
Here are 10 things to make your desktop database apps better
by Michael Sydney Balloni
Wanna add basic database functionality to your C++ app? Too lazy to use SQLite directly? Read on!
by SrikantSahu
This tip gives basic commands to import table from Mysql to Hadoop File system and Import the files from HDFS back to Mysql.

All Articles

Sort by Updated

database 

by ASP.NET Community
IntroductionnAML (.NET Application Modeling Language, pronounced as “namel”) is a visual modeling semantics to model .net applications with wide
by Michael Sydney Balloni
Wanna add basic database functionality to your C++ app? Too lazy to use SQLite directly? Read on!
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
by Private Dobbs
How to initialise a database and then automatically keep it up to date with version releases
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.
by Menci Lucio
I wrote a class to have an access to all databases in the simplest and smartest way
by Varavut
Lean about how to manage the data
by Pavel Durov
Article about dynamic Sqlite database management on Android platform using Java class reflection.
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
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
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.
by Bert O Neill
Features and functionalities associated with Autogenerate DB Unit Test app
by Dathuraj Pasarge
Database mirroring setup without any DBA effort - on every new database creation
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.
by Mahsa Hassankashi
This article is the most complete essay about big data from scratch to practical.
by Ivan Vodišek
An alternative approach to database modeling.
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
by nam1234567
Build your own database class library with C#
by Praveen P R
This article presents a simple and efficient way to bulk insert any .NET list to the database.
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
by Dan Ionescu (USINESOFT)
LINQ extensions that allow to describe and to safely query cached data
by DiponRoy
Conditional filter query example in SQLAlchemy and Python
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
by Rajat Bittharia
Grid based on JSON data using MVC with Entity Framework and MySQL.
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
by ASP.NET Community
Let see an example of using the database in LINQ and C#.netcf We will using classCustomer Here'ssome sample
by Neal Pandey
This article is a tutorial on creating a basic OData (Open Data Protocol) endpoint for a MongoDB database using MEAN stack.
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.
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
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
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
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
by Olivier_Giulieri
A step wizard for ASP.NET to export database objects to CSV, TXT, HTML, XML, or SQL
by pinaldave
5 Database Worst Practices which can be fatal to any business
by Michael Haephrati
A Static Library which can be used for all kinds of database related needs
by DaveAuld
Too much data is breaking the system, we need a fix!
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
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.
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
by Evgeniy Gribkov
The examples of SQL Server database documentation using both the extended properties and a third-party utility.
by Rob Culhane
How to dynamically add access database columns at runtime using VB.NET
by Leom Burke
EF Code First and WPF with the Chinook Database - Styles and DataTemplates
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
by Mark Pelf
Tutorial on EF7 – Code First approach using Command Line (CLI)
by Mark Pelf
Tutorial on EF7 – Database First approach using Command Line (CLI)
by Mark Pelf
Tutorial on EF7 – Database First approach using GUI tools EFCorePowerTools
by Christopher R Davis, Michael S Knight
Generate an Entity Framework data access layer using an nHydrate model.
by Stefan Savev 2
Fast External Sort in C#: sort 30 GB of integers on an external USB drive in one hour
by David Wincelberg
Strings that differ by typos can be matched.
by Anand Gunasekaran
Working with text file as database can querying as RDBMS with SQL Queries.
by Jovan Popovic(MSFT)
Overview of built-in support for JSON text processing in new SQL Server
by Shameel
This article describes different ways of setting up generated (computed) columns in different versions of PostgreSQL.
by DiponRoy
Example of Generic Repository Class with SQLAlchemy and Python
by DaveNoderer
In this article, we explore how to set up one component, an SQL pool.
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
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 Paul D. Sheriff
In this 2nd part of my series on PouchDB, you learn how to perform multi-document inserts and reads.
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 David Cuelogic
GraphQL: Evolution of Modern Age Database Management System
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...
by William Lyon
GraphQL APIs, backed by Neo4j – a native graph database – enable complex relationships to be easily modeled, queried, and resolved. That could be a boon for newsrooms where usually nothing comes easily.
by Kintone Developer Program
This article introduces how to capture Google Form responses into a Kintone Database, instead of capturing them in a spreadsheet.
by Manan J
Arrange Results to get the most relevant result first...
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
by David Fahlander
Discover the hidden features of indexedDB!
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.
by Vadim Loboda
A way to persist C# object graph to database with single procedure using ADO.NET and table valued parameters
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.
by Dylan Morley
Describes how you can run multiple queries against an iSeries DB2 and cancel long running queries.
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
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.
by Minh Tuan Do
A considerable method to speed up query running time
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.
by Member 13935194
In this article, I will demonstrate how to integrate Firebase phone number authentication in Laravel.
by Ștefan-Mihai MOGA
How to solve real-life problems using B-trees
by Zohaib Sibte Hassan
A more detailed look into Iterators and Snapshots in LevelDB UWP
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
by mbarbac
A deep dive tutorial on Kerosene ORM Dynamic Records and other core concepts of the library
by mbarbac
A deep dive into the Kerosene ORM Entity Maps operational mode that provides full real support for POCO objects.
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.
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
by Mauricio David
Simple, fast and free embedded .NET NoSQL Document Store in single data file
by Terence Wallace
Alternative VB.NET version of "LiteDB - A .NET NoSQL Document Store in a single data file"
by Manjuke Fernando
Locks and duration of transactions in SQL Server
by DiponRoy
How to manage Entity Framework Code First in Real Time Projects
by Pranay Rana
Manage SQL Server Database within Visual Studio Team System
by Suvendu Shekhar Giri
How sensitive data in SQL Server 2016 can be masked from the outer world using Dynamic Data Masking
by DiponRoy
How to use MERGE statements in different databases
by Michael Sydney Balloni
Learn about the inner workings of a dynamic database, and how SQLite is a great fit
by Marco Sorich
Some guidelines for developing better MS Access solutions.
by Olivier_Giulieri
Generic REST or GraphQL endpoints for CRUD and more, written in JavaScript, using Node.js, Express, and PostgreSQL
by VijayRana
A tutorial for MongoDB Tutorial
by x3F
Batch scripts that help install MongoDB on a Windows PC
by VijayRana
MongoDB Tutorial - MongoDB specific queries
by VijayRana
Performance - Indexing in MongoDB
by VijayRana
Aggregation in MongoDB
by Renz Ladroma
A tutorial on how to setup Keepalived for MySQL Auto Failover
by Jason Rudland
Trial of popular REST implimentations for NodeJS including the measuring of MongoDB insertion rates.
by adityaswami89
NoSQL: MongoDB for beginners
by PraiseTheSun
A NoSQL-like document store in JSON format.
by Kintone Developer Program
This article introduces how to utilize Slack’s Incoming Webhook feature, to post messages into Slack channels when a workflow status of a record in a Kintone App is proceeded to "Completed".
by DiponRoy
Here, we will see how to configure one to zero/one relation between two entities in Entity Framework Code First
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.
by Pavel Sinkevich
How to programmatically change schema name in database project before deployment
by Vaclav Naydenov
Comparing the performance of two similar CRUD server apps, one written in Python and SQLAlchemy, the other in C++ and YB.ORM.
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
by 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.
by QxOrm
QxOrm C++ library: Persistence (based on QtSql Qt library) - Serialization (based on boost::serialization library) - Reflection (introspection)
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.    <asp:RadioButtonList
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)
by Rajeesh Madambat
Refer and write your own business logic in C# and add it to SSIS script task.
by h_wiedey
Implementation of relative database constraints and permissioning using triggers and shadow tables.
by Shameel
This article describes a way to create a Facade Database to provide restricted access to specific tables in your databases to specific users without granting direct access to any of the underlying databases/tables.
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
by ASP.NET Community
Stored Procedure should look like thisCREATE PROCEDURE [dbo].[Purchases_Insert]    (@SupplierID     bigint,     @ReferenceNo     NVARCHAR(20),
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.
by Marc Clifton
No word has a value that can be identified independently of what else is in its vicinity.
by Shuqian Ying
Client side data provider for data importing to a relational data service build for StackExchange data dump.
by Zohaib Waqar
Simplifying data access using class libraries and Entity Framework without the need for a .edmx file (ADO.NET)
by Ivan Yakimov
How to use single database to store information from several microservices with the help of FluentMigrator
by Jerry Cruise
Innovations against the shortcomings of SQL have been made to SPL. SPL redefines and extends many operations of structured data, specifically, it adds the discreteness, enhances ordered computation, implements a thorough set orientation, supports object references, and advocates stepwise operation.
by koolprasad2003
SQL 2017 new features
by koolprasad2003
New features of SQL 2019
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.
by ASkaeff
A simple yet powerful tool to analyze SQL object dependencies in quite a fast and reliable manner.
by DiponRoy
Some queries to find generation of each row, all possible children, all possible parents, managing recursion
by Ravi K. Acharya
The complete step-by-step guide to build a CI/CD pipeline for your Microsoft SQL Server database using Github, TeamCity and Octopus.
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
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.
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.
by Sergei Y.Kitáev
Introduction to statically parameterized SQL language
by Mark Pelf
Showing problems with limited accuracy of SqlServer data type “datetime” in .NET7 EF7 environment
by Sergii Syrovatchenko
This article includes examples of T-SQL capabilities that allow to perform string concatenation flexibly and effectively through the use of different constructs.
by OriginalGriff
There are many things you can use to store information, but not all of them are databases. And trying to use them as such is a really, really bad idea.
by Michael Haephrati
The DataTune system was one of the earliest data cleansing systems.
by hamdenvogel
Learn how to implement a real stream file based dataset descendant with blob support and much more
by Suvendu Shekhar Giri
Introduction of new useful features in SSMS 2016
by Levente Kupás
If you have big reports which run slowly, you may use this T-SQL based engine to speed-up them.
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.
by Vijay-Srivastava
Fetching complex data from multiple table using nested MySQL queries, JOIN operations, LIKE operator and aggregate functions(eg. GROUP BY, GROUP_CONCAT, etc.)
by Nicolas DESCARTES
What are vector databases?
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)
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
by Aleksandr Ulanov
Learn how to use Redis and its geospatial indexes and commands for complex geo calculations
by Tom Glick Philadelphia, US
Using WCF REST Service to call Stored Procedures and run queries on SQL Server.
by Mr. xieguigang 谢桂纲
Easy way to map the table in the mysql database.
by Jaganathan Bantheswaran
A tool to generate SQL server DB script from the LightSwitch internal database
by Jason_Koo
In this article we look at why when store and query data using a graph database such as Neo4j, you can quickly surface critical information, and possibly expose potentially catastrophic issues hidden within complex datasets.
by Olivier_Giulieri
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.
by Andriy Protskiv
Workaround for performance issues with AT TIME ZONE