Click here to Skip to main content

Submit your article

ADO.NET

ADO.NET

Great Reads

Loading Related Entities with Entity Framework - A Beginner's Primer

by David Rogers Dev

Learn how to load related entities using the Entity Framework with simple examples

Data Debugger Visualizer

by dotnetdan

VS 2005 debug visualizers for DataSet, DataTable, DataView, DataRow and DataColumn objects.

CurionLib Dynamic Data Entry Forms

by LarryCharlton

Dynamic data forms.

Client Side Multi-Column Dynamic Pivot

by Jesús López Méndez

This article introduces you to client side multi-column dynamic pivot, a cleaner, simpler and elegant alternative to the complex and convoluted dynamic server side pivot.

Latest Articles

Power Your .NET REST API with Data Queries and Reports

by Jani Giannoudis

REST API Reporting for .NET

Unit Test Your Database Classes

by freedeveloper

How to create a data access class in a way, that is possible to execute unit test on it

Managing GridView/DataGrid Control Programmatically in Visual Studio (C#) Web Form

by Raphael Adeniji

Many a times, we need to programmatically manage GridView/DataGrid in Visual Studio web applications and this looks very difficult because we do not know what properties or events of the control to use. It may also be as a result of time constraint.

UkrGuru.SqlJson Your Link Between SQL Server and .NET 5

by Oleksandr Viktor (UkrGuru)

Minimally simple UkrGuru.SqlJson package for modern data manipulation

All Articles

ADO.NET

How to Fix Orphaned SQL Users

26 May 2013 by Tharaka MTR

This post will show you how to fix orphaned SQL users.

SQL-Server-2005

SQL-server-2000

Load Data From Database Using Web API

2 Nov 2015 by Sibeesh Passion

How to load data from database using Web API

The Stored Procedure Framework Now Supports Dynamic Fields within Multiple Recordsets

1 Aug 2016 by dibley1973

The stored procedure framework now supports dynamic fields within multiple recordsets

How to Bulk Insert Efficiently

23 Jul 2012 by Rui Inacio

To bulk insert efficiently, the SqlBulkCopy class must be used.

Generate insert Statements from a Specific Table Data using SQL Server

27 May 2013 by Tharaka MTR

Generate insert statements from a specific table data using SQL Server

SQL-Server-2008

SQL-Server-2005

Creating a Simple Sheet Designer in C#

11 Apr 2010 by Mohammad Elsheimy

Give the user the flexibility to design his sheet, report, bill, invoice, whatever.

Diagnosing ADO.NET with ETW Traces

15 Sep 2012 by Sebastian Solnica

How to diagnose ADO.NET with ETW traces

Always Encrypted Feature in SQL Server 2016

19 Oct 2016 by Manjuke Fernando

Always encrypted feature in SQL Server 2016

SQL-Server-2016

DIY ADO.NET Profiler

9 Jul 2012 by Pieter Van Parys

Implementing an ADO.NET Profiler.

Mixing Table Per Hierarchy and Entity Splitting

8 Aug 2010 by Gil Fink

The post shows how to combine Table Per Hierarchy and Entity Splitting methods

entity-framework

Overview of ADO.NET

5 Jan 2012 by JasonShort

A high level overview of the ADO.NET object model and how VistaDB supports that model

Be Careful with varchars in Dapper!

16 May 2013 by Sebastian Solnica

In this post, I will show you an interesting problem that we experienced when querying a SQL Server database with Dapper.

Controlling Collation Order On DB2/400

13 Apr 2010 by Joe Rattz

How to control collation order on DB2/400

EF Code First and WPF with the Chinook database. Part 1c – the unit tests

7 Feb 2011 by Leom Burke

A look at unit testing data access when using Entity Framework code first

entity-framework

Book Review: ASP.NET 4.0 in Practice

10 Feb 2014 by CoderPanda

Book review for "ASP.NET 4.0 in practice"

Select N+1 Problem – How to Decrease Your ORM Performance

18 Aug 2010 by Gil Fink

This post will introduce the select N+1 pitfall and explain how to avoid it in Entity Framework.

entity-framework

How to configure and use Entity Framework

16 Jul 2012 by Libish Varghese Jacob

Configuring and using Entity Framework 4.1 for my Open Source project.

ADO.NET - Some Internals Uncovered

18 Dec 2010 by Abhishek Sur

ADO.NET - Some Internals Uncovered

Entity Framework: Get Mapped Table Name from an Entity

19 Mar 2012 by Rui Jarimba

Extension methods for ObjectContext and DbContent to get the mapped table name from an entity

entity-framework

ADO.NET : Some internals uncovered - Part 2

1 Jan 2011 by Abhishek Sur

ADO.NET : Some internals uncovered

Image Handling In ASP.NET

2 Feb 2012 by raju melveetilpurayil

Explaining how to store,display, create thumbnails and add watermark on image

Complex Queries With Repository Pattern and the Entity Framework

6 Nov 2012 by Ben Kotvis

Complex queries with Repository Pattern and the Entity Framework.

Bulk Insert in .NET Applications: Part 1

26 Mar 2012 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.

10 Things to Make Your Desktop Database Apps Better

3 Feb 2011 by JasonShort

Here are 10 things to make your desktop database apps better

Working with SQL Server BLOB Data in .NET

11 May 2010 by Mohammad Elsheimy

Binary Large Objects (BLOBs) are pieces of data that have -usually- exceptionally large size (such as pictures or audio tracks).

Repository Generator

5 Feb 2016 by jgauffin

Griffin DAL Generator – Take 2

Using C# to Connect to and Query from a SQL Database

16 Mar 2015 by Sander Rossel

Using C# to get data in- and out of your (relational) database

ADO.NET, The Right Way

28 Aug 2013 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.

The Entity Framework (v1 and v4) Deal Breaker: TPT Inheritance

18 Mar 2010 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.

entity-framework

Entity Framework and T4: Generating GetHashCode() for your entities

19 Dec 2011 by Rui Jarimba

A simple Entity Framework T4 template that generates GetHashCode() method

LINQPad Helps You Learn LINQ

7 Aug 2017 by JasonShort

LINQPad helps you learn LINQ

TSQL: Passing Array/List/Set to Stored Procedure (Microsoft SQL Server)

29 Jun 2017 by outcoldman

TSQL: Passing array/list/set to stored procedure (Microsoft SQL Server)

Programmatically Enumerating, Attaching, and Detaching SQL Server Databases

2 Jun 2010 by Mohammad Elsheimy

Programmatically Enumerating, Attaching, and Detaching SQL Server Databases via SQL statements and stored procedures

ADO.NET – How to Call A Stored Procedure with Output Parameters?

24 Mar 2014 by Arun Ramachandran India

ADO.NET – How to call a stored procedure with output parameters?

EFProf – Profiler Tool for Entity Framework

11 Aug 2010 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.

entity-framework

Overview of ADO.NET

7 Aug 2017 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.

Implementing Repository Pattern with EF4 POCO support

30 Jul 2012 by Morshed Anwar

Implementing Repository Pattern with EF4 POCO support.

Map Data from Database Context to Excel Sheet using LINQ & Microsoft.Office.Interop.Excel

16 Nov 2013 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.

SQL-Server-2008

Using DataSets to work with (relational) in-memory data

16 Mar 2015 by Sander Rossel

Need some flexible in-memory data cache? DataSets might be what you're looking for...

WCF: Loose coupling of WCF Service and Data Contracts

1 Feb 2010 by Sky Sanders

A strategy for implementing maintaining separation of concerns and implementation hiding.

SQL-Server-2005

State Design Pattern

14 Aug 2009 by Salmanzz

State Design Pattern

Building a plug-in model to load VistaDB - Part II

22 Jun 2010 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.

Unit of Work Sample Implementation for ADO.NET

10 Jan 2014 by jgauffin

How to create a Unit Of Work implementation for ADO.NET

Caching in Web API

25 Mar 2016 by Sibeesh Passion

How to use caching in Web API

Exposing OData from an Entity Framework Model

10 Jun 2010 by JasonShort

Exposing OData from an Entity Framework Model

entity-framework

How to Choose between IDisposable, IComponent, Component, MarshalByValueComponent and Control while Implementing a Class

31 Jul 2010 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

Experiments with ADO.NET, Extension Methods and Anonymous Methods

21 Jul 2011 by Martin Jarvis

Experiments with ADO.NET, extension methods and anonymous methods

ADO.NET Fakes Version 2.0

26 Feb 2013 by jgauffin

The library is a complete ADO.NET driver which is designed to aid you in unit testing.

ASP.NET 5 – Part I

8 May 2015 by rahulsahay20

ASP.NET 5 Features - Part 1

Google Drive API Source Code with WinForm & MS-Access Database Example

9 May 2020 by evry1falls

How to implement Google.Apis.Drive.v3 in a WinForms Project using VB 2015 and .NET 4.5

Entity Framework Code First and WCF Data Services

10 Sep 2010 by User 6619207

Entity Framework Code First and WCF Data Services

Asp Grid View with custom column for Text box and Button control for update and display

11 Dec 2017 by Bipin Radhakrishnan

Introduction We use Asp grid view to display various information and we may have come across multiple scenarios where we