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

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

17 Apr 2022 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

24 Jun 2021 by Oleksandr Viktor (UkrGuru)

Minimally simple UkrGuru.SqlJson package for modern data manipulation

SQL-Server-2016

Oracle DB EDMX: Upgrade ASP.NET Project and Entity Framework to use Oracle.ManagedDataAccess.Client

14 Jun 2020 by DiponRoy

Upgrade a legacy ASP.NET project to use managed Oracle.ManagedDataAccess.Client instead of unmanaged Oracle.DataAccess.Client while using Entity Framework DB first or EDMX.

entity-framework

Introduction to EntityWorker

23 Dec 2019 by Alen Toma

EntityWorker ORM

SqlServer: Parameterized Query With IN() Clause C#

14 Feb 2019 by DiponRoy

A utility class to send parameters for IN() operator in SQL using parameterized queries

entity-framework

Continuous Integration and Delivery for Beginners (DevOps)

3 Feb 2019 by Thinira

Continuous Integration and Delivery with VSTS (Visual Studio Team Services)

Xamarin Forms: Check and Request for Permissions

11 Jan 2019 by Harshit Gindra

Check and request for Permissions in Xamarin Forms mobile application

EntityWorker.Core - An Alternative to Entity Framework

3 Oct 2018 by Alen Toma

EntityWorker.Core - an alternative to entity Framework

How to Implement ObjectStatus with EntityWorker.Core and JavaScript

8 Jul 2018 by Alen Toma

How to implement ObjectStatus with EntityWorker.Core and JavaScript

DBConnect

9 Jun 2018 by Sina Shiri Hamedani

This is a simple C# class for connect and using SQL Server easily (SELECT, INSERT, UPDATE, DELETE)

Datatables.net Deferred Loading of Data using ASP.NET MVC and jQuery

4 Apr 2018 by Deepan Maheswaran

Implementing dynamic or deferred loading of data using datatables.net plugin in ASP.NET MVC

PostgreSQL-ADO.NET Framework

15 Mar 2018 by M.M.Mohseni

The simple sample that shows how to connect the ADO.NET Framework to the PostgreSQL

Enumerating OleDb Providers

22 Feb 2018 by PIEBALDconsult

A simple way to enumerate the OleDb Providers installed on the system

Listing Sheets in an Excel File

21 Feb 2018 by PIEBALDconsult

A simple way to use ADO.NET to get a list of sheets in an Excel file

GMaps Control Simplified in VB.NET

16 Feb 2018 by Len van den berg

GMaps Control Simplified in VB.NET

High Performance ADO Database Library

7 Feb 2018 by Matthew Ruffell

A high-performance and well tested C# ADO library for connecting and querying a SQL database

Verify Oracle Client Installation

1 Dec 2017 by WernfriedD

Single .exe to verify if your Oracle Client is properly installed and working. Verify supported technologies for Oracle connection.

Convert Outlook Table Content into Datatable using C# EWS and HtmlAgilitypack

1 Nov 2017 by Saurav J

Convert table from outlook email body into datatable or list using .NET C# EWS Managed API and HtmlAgilitypack

SimpleThreading Makes Threading Easy!

4 Aug 2017 by Sharp Ninja

Threading can be a daunting topic. This library takes much of the worry (and mistakes) out of multi-threaded application programming.

SSRS Reports: Show Data from Non-standard Provider

21 Jul 2017 by Michael Ecklin

SSRS Reports: Show Data from Non-standard Provider

Simple Client Side Consume ASP.NET Web API Server

12 May 2017 by Chinh Vo Wili

Send HTTP GET requests, consume ASP.NET Web API server

SQL to ADO.NET API (Automated ADO.NET or DB API)

10 Apr 2017 by dmytro.sen

SQL to ADO.NET API (Automated ADO.NET)

Create CSV from JSON in C#

19 Mar 2017 by Yaseer Arafat

Using Extension Method and JSON Serializer

Insert Multiples Records to SQL Server Database

15 Mar 2017 by Ricardo_Torres_Torres

Read text file and insert mutiples records in just one SQL Sentence

Auto Generate Code (CRUD) for 3 Layered architecture

12 Dec 2016 by Suresh Dasari's

Auto Generate Code (CRUD) for 3 Layered architecture (Entity, Data Access & Business Layer) with Stored Procedures based on table design.

SQL-Server-2005

Dodgy Database Solution with JSON

30 Nov 2016 by Michael Breeden

Using JSON to simplify, solve and enhance SQL Database issues

Mocking EF DbContext and DbContextTransaction with Proxy

12 Oct 2016 by MaDOnos

How to mock EF DbContext and DbContextTransaction with Proxy

entity-framework

SQL Schema Support Multi Version Tables

14 Jul 2016 by Simon Korenfeld

SQL schema with multi version tables support

Dynamic ASP.NET Web API Controller - Part 1. Dynamic DTO

8 Jun 2016 by David Lee 145

How to make dynamic DTO with ExpandoObject

Day 1 : Database Connectivity ASP.NET/C# with SQL Server (Create Operation)

29 Mar 2016 by VijayRana

CRUD operation in ASP.NET/C# with SQL Server for beginners

Yet Another Duplicate File Detector

22 Jan 2016 by kaviteshsingh

Simple utility to scan and find duplicate files in a directory.

Bulk Copy/Insert from a CSV file to SQL Directly

14 Jan 2016 by Bhishma Anil Kajaria

Browse and Copy data from your CSV file to SQL directly without any Windows application...

A Generic ADO.NET Overlay to Simplify DB Calls to SQL Server and Oracle

12 Jan 2016 by shijo joseph

An ADO.NET Layer for SQL Server and Oracle which makes it easier for interfacing with database

A Plug and Play Logging Library for Dummies

20 Dec 2015 by shijo joseph

An easy to implement yet powerful logging library which requires absolute zero learning curve

Using Effort - Entity Framework Unit Testing Tool

9 Dec 2015 by Roger C Moore

This tip is a guide for using the Codeplex project Effort for testing Entity Framework applications without requiring the unit tests to actually hit the SQL Server database.

User Responsive Web Query Builder using ASP.NET

29 Nov 2015 by Reeshabh Choudhary

Web platform based query builder to play with your database :)

Using SQLite: An Example of CRUD Operations in C#.NET

20 Nov 2015 by Lộc Nguyễn

With a DEMO WPF application (WinNotif)

Setting up SQLite and Entity Framework 6 (Code First and Database First)

16 Nov 2015 by User 10668410

How to get SQLite 1.0.98.1 working with Entity Framework 6.1.3 without a massive headache using the Database First Model and Code First Model.

How to Check Opened Connection in SQL Server

13 Nov 2015 by Najmul Hoda

Here is the code snippet to check how many database connections are opened in SQL Server.

AutoCompleteExtender working with EntityFramework! (Reload 2015)

12 Nov 2015 by Eduardo Yost

Creating a Web User Control containing an AutoCompleteExtender for data through WCF (JSON) allowing to store the entity selected through EntityFramework. Entity object serialization from the server to the client and the client to the server.

SQL Query with C# Typed Library - CooQ

2 Nov 2015 by Guni Van

Mapping your database with C# object class, then make typed-safe query like SQL syntax

SQL Server FILESTREAM with Nhibernate

23 Oct 2015 by Codeman the Barbarian

In the tip, I go through one approach to integrating SQL Server's FILESTREAM type with Nhibernate.

Execute Long Running SQL Statements Asynchronously from .NET

21 Oct 2015 by Anil Kumar @AnilAwadh

A beginner's tutorial for understanding Asynchronous execution of SQL statements using a simple application.

Day 2 - Database Connectivity (Retrieve Value from Database and Bind to Gridview)

18 Oct 2015 by VijayRana

Retrieve value from database and bind to gridview

Perfect Pagination with Repeater Control in ASP.NET C#

10 Oct 2015 by ChienVH

Perfect Pagination with Repeater Control in ASP.NET C#

Fast and Simple IDataReader Implementation to Read CSV Files

3 Oct 2015 by shijo joseph

A simple and fast CSV reader which you can directly use against Oracle and SQL Server databases or for any direct implementation

Persisting Winforms Component to C# Code

19 Sep 2015 by Ying LEE

This article introduces a general and robust way to persist/serialize any Winforms component to C# code.

String Interpolation or String Handling in C# 6.0 with New Feature

1 Sep 2015 by idreeskhan

String interpolation or String handling in C# 6.0 with new feature

Plug-in Architecture To Work for Multiple Platforms/Techs

2 Aug 2015 by Reader Man San

Plug-in Architecture To Work in WinForms MVC + WPF MVVM + ASP.NET MVC + Mobile (Xamarin MVC/PhoneGap MVC) + Win 10 Universal App MVC

DataTable from Excel

28 Jul 2015 by Igor Krupitsky

This article shows how to get ADO.NET DataTable out of Excel

How to Change Date Format in Crystal Report

23 Jul 2015 by Mian Adnan

Using Microsoft Visual Studio Professional 2012, .NET 4.5 and Crystal Report Version regarding .NET 4.5 and VS 2012

SQL-Server-2014

Executing Stored Procedure using Entity Framework DataContext

26 Jun 2015 by Manoj Deshmukh

Executing Stored Procedure that returns resultset using Entity Framework DataContext

Update Database using Stored Procedure and DataAdapter

20 Jun 2015 by Naresh Patidar

Insert, update and delete operations using stored procedure and DataAdapter in C#

SQL-Server-2008R2

SQL-Server-2012

SQL-Server-2014

Dynamic SQL Connection in ASP.NET 3.5 with User Controls

19 Jun 2015 by ss9o9o9o

Transferring backup files from a remote SQL Server and Dynamic SQL Connection with Restore utility.

SQL-Server-2005

Creating a SQL Server Database Project Use in Visual Studio 2012 and Use TFS for Version Control

8 Jun 2015 by Diluka Wittahachchige

Creating SQL Server database project use in Visual Studio 2012 and maintain versions use in TFS

SQL-Server-2008

SQL-Server-2005

SP Beginners Part 1 – Create a Web Application on Farm and Getting It Functioning in Visual Studio

15 May 2015 by NikiGrly

Steps to create a web application on your farm.

ADO.Net Connectivity using Stored Procedure and Output parameters

10 May 2015 by Ankit Bansal MVP

This articles explains the insertion of data into SQL Database using Stored Procedures with Output Parameters. Some Bootstrapping is also used to create a good looking HTML.

Extract All Schema Information From Your Database

16 Apr 2015 by sx2008

how to get as much information about your database as possible via ADO.NET

Geolocation wifi Scanner and Finder

2 Apr 2015 by Dr Gadgit

Written in C# and VS2010 as a class libary to be used in your own project.

Data Access using ServiceStack

6 Feb 2015 by Daniel Santillanes

Using ServiceStack's ORMLite framework as part of your MVC project's database access

Pass Parameters from Web Page to Telerik Report

19 Jan 2015 by Thinira

In this tip, we discuss how to pass report parameters from web page to Telerik report programmatically.

SQL-Server-2008R2

3 Layer Architecture for Beginners in ASP.NET C#

19 Jan 2015 by JatinKhimani

Develop a web application in 3 layer architecture code style

Strategy for Separating UI and Back-end Code Development

15 Jan 2015 by Giancarlo Rhodes

Creating the Web UI

MS Access (*.mdb) + C#: SELECT, INSERT, DELETE and UPDATE Queries

12 Jan 2015 by Emiliarge

Queries in Microsoft Access (MDB) databases.

Debug ASP.NET MVC Application with Glimpse

11 Jan 2015 by Muhammad Hassan Tariq

Glimpse Extension for server side debugging and diagnostic information of ASP.NET applications

SQL-Server-2008R2

Working with LINQ to Entities & LINQ to DataTable

31 Oct 2014 by ShaikAnwar

This topic gives us an idea of how to write Linq queries on Entities & DataTable. This covers some basic querying and also usage of joins and group by using LINQ.

Convert CellSet to HTML Table, and From HTML to Json, Array

17 Oct 2014 by Sibeesh KV

Convert CellSet to HTML table

SQL-Server-2008R2

MVC Load Stocks Data on Runtime in a Grid View

19 Sep 2014 by Wajahat Aftab

How to load data from live market stock feed in a grid view

SQL-Server-2008R2

Know More about SQL Constrains

21 Aug 2014 by Mohammed Nazer

SQL Constrains details and its types

Create Table and Stored Procedure in SQL Server and connect it from ASP.NET using C#

17 Aug 2014 by Prakash Lekhak

We will create a Table and Stored Procedure in Sql Server 2008R2 and data will be inserted and retrieved by using Asp.net using C#

SQL-Server-2008R2

Dynamic DropDownList Binding in ASP.NET MVC With Database

14 Aug 2014 by Member 10872251

Cascading DropDownList in ASP.NET MVC

SQL-Server-2008

Dapper.NET Sample with MVC 4- Add,Edit,Update,Delete

12 Aug 2014 by Gihan Liyanage

Simple Dapper.NET Example with MVC

Changing Databases at Run-time using Entity Framework

18 Jul 2014 by Matthew Givens

How to change databases at run-time in a user-friendly manner.

entity-framework

Creating a Formatted Column within a DataTable

2 Jul 2014 by Mattintosh

How to create a formatted column with nothing more than a knowledge of which columns you want and the format you want them in

Multilevel Nested Gridview in ASP.NET

2 Jul 2014 by Chakravarthi Elchuri

Display data in Multi nested gridview using C# in ASP.NET

Web Caching with SqlCacheDependency Simplified

20 Jun 2014 by sazakir

Using SqlCacheDependency with Web caching

Possible solutions for an .Net 4 compiler bug that raise an MissingMemberException by acessing the index property of an SqlParameterCollection from an SqlCommand

14 May 2014 by Peter BCKR

In legacy applications you can get a MissingMemberException bei acessing a SqlParameterCollection if you work with object-variables there are reference a SqlCommand-Instance.

7 May 2014 by Ashish Tripathi

Sharp RepoGen is a simple tool to create repository interface having methods for CRUD operation and its implementing class. Using this tool easily you can generate your repositry class and interface. Code is generated with the help of xml template, so very easily you may change the template to creat

Export and Import Database using SMO

30 Apr 2014 by Sridhar Pasham

Export and import database using SMO

Microsoft ASP.NET Identity MerlinFramework 2.0

28 Apr 2014 by Marc Leger

Microsoft ASP.NET Identity MerlinFramework

Generic Method to Convert DataReader Result into List of CLR Objects

24 Apr 2014 by Bankey Sharma

Converting DataReader Result into List of Objects Using Generic Type, Property Attribute and Reflection

entity-framework

Check Network V1.0

23 Apr 2014 by mohamedkamaleed

Network check v1.0

SQL-Server-2012

Understanding Normal Forms of Relationship for database

15 Apr 2014 by Kirill__

How to create databese with forst 3 normal forms of relationship

EF Remove If Exists

12 Apr 2014 by Robert Lindblom

Removing entity if it exists

nKnight - Role Based Access Control(RBAC) Solution for C#.NET

7 Apr 2014 by subhajit bhadury

nKnight - RBAC Solution for C#.NET

Dynamically Setting a Parameter from a C# Variable in Crystal Reports

2 Apr 2014 by Kinyanjui Kamau

I have written this tip to help developers automatically set Crystal Report parameters from variables in code (WinForms) at report run time.

Detecting Concurrency Issues with Entity Framework

14 Mar 2014 by Robert Lindblom

Detecting concurrency issues when using Entity Framework model first and SQL Server

Nested gridview Edit

25 Feb 2014 by JatinKhimani

Nested GridView With Editing Facility of both gridview.

Export to Excel in ASP.NET C#

24 Feb 2014 by JatinKhimani

Export Gridview data in Excel formate with gridview design.

To Generate XML File from Datatable using LINQ

23 Feb 2014 by puja11191

This tip shows how can we generate and save XML files

Extract Image Files from Database Image Data

20 Feb 2014 by PallavSingh

Converting data column (contains OLE db image binary Format) to image file (.jpg)

C# Photo Viewer with Windows Forms

16 Feb 2014 by puja11191

This is an extension of Photo Viewer on MSDN

Passing Object Collections to ASP.NET Web API

16 Jan 2014 by Tom Glick Philadelphia, US

POC to demonstrate passing of collections of complex objects to ASP.NET Web API Controllers.

How to: Get Data from Multiple Workbooks using One OleDbConnection?

3 Jan 2014 by Maciej Los

This tip shows how to get data from multiple workbooks using one OledbConnection.

Failproof Bulk Upload SqlBulkCopy

29 Nov 2013 by lalitsrana

Demonstrate a simple yet efficient way to upload the data (SqlBulkCopy)

DataReader into IEnumerable with C#

4 Nov 2013 by Jaume González

How to convert any datareader into generic list.

Forgot Password With Check Email From Database

22 Oct 2013 by Muhammad Aqib Shehzad

Forgot Password and Email Check from Database

How to get Connection String from App.Config in C#

15 Oct 2013 by Alireza C

This code helps you to grab ConnectionString from App.config.

Database Driven Dynamic Menu Control

6 Oct 2013 by Muhammad Ahmed Azam

"Database Driven Dynamic Menu Control"

Enterprise Library 6 with SQLite Logging and Exception Handling, REAL!

25 Sep 2013 by ModMa

Real and fully functional connection Database Provider and DatabaseTraceListener for SQLite!