Data Access namespaces in .NET? | What are data access namespaces in .NET?

                                 Hi Friends, in this article I will explain about what are the data access namespaces in .NET?

                                 I already explained in the previous article what is ADO.NET? and What are the two fundamental objects in ADO.NET?,.NET Framework Data Providers | What are .NET Framework Data Providers see once if you need.

                                 The core ADO.Net classes exist in the System.Data namespace in the .Net Framework class library.

Figure: The system. Data assembly contents in the IL DASM utility.

The System.Data namespace is divided into child namespaces, there are

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

System.Data:  It Contains Classes like datatable, dataset and data relation, Services and types and for creating and accessing data sets and their subordinate objects. It contains some basic objects for relational data like datatable, dataset and data relation.

System.Data.OleDb:  It Contains Classes like OleDbConnection, OleDbCommand,OleDbDataAdapter etc., and types for accessing other databases. Its main function is to help in connecting with data with OLE-DB provider. For example, OleDbConnection class represents a Connection object. Some of the common classes of this namespace are OleDbDataAdapter, OleDbDataReader, OleDbCommand, OleDbCommandBuilder OleDbError, OleDbParameter, OleDbPermission, and OleDbTransaction. To use these classes in your application, you need to add a reference to the System.Data.OleDb namespace in your application.

System.Data.SQLClient:  It  Contains Classes like sqlcommand,sqlconnection,sqldataadapter etc.,  and  and types for accessing Microsoft SQL Server databases.The System.Data.SqlClient namespaces define Sql.NET data provider classes to work with SQL server 7.0 or later databases. Its main function is to help in connecting with TDS interface and provide better performance.

System.Data.SQLTypes: System.DataSqlTypes, provides a group classes like SqlBinary SqlMoney, SqlString, SqlDouble, SqlDateTime, and SqlNumeric etc., representing the specific types found in SQL server.

System.Data.XML: It Contains Classes and types for accessing other databases. Its helps in basic objects method to create, read, store, write, and manipulate XML documents.

System.Data.OracleClient: It Contains Classes like OracleConnection, OracleCommand,etc., and types for accessing Oracle databases (Microsoft .NET Framework version 1.1 and later)

Go to previous interview question .NET Framework Data Providers | What are .NET Framework Data Providers