Ado.net architecture

* System.Data:This namespace is the base of ADO.NET. It provides all the
classes that are used by data providers. The most import class that it supports
is DataSet. It also contains classes to represent tables, columns, rows,
relation and the constraint class.

* System.Data.Common:This namespace defines common classes that are used as
base classes for data providers. These classes are used by all data providers.
Examples are DbConnection and DbDataAdapter.

* System.Data.OleDb:This namespace provides classes that work with OLE-DB data
sources using the .NET OleDb data provider.Example of these classes are as
follows:

** OleDbConnection.
** OleDbCommand.

* System.Data.Odbc:It defines the data provider for the SQL Server database. It
contains classes such as

What is the difference between dataset clone and copy?

What is the meaning of object pooling?

Object pooling is a concept of storing a pool (group) of objects in memory that
can be reused later as needed. Whenever, a new object is required to create, an
object from the pool can be allocated for this request; thereby, minimizing the
object creation. A pool can also refer to a group of connections and threads.
Pooling, therefore, helps in minimizing the use of system resources, improves
system scalability, and performance.

What is the use of CommandBuilder?

CommandBuilder is used to build complex queries. It can even build commands
that are based on the returned results. CommandBuilder is less error prone and
more readable than the command object.

What is the use of Data View?

Data View represents a complete table or can be small of rows depending on some
criteria. It is the best used for sorting and finding data with in data table.