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

ADO.NET

ADO.NET

Great Reads

by Suresh Dasari's
Auto Generate Code (CRUD) for 3 Layered architecture (Entity, Data Access & Business Layer) with Stored Procedures based on table design.
by ortund
Login system with breach redundancy handling.
by KRucker
A description of how how to convert a .NET DataSet to an ADODB Recordset.
by John Kenedy S.Kom
This project enables developers to create a setup package that automatically installs MSDE and attaches database

Latest Articles

by Suresh Dasari's
Auto Generate Code (CRUD) for 3 Layered architecture (Entity, Data Access & Business Layer) with Stored Procedures based on table design.
by ortund
Login system with breach redundancy handling.
by KRucker
A description of how how to convert a .NET DataSet to an ADODB Recordset.
by John Kenedy S.Kom
This project enables developers to create a setup package that automatically installs MSDE and attaches database

All Articles

Sort by Score

ADO.NET 

by JasonShort
Here are 10 things to make your desktop database apps better
by Arun Ramachandran India
ADO.NET – How to call a stored procedure with output parameters?
by Abhishek Sur
ADO.NET - Some Internals Uncovered
by Abhishek Sur
ADO.NET : Some internals uncovered
by jgauffin
The library is a complete ADO.NET driver which is designed to aid you in unit testing.
by jgauffin
This post will teach you everything from making your ADO.NET code driver independent to how to implement the repository pattern and unit of work.
by Manjuke Fernando
Always encrypted feature in SQL Server 2016
by Bipin Radhakrishnan
Introduction We use Asp grid view to display various information and we may have come across multiple scenarios where we
by rahulsahay20
ASP.NET 5 Features - Part 1
by Sebastian Solnica
In this post, I will show you an interesting problem that we experienced when querying a SQL Server database with Dapper.
by CoderPanda
Book review for "ASP.NET 4.0 in practice"
by JasonShort
Plugins are used in data applications to support more than one provider from a single codebase. The Provider Factories in ADO.NET is one such example, but you cannot work with the provider specific features when you use these factories since they only implement generic ADO.NET functions.
by Rui Jarimba
This is the first of a two part series about how to perform bulk inserts in your .NET applications, using a SQL Server database.
by Sibeesh Passion
How to use caching in Web API
by Ben Kotvis
Complex queries with Repository Pattern and the Entity Framework.
by Joe Rattz
How to control collation order on DB2/400
by Mohammad Elsheimy
Give the user the flexibility to design his sheet, report, bill, invoice, whatever.
by Sebastian Solnica
How to diagnose ADO.NET with ETW traces
by Pieter Van Parys
Implementing an ADO.NET Profiler.
by Leom Burke
A look at unit testing data access when using Entity Framework code first
by Gil Fink
One of the important tools in your tool arsenal when you develop with an ORM tool is a profiler. This is a review of EFProf.
by Rui Jarimba
A simple Entity Framework T4 template that generates GetHashCode() method
by User 6619207
Entity Framework Code First and WCF Data Services
by Rui Jarimba
Extension methods for ObjectContext and DbContent to get the mapped table name from an entity
by Martin Jarvis
Experiments with ADO.NET, extension methods and anonymous methods
by JasonShort
Exposing OData from an Entity Framework Model
by Tharaka MTR
Generate insert statements from a specific table data using SQL Server
by evry1falls
How to implement Google.Apis.Drive.v3 in a WinForms Project using VB 2015 and .NET 4.5
by Rui Inacio
To bulk insert efficiently, the SqlBulkCopy class must be used.
by atverma
Criteria behind choosing IDisposable, IComponent, Component, MarshalByValueComponent and base Control classes(System.Windows.Form.Control and System.Web.UI.Control) while implementing a Class
by Libish Varghese Jacob
Configuring and using Entity Framework 4.1 for my Open Source project.
by Tharaka MTR
This post will show you how to fix orphaned SQL users.
by raju melveetilpurayil
Explaining how to store,display, create thumbnails and add watermark on image
by Morshed Anwar
Implementing Repository Pattern with EF4 POCO support.
by JasonShort
LINQPad helps you learn LINQ
by Sibeesh Passion
How to load data from database using Web API
by Debopam Pal
Using Microsoft.Office.Interop.Excel library, you can bring your data from your database against LINQ query and store them into an Excel Sheet.
by Gil Fink
The post shows how to combine Table Per Hierarchy and Entity Splitting methods
by JasonShort
ADO.NET is a set of libraries included in the .NET Framework to facilitate the communication of applications with various data storage mechanisms. These libraries form the basis for all third parties to provide database access.
by JasonShort
A high level overview of the ADO.NET object model and how VistaDB supports that model
by Mohammad Elsheimy
Programmatically Enumerating, Attaching, and Detaching SQL Server Databases via SQL statements and stored procedures
by jgauffin
Griffin DAL Generator – Take 2
by Gil Fink
This post will introduce the select N+1 pitfall and explain how to avoid it in Entity Framework.
by Salmanzz
State Design Pattern
by Sam Meacham
So what’s wrong with EF’s TPT inheritance? The SQL that EF generates. With some simple testing (2 or 3 subclasses) everything may appear to be fine. In fact, you may even be impressed that EF manages to fetch all the data you need in a single trip, indeed, in a single query.
by dibley1973
The stored procedure framework now supports dynamic fields within multiple recordsets
by outcoldman
TSQL: Passing array/list/set to stored procedure (Microsoft SQL Server)
by jgauffin
How to create a Unit Of Work implementation for ADO.NET
by Sander Rossel
Using C# to get data in- and out of your (relational) database
by Sander Rossel
Need some flexible in-memory data cache? DataSets might be what you're looking for...
by Sky Sanders
A strategy for implementing maintaining separation of concerns and implementation hiding.
by Mohammad Elsheimy
Binary Large Objects (BLOBs) are pieces of data that have -usually- exceptionally large size (such as pictures or audio tracks).