ADO.NET overview, architecture, components and code

ADO.NET Overview - ADO.NET is design to provide data access...
ADO.NET vs ADO - ADO.NET is considered as evolution version of ADO....
ADO.NET Data Architecture - ADO.NET has four layers - The Physical Data Store: This can be any database, XML files or OLE....
ADO.NET - Type of database connection in ADO.NET - SQL Connection: This object connects to the SQL Server.....
ADO.NET - Components of data providers in ADO.NET - The Connection Object: The Connection object represents the connection to the database. ....
ADO.NET - Connected and disconnected data access in ADO.NET - This object requires exclusive use of the connection object. It can provide fast and forward-only data access. It doesn't allow editing....
ADO.NET - CommandType property of a SQLCommand in ADO.NET - A SQLCommand has CommandType property which can take Text, Storedprocedure or TableObject as value.
Dataview component of ADO.NET - A DataView object allows you work with data of DataTable of DataSet object..
Ways to create connection in ADO.NET - There are two ways to create connection supported by ADO.NET...
Access database at runtime using ADO.NET - Steps to connect to database - Declare and initialize database connection object with appropriate connection string...
ADO.NET Code showing Dataset storing multiple tables - Declare and initialize database connection object with appropriate connection string.....
ADO.NET Code executing stored procedure - Code showing how to fetch data using Stored Procedure...
ADO.NET transaction Processing - The transaction object handles concurrency issue using IsolationLevel settings. The settings can be....
System.data contains basic objects. These objects are used for accessing and storing relational data....
The data adapter objects connect a command objects to a Dataset object....
The most commonly used methods of the DataAdapter are.....
The DataSet object is a disconnected storage, it is used for manipulation of relational data....
We fill it with data fetched from the data store. Once the work is done with the dataset, connection is reestablished....
The changes made to the dataset can be tracked using the GetChanges and HasChanges methods.....
How can we add/remove row’s in “DataTable” object of “DataSet”? - NewRow method is provided by the Datatable to add new row to it.DataTable has DataRowCollection object which has all rows in a DataTable object....
How do we use stored procedure in ADO.NET and how do we provide parameters to the stored procedures?
A DataView is a representation of a full table or a small section of rows, it is used to sort and find data within Datatable...
DataSet object can contain multiple rowsets from the same data source as well as from the relationships between them...
Load multiple tables in a DataSet using ADO.NET...
CommandBuilder builds Parameter objects automatically...
In pessimistic locking, when a user opens a data to update it, a lock is granted..
A connection pool is created when a connection is opened the first time...
To disable connection pooling set Pooling=false in connection string if it is an ADO.NET Connection..