In Focus
Look Who Is Speaking at #CSharpCon19

C# Corner

ADO.NET
ADO.NET introduced as a part of .NET 1.0, is an API (set of classes) that is used to connect and access various data sources including XML, flat files, relational databases, and more. Here you may find ADO.NET related articles and news.

RECENT POSTS

  • DataReader In C#

    The ADO.NET DataSet is a data construct that can contain several relational rowsets, the relations that link those rowsets, and the metadata for each rowset. The DataSet also tracks which fields have

  • DataView In C#

    The ADO.NET DataSet is a data construct that can contain several relational rowsets, the relations that link those rowsets, and the metadata for each rowset. The DataSet also tracks which fields have

  • DataAdapter In C#

    The ADO.NET DataSet is a data construct that can contain several relational rowsets, the relations that link those rowsets, and the metadata for each rowset. The DataSet also tracks which fields have

  • Generic Data Access Component using Factory Pattern

    The article A Generic Data Access Component using Factory Pattern provides a very good way of creating ADO.Net data provider independent applications, but there is one problem with it. Different ADO.N

  • Writing a Generic Data Access Component

    I've received couple of emails people asking me how can they use a common data provider to access various types of data sources without loosing the power and flexibility of native data provider li

  • A Generic Data Access Component using Factory Pattern

    This article shows to utilize the System.Activator class and a factory pattern to create the concrete provider classes.

  • Improve SQL Server Connection Performance In ADO.NET

    This little tip will boost the speed of SQL Server connection using ADO.NET. I was using ADO.NET to connect to an SQL Server database on a local network. I noticed that the connection speed seems off.

  • How To Transform A Class Into DataSource

    A class can be transformed into a DataSource object using Visual Studio IDE. Let's learn how.

  • Exploring SQLConnection In ADO.NET

    In this article, you will learn what the SQL connection class in ADO.NET. and how to use SQL connection class in ADO.NET.

  • ADO.Net and MySQL Connection

    Since there is no out-of-the-box MySQL support, connecting to this popular DMBS might get tricky. Learn how to connect to MySQL using a third-party ADO.Net connector.

  • Oracle Connection String using C#

    Oracle is a powerful relational database management system that offers a large feature set. Along with Microsoft SQL Server, Oracle is widely regarded as one of the two most popular full-featured data

  • Using C# DataTable

    The DataTable class of ADO.NET represents a data table in C#. Code sample in this article demonstrates how to create a DataTable dynamically in C# code and DataTable rows and DataTable columns and dis

  • Most Asked ADO.NET Interview Questions And Answers

    In this article you will learn about the most asked ADO.NET Interview questions and answers.

  • What You Should Prefer For Performance Among Entity Framework, Dapper, And ADO.NET

    Basically, when we design an application in .NET or any other technology, then how we are loading your data for application really impact the performance of our application. So, I will tell you what y

  • Difference Between DataReader, DataSet, DataAdapter and DataTable in C#

    what is the difference between DataReader, DataSet, DataAdapter and DataTable in C#.

  • Data Binding in DataGrid Control using C#

    The ADO.NET DataSet is a data construct that can contain several relational rowsets, the relations that link those rowsets, and the metadata for each rowset. The DataSet also tracks which fields have

  • DataSet In C#

    The ADO.NET DataSet is a data construct that can contain several relational rowsets, the relations that link those rowsets, and the metadata for each rowset. The DataSet also tracks which fields have

  • DataTable In C#

    The ADO.NET DataSet is a data construct that can contain several relational rowsets, the relations that link those rowsets, and the metadata for each rowset. The DataSet also tracks which fields have

  • How To Join Two DataTables Using C# In ADO.NET

    In this tutorial, I will explain about Data table by using Primary Key Property. Primary Key Property Return Type is "DataColumn" it was an Array. Return An array of System.Data.DataColumn o

  • ADO.Net Constraints - Unique and Primary Key

    This video explains how we can implement Unique and Primary Key and FrontEnd. It then walks you through DataTable merge and checks the Constraints behavior.

  • Solution - The 'Microsoft.ACE.OLEDB.12.0' Provider Is Not Registered On The Local Machine

    While working with Microsoft Access database connectivity with ado.NET, you may have received this error: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine or The

  • Entity Framework CRUD Operation Performed With SQL Stored Procedure Using ADO.NET Entity Data Model

    You can see my pervious article for Entity framework with Ado.Net data Model connection and how to create a new entity framework project and sql database connection maintained with created entity fram

  • Introduce Entity Framework With ADO.NET Entity Data Model

    In this article, we will learn the Entity Framework with Data Model.

  • How To Connect To SQL Database Using ADO.NET From C# Program

    In this article, I have explained how to use ADO.NET to interact with the database.

  • Read Microsoft Access Database in C#

    How to connect and read a Microsoft Access (.mdb) database using ADO.NET and C#.
    • View More