Click here to Skip to main content
15,867,704 members
Everything / ADO.NET

ADO.NET

ADO.NET

Great Reads

by David Rogers Dev
Learn how to load related entities using the Entity Framework with simple examples
by dotnetdan
VS 2005 debug visualizers for DataSet, DataTable, DataView, DataRow and DataColumn objects.
by LarryCharlton
Dynamic data forms.
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

by Jani Giannoudis
REST API Reporting for .NET
by freedeveloper
How to create a data access class in a way, that is possible to execute unit test on it
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.
by Oleksandr Viktor (UkrGuru)
Minimally simple UkrGuru.SqlJson package for modern data manipulation

All Articles

Sort by Updated

ADO.NET 

16 May 2022 by freedeveloper
How to create a data access class in a way, that is possible to execute unit test on it
10 Jun 2021 by Vadim Loboda
A way to deliver more details about an error or exception from an SQL Server database through an ASP.NET web application to a web client.
15 Jun 2020 by Vadim Loboda
ADO.NET Micro-ORM to SQL Server
15 Apr 2020 by Alexandros Pappas
This project describes how to use Entity Framework Core with update triggers and audit tables.
10 Apr 2020 by #realJSOP
A rewrite of a previous article with more liquid nitrogen and bacon
9 Apr 2020 by #realJSOP
When you're using other people's code, especially code that might get updated from time to time, it's important to remember that you can probably extend it and make it in your own image, without necessarily changing the original code, and by using the power of object-oriented programming.
8 Jan 2020 by Siddharth Gajbhiye
In this article, we will learn how to create server side paging which is very useful whenever we have to display large number of records.
1 Dec 2019 by Fedor Dzjuba
Sometimes, we need to present MDX result on the web or a client application that has no native provider to Microsoft Analysis Service. Solution is to use Adodm.Client CellSet, serialize it into sensible JSON and spit it out to the client to render.
10 Nov 2019 by Marc Clifton
Another rabbit hole, this time how to handle AJAX calls in a manner that lets you roll back the entire set of transactions if any particular AJAX call fails.
10 Sep 2019 by Alexandros Pappas
This project describes how to use Entity Framework with update triggers and audit tables.
22 Jul 2019 by #realJSOP
Avoid ORMs with this reasonably generic approach to ADO
15 Jul 2019 by DiponRoy
Conditinal filter query example in SQL, Lambda Expression, C#
4 Jun 2019 by Sacha Barber
An example application using angular/Rx for JavaScript/Web Sockets/jQuery
22 May 2019 by aquila huang
Introduction of the open source project Light.Data
3 Apr 2019 by Mahsa Hassankashi
This article illustrates how to use Node.js by WCF which is written in C# and using node.js as real time communication technology with the aid of C# code to connect MS SQL Server.
20 Feb 2019 by Igor Krupitsky
Tool that will let you import data from SQL Server and Access to MySQL
20 Nov 2018 by tranthanhtu.vn
How to build the SPA for enterprise application using Angular2 and WebApi (RESTful)
5 Nov 2018 by Jovan Popovic(MSFT)
Create powerful REST API with just few lines of C# code using MsSql.RestApi package
31 Oct 2018 by Aydin Homay
In this article, we will discover the power of generics in C#.
27 Sep 2018 by Akhil Mittal
In this article, we look at how we can leverage Entity Framework approaches and, as per need, use those.
18 Sep 2018 by Rahul Rajat Singh
How to use dapper to read mutiple resultsets from database in a single database call
16 Aug 2018 by Proneetkumar Pradeep Ray
JQuery Datatable (Dynamic columns) populate after Ajax JSON response via server side processing - Using EF Raw SQL query
13 Aug 2018 by Bryian Tan
This article shares the idea on how to utilize free tools to download log files from server, upload IIS log files into the database, display the results and compare the baseline and production files.
3 Aug 2018 by Rahul Rajat Singh
This article introduces Dapper to absolute beginners.
13 Jun 2018 by Bojan Sala
SqlBinder is a free, open-source library that helps you transform a given SQL template and a set of conditions into any number of valid SQL statements along with their associated parameters.
15 May 2018 by NobsterTheLobster
Publish a WCF DataService with entity model, updatable views, filtering and authentication
3 May 2018 by Måns Tånneryd
Extending the entity framework with bulk operations for both inserts and updates
22 Mar 2018 by Angel Gabriel Valdés Sarduy
This project is an ASPNET Core MVC site with a generic controller for CRUD and searchs.
21 Feb 2018 by Yunus Emre Kalkan
How to create custom repostories in ASP.NET Boilerplate and use stored procedure, view, user defined functions inside your repository
10 Feb 2018 by Changming Wang
A complete event calendar, using trucking/shipping as an example, built with Visual Studio Community 2015, C# MVC and jQuery.Fullcalendar
16 Jan 2018 by Pragmateek
Using an Access, MySQL, PostgreSQL or SQLite Database from VBA
26 Dec 2017 by koolprasad2003
Have you lost your data from SQL table? Have you lost your SQL table? Want to know who ran DELETE or DROP Query on your database? Then go through this step by step article, it will help you to find the culprit
28 Nov 2017 by Bob Stoom
Walkthrough in detail to create a relational database application using C# .NET without code.
12 Oct 2017 by Rudi Breedenraedt
How to mix relational and document oriented data in SQL Server and query it with Entity Framework? Including pitfalls, limitations and performance notes.
10 Oct 2017 by Vincent Maverick Durano
This article is the first part of the series on Getting Started with Entity Framework Core. In this post, we will build an ASP.NET Core MVC application that performs basic data access using Entity Framework Core.
6 Sep 2017 by Debendra0256
In this article we will learn to create MVC project from scratch following n-tier architecture.Along with this we will focus on designing views.
4 Sep 2017 by Scott Page
FreeCal is a free 100% .NET suite of utilities and instrument drivers for controlling multiple instruments in a Test and Measurement environment.
7 Aug 2017 by JasonShort
Wouldn’t it be handy if you could use regular expressions (RegEx) in your SQL code?  You could do some really advanced queries through the ability to specify regular expressions rather than just the simple like % matching you normally use. SQL CLR can do that!
10 Jul 2017 by Wendelius
This article discusses some basic requirements for successful database operations such as error handling, use of parameters and transactions.
29 May 2017 by tranthanhtu.vn
In this article, we will learn how to build and deploy the code
29 May 2017 by tranthanhtu.vn
In this article, We will learn why do we need to manage the stages of our application.
24 May 2017 by Zahid Nawaz Ch.
SqlDependency ,can be used to pick changes without executing query to see there is any update from database , WHERE CLAUSE can also be applied for narrowing scope, Its way to push changes from SQL Server to SQLDependency , .NET library , SQL Server Broker service sends updates to SQLDependency.
14 May 2017 by Sibeesh Passion
Here, in this post, we are going to see some LINQ queries, which covers both basics and advanced.
9 May 2017 by Adriaan Booysen
Adding Seeding Framework towards EntityFrameworkCore that can be wired up in either a dotnet core Web Application or WebAPI
7 May 2017 by Michael Lockwood
How to call a web service using SSIS, store XML results and then query XML using XQuery
27 Apr 2017 by Igor Krupitsky
ASP.NET page that lets you process an SSAS (SQL Server Analysis Services) cube database.
2 Mar 2017 by Awesh Vishwakarma
The easiest way to use Entity Framework with SQLite databases in C# Winform and Console Applications
26 Feb 2017 by AXI_IeD
How to Filter contextually the list shown by a DataGridComboBoxCell?
24 Jan 2017 by O.Nasri
You will learn how you can build a management user interface using DotnetCore, Angular2, typescript and web API.
20 Jan 2017 by Ole Oren
Fast and simple REST development for SQL devs
21 Dec 2016 by John C Rayan
25 Nov 2016 by kannankeril
This article is an attempt at splitting out the controller layer to reduce its complexity and improve quality and maintainability of the resulting code.
8 Nov 2016 by mblataric
Instructions on how to migrate existing XAF security system to new permission policy.
1 Nov 2016 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.
31 Oct 2016 by Mercede
Generic data manager provides thread specific IUnitOfWork repository tailored for your entities and takes care of all the plumbing and cleaning in a thread safe way.
24 Oct 2016 by Kelum Priyadarshane
This project developed using combination of Entity Framework 6.0 + Code First Approach + Web API 2 + Repository Pattern + ASP.NET MVC 5 + SQL Server 2012 + Unit of Work Testing + Bootstrap.
14 Oct 2016 by George MVC Study
How to use ODP.NET user defined type feature
9 Oct 2016 by Md._Mehedi_Hasan
CRUD operation in .net MVC using Stored Procedure for Single and List Object Data along with SQL Transaction.
5 Oct 2016 by Sahil Saini @ Software Developer
This article starts with creating the project in MVC with using the bootstrap classes to give better look to the UI and controls used on UI.
22 Sep 2016 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.
18 Sep 2016 by inishant12
Using SSRS report, generate the PDF, save it into DB and send it through mail using C#
28 Aug 2016 by Ali Adly
A simple example that shows how to create detail grid template at runtime using ASPxGridView
24 Aug 2016 by Roman Ivantsov
The article provides a comparative analysis and gives patterns of using explicit locks to manage concurrent access to database documents (data split over multiple tables) in MS SQL Server, MySql, PostgreSql and Oracle. As it turned out, the solution is not always obvious or simple.
18 Aug 2016 by Vincent Maverick Durano
A quick demo that highlights how to upload and import CSV file to SQL Server database in ASP.NET WebForms.
17 Aug 2016 by Michael Ecklin
Very often, Excel spreadsheets are using to transfer data between applications. CSV files are also used for the same purposes.
7 Aug 2016 by Rahul S Chavhan
Validate an XML document in SQL Server using XSD by Rahul Chavhan
25 Jul 2016 by yuvalsol
Helper class to mitigate working with Dapper against SQL Server database
22 Jul 2016 by Mohamed Kalmoua
In this article, I will create a master-detail view using the Entity Framework.
8 Jul 2016 by Jovan Popovic(MSFT)
How to build REST services with ASP.NET Core Web API and Azure SQL Database
7 Jul 2016 by mcondon013
Article listing and evaluating useful third-party tools and libraries for the independent developer of shareware and freeware .NET applications.
5 Jul 2016 by Vincent Maverick Durano
A simple demo on how to dynamically add rows in GridView with TextBox and DropDownList, retain the values on postbacks and save all row values at once using SQLBulkCopy.
3 Jul 2016 by cyqdata
This is a presentation of a cyq.data ORM article.
24 Jun 2016 by mcondon013
Code that adds built-in serialization functionality to your classes in C#
21 Jun 2016 by Alexandros Pappas
Measuring COM+ performance
10 Jun 2016 by Emiliano Musso
In this article, we will see how to use entity framework in our Applications, developed through the various languages that Visual Studio allows us to use. The examples in this article and probably in the next, will be C # used under WinForms, but - as mentioned - this choice is not going to affect a
1 Jun 2016 by icemanind
Automatically generate Business and Data layers in C# or VB.Net from a SQL Server, Microsoft Access, MySql or SQLite database design.
7 May 2016 by Tomz_KV
Explain how to use a SQL CLR function to overcome the limitation of a standard SQL user-defined function to execute ad-hoc SQL query.
17 Apr 2016 by Alex_2979
A lot of modern Business Intelligence solutions offer to transfer work of analysts to developers or rise technical level of business analysts, make them closer to developers. Instead of it, I advise to consider a solution, which takes information from Database and gives it to business analysts.
12 Apr 2016 by Aqeeel
Having not ONE but TWO Identities in a single SQL Server Table
18 Mar 2016 by M.M.Mohseni
An ASP.NET one page application for getting backup from MS-SQL Server
7 Mar 2016 by dale.newman
Importing Excel & Delimited Files into a Junk Database
1 Mar 2016 by Jörgen Andersson
17 Feb 2016 by Aqeeel
Though GridView provides a way to implement paging however when the record count in very big we need to optimize it at the query level.
26 Jan 2016 by Jörgen Andersson
A propertymapping extension for DataReaders
30 Nov 2015 by Sreekanth Mothukuru
The idea is to use Dependency Injector (DI) framework Ninject to dynamically target our application to SQL Server or Oracle database either by using Entity framework (EF) or Dapper ORM using global settings
22 Nov 2015 by Leya Samuel
This article mainly explains about how you can write custom webhook using persistent storage, how they can be created and also a sample source code on custom webhook. The purpose of this article is just to give an idea on writing your own custom web hook.
14 Nov 2015 by junnark
This is a tutorial on how to use WinFormsGen's generated code.
30 Aug 2015 by Murugan Sivananantha Perumal
Self Hosted WCF Service as Windows Service with custom User Authentication over Http.
21 Aug 2015 by Wendelius
Article describes how to encrypt a dataset using AES. Optionally the dataset is compressed before the encryption.
26 Jun 2015 by Stefan Wloch
An introduction to Custom Roles Based Reporting for ASP.NET MVC applications using the Entity Framework. Protecting confidential information is a business requirement and in many cases also an ethical and legal requirement.
25 May 2015 by César de Souza
Explore your data using statistical distributions: explore, initialize, create, estimate and use statistical distributions from the Accord.NET Framework using an application based entirely on reflection.
27 Apr 2015 by Jörgen Andersson
A high performance extension for creating a DataTable from a Generic collection.
22 Apr 2015 by lakhdarr
Working with different data stores (SQL, NoSQL ..) in high performance enterprise application using DDD and Repository unit of work pattern