Please enable Javascript to correctly display the contents on Dot Net Tricks!

Introduction to Ado.net

 Print 
  Author : Shailendra Chauhan
Posted On : 29 Jul 2011
Total Views : 17,708   
Updated On : 04 Dec 2016
 

Before Ado.net we use Ado (Active Database Object) to access data from database. Basically Ado has automatic driver detection technique and it has only one drawback that it only provide a connected environment so efficiency of system may decrease.

ADO.NET is a new database technology used by .Net platform (introduced in 2002). Infact it is a set of classes used to communicate between an application front end and a database.It supports both connected & disconnection mode of data access.

Mandatory Namespaces used in ADO.Net

In any .NET data access page, before you connect to a database, you first have to import all the necessary namespaces that will allow you to work with the objects required. Namespaces used in ADO.Net are :

  1. System.Data

    It contains the common classes for connecting, fetching data from database. Classes are like as DataTable, DataSet, DataView etc.

  2. System.Data.SqlClient

    It contains classes for connecting, fetching data from Sql Server database. Classes are like as SqlDataAdapter,SqlDataReader etc.

  3. System.Data.OracleClient

    It contains classes for connecting, fetching data from Oracle database. Classes are like as OracleDataAdapter,OracleDataReader etc.

  4. System.Data.OleDb

    It contains classes for connecting, fetching data from any database(like msaccess, db2, oracle, sqlserver, mysql). Classes are like as OleDbDataAdapter,OleDbDataReader etc.

  5. System.Data.Odbc

    It contains classes for connecting, fetching data from any database(like msaccess, db2, oracle, sqlserver, mysql). Classes are like as OdbcDataAdapter,OdbcDataReader etc.

Component of ADO.NET architecture

  1. Data Provider

    Data provider is a set of ADO.Net classes that allow us to access a database. Basically, it is a bridge between our application (We can say front-end) and data source. There are following Data Provider :

    1. SqlServer Data Provider:-It is used to access data from SqlServer database (for version 7.0 or later).

    2. Oracle Data Provider:-It is used to access data from oracle database (for version 8i or later).

    3. OleDb Data Provider:-It is used to access data from any database (msaccess, mysql, db2).

    4. Odbc Data Provider :-It is used to access data from any database (msaccess, mysql, db2).

  2. Data Set

    Basically it is a small Data structure that may contain multiple data tables from multiple sources.The information in dataset is created inform of XML and is stored with .xsd extention.It support disconnected mode of data access.It has both scrolling mode means forward and backward scrolling mode (fetching of data).DataSet can have multiple Datatable from multiple sources but DataReader is able to read only single Datatable.



Free Interview Books
 
COMMENTS
24 SEP
Angular2 and Angular4 (Classroom)
08:30 AM-11:30 AM IST
23 SEP
MEAN Stack (Classroom)
8:30 Am To 11:30 Am
23 SEP
Microsoft Azure Infrastructure Solutions (Online)
08:00 PM-11:00 PM IST / 9:30 AM-12:30 PM CST
20 SEP
MEAN Stack (Online)
07:00 AM-09:00 AM IST
20 SEP
ASP.NET MVC with Angular4 (Online)
9:00PM- 11:00PM IST(+5:30GMT)
16 SEP
Angular2 and Angular4 (Online)
08:00 AM-10:00 AM IST(+5.30 GMT)
7 SEP
ASP.NET MVC with Angular4 (Online)
09:00 PM to 11:00 PM IST (+5:30 GMT)
22 AUG
ASP.NET Core with Angular4 (Online)
07:00 AM - 9:00 AM IST(+5:30 GMT)
19 AUG
MEAN Stack 2 (Online)
5:30 Pm - 7:00 PM IST (+5:30 GMT)
19 AUG
ASP.NET MVC with Angular4 (Online)
10:30 Am to 12:30 PM IST (+ 5:30 GMT)
19 AUG
NodeJS with Angular4 (Classroom)
04:00 PM to 07:00 PM IST (+5:30 GMT)
12 AUG
ASP.NET MVC with Angular4 (Classroom)
11:30 AM - 1:30 PM IST (+5:30GMT)
15 JUL
ASP.NET MVC with Angular4 (Online)
03:30 PM - 05:30 PM IST(+5.30 GMT)
LIKE US ON FACEBOOK
 
+