Interview Questions – ADO.NET
ADO.NET and Database Interview Questions
02 years ago
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 >