Home > DeveloperSection > Interviews > What namespace used in ado.net?

Posted on    December-07-2010 12:00 AM

 ADO.Net ADO.Net 
Ratings:
 1 Answer(s)
  1443  View(s)
Rate this:

hanmandlu vasani

Total Post:30

Points:150
Posted on    April-16-2014 12:00 AM

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.


Don't want to miss updates? Please click the below button!

Follow MindStick