Define data access layer?
What providers do you use to connect to oracle database ?
Explain which name space is used to get assembly details?
Command objects uses, purposes and their methods.
What are the different ado.net namespaces are available in .net?
What is the DataTableCollection?
What do you know about ADO.NET's objects and methods?
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 connect and retrieve data from database using dataset
Is datareader faster than datatable?
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 connection in ado.net?
How do you update a dataset in ado.net?