Explain the namespaces in which .net has the data functionality class.
What is ado.net and its architecture?
What is sqldatareader in ado.net?
Which is better ole db or odbc?
What is executequery?
What is the difference between linq and ado.net?
Define table relations?
what is Sql Native Client?
What is the executescalar method?
Can I use One Data Set for More than one Data Adapter?
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 do we invoke queries from the application ?
If a dataset contains 100 rows, how to fetch rows between 10 and 20 only ?