Thursday, February 3, 2011

What is the namespace in which .NET has the data functionality classes ?

Following are the namespaces provided by .Net for data management

System.Data : This contains the basic objects which can be used for accessing and storing relational data, such as DataSet, DataTable, and DataRelation. Each of these are independent of the type of data source and the way we connect to it.

System.Data.OleDB : It contains the objects which can be used to connect to a data source via an OLE-DB provider, such as OleDbConnection, OleDbCommand , etc. These objects are inherited from the common base classes, and so have the same properties, methods, and events as the SqlClient equivalents.

System.Data.SqlClient : This contains the objects which can be used to connect to a data source via the Tabular Data Stream (TDS) interface of Microsoft Sql Server (only). This can generally provide better performance as this removes some of the intermediate layers required by an OLE-DB connection.

System.XML : This Contains the basic objects which are required to create, read, store, write, and manipulate XML documents according to W3C recommendations.


Thanks..

2 comments:

Shyam Meena said...

Very good information to me, thanks to you.

Kapil Dev said...

very useful information for me, thanks dear...