Why is ADO.NET serialization slower than ADO ?

1047

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?

975

What is aggregate root?

1095

Which property is used to check whether a DataReader is closed or opened?

1045

Which object of ado contains datarow datacolumn collection?

964

What is oledb connection?

984

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?)

1000

What are all components of ADO.Net data provider?

1058

What is execute scalar in ado.net?

961

Explain the namespaces in which .net has the data functionality class.

1081

How do you merge 2 datasets into the third dataset in a simple manner?

990

What are all the different authentication techniques used to connect to MS SQL Server?

1083

How to load multiple tables into a dataset?

1050

What are the objects of ado.net?

1067

How to generate a single aggregate?

975