What is the significance of CommandBehavior.CloseConnection ?
What are the different namespaces used in the project to connect the database? What data providers available in .net to connect to database?
How would you connect to database using .NET?
In how many ways we can retrieve table records count? How to find the count of records in a dataset?
how you will deal result set? How do you sort a dataset?If a dataset contains 100 rows, how to fetch rows between 5 and 15 only?
What is method to get XML and schema from Dataset? getXML() and get Schema ()
How do you implement locking concept for dataset?
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?)
How to check if a datareader is closed or opened? IsClosed()
How do you merge 2 datasets into the third dataset in a simple manner?
Explain the advantage of ADO.Net?
Which control of the BindingNavigator returns the current position within the data source?
Describe the disconnected architecture of ADO.NET’s data access model.
What is the DataTableCollection?
What are the benefits of using of ADO.NET in .NET 4.0?