ADO.Net Questions

Q1)What is DataViewManager?
Ans)
DataViewManager is used to manage view settings of the tables in a DataSet. A DataViewManager is best suited for views that consist of a combination of multiple tables. The properties like ApplyDefaultSort, Sort, RowFilter, and RowStateFilter are referenced using DataViewSetting.
---------------------------------
Q2)What is the role of data provider?
Ans)

The .NET data provider layer resides between the application and the database. Its task is to take care of all their interactions.

The .NET Data provider can be demonstrated to be:
• SQL Server data provider
• OLEDB data provider
• ODBC Data Provider

ADO.NET supports the following OLE DB Providers:
• SQLOLEDB - Microsoft OLE DB Provider for SQL Server.
• MSDAORA - Microsoft OLE DB Provider for Oracle.
• Microsoft.Jet.OLEDB.4.0 - OLE DB Provider for Microsoft Jet
--------------------------------
Q3) How to convert a DataSet to a DataReader?
Ans)
DataTableReader rd = ds.Tables[0].CreateDataReader();