What namespace used in ado.net?
Ask by Pushpendra Singh
Updated 24 Sep 2020
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.