Collected from the Internet:

ADO.NET and Database Questions

1. What is the role of the DataReader class in ADO.NET connections? Ans. It returns a read-only, forward-only rowset from the data source.  A DataReader provides fast access when a forward-only sequential read is needed. 2.What are advantages and disadvantages of Microsoft provided data provider classes in ADO.NET? Ans. SQLServer.NET data provider is high-speed and robust, but requires SQL Server license purchased from Microsoft. OLE-DB.NET is universal for accessing other sources, like Oracle, DB2, Microsoft Access and Informix.  OLE-DB.NET More >