Why is ADO.NET serialization slower than ADO ?
How can I retrieve two tables of data at a time by using data reader? Data reader read and forward only, how is it possible to get 2 tables of data at a time?
What is aggregate root?
Which property is used to check whether a DataReader is closed or opened?
Which object of ado contains datarow datacolumn collection?
What is oledb connection?
What is concurrency? How will you avoid concurrency when dealing with dataset? (One user deleted one row after that another user through his dataset was trying to update same row. What will happen? How will you avoid the problem?)
What are all components of ADO.Net data provider?
What is execute scalar in ado.net?
Explain the namespaces in which .net has the data functionality class.
How do you merge 2 datasets into the third dataset in a simple manner?
What are all the different authentication techniques used to connect to MS SQL Server?
How to load multiple tables into a dataset?
What are the objects of ado.net?
How to generate a single aggregate?