Data access namespaces and Objects in.Net..

Data access namespaces:

Following are the most common data access namespaces :

  • System.Data
  • System.Data.OleDb
  • System.Data.SQLClient
  • System.Data.SQLTypes
  • System.Data.XML

Main objects in ADO.NET

Following are the main objects in ADO.NET :

  • OleDbConnection / SQLConnection
  • OleDbCommand / SQLCommand
  • OleDbDataReader / SQLDataReader
  • OleDbDataAdapter / SQLDataAdapter
  • OleDbParameter / SQLParameter
  • DataSet
  • DataTable
  • DataView
  • DataRow
  • DataColumn

Most of the objects mentioned above can be created as ‘stand-alone’ objects via code