| 1. What is the namespace in which .NET has the data functionality classes ? |
| 2. Can you give a overview of ADO.NET architecture ? |
|
|
| 3. What are the two fundamental objects in ADO.NET ? |
| 4. What is difference between dataset and datareader ? |
| 5. What are major difference between classic ADO and ADO.NET ? |
| 6. What is the use of connection object ? |
| 7. What is the use of command objects and what are the methods provided by the command object ? |
|
|
| 8. What is the use of dataadapter ? |
| 9. What are basic methods of Dataadapter ? |
| 10. What is Dataset object? |
| 11. What are the various objects in Dataset ? |
| 12. How can we connect to Microsoft Access , Foxpro , Oracle etc ? |
|
|
| 13. How do we connect to SQL SERVER , which namespace do we use ? |
| 14. How do we use stored procedure in ADO.NET and how do we provide parameters to the stored procedures? |
| 15. How can we force the connection object to close after my datareader is closed ? |
| 16. I want to force the datareader to return only schema of the datastore rather than data ? |
| 17. How can we fine tune the command object when we are expecting a single row or a single value ? |
| 18. Which is the best place to store connectionstring in .NET projects ? |
| 19. What are steps involved to fill a dataset ?(Twist :- How can we use dataadapter to fill a dataset ?) |
| 20. What are the various methods provided by the dataset object to generate XML? |
| 21. How can we save all data from dataset ? |
| 22. How can we check that some changes have been made to dataset since it was loaded ?(Twist :- How can cancel all changes done in dataset ? ,How do we get changed value dataset ? ) |
| 23. How add/remove rows in DataTable object of DataSet ? |
| 24. Whats basic use of DataView ? |
| 25. Whats difference between DataSet and DataReader ? |
| 26. How can we load multiple tables in a DataSet ? |
| 27. How can we add relations between table in a DataSet ? |
| 28. Whats the use of CommandBuilder ? |
| 29. Whats difference between Optimistic and Pessimistic locking ? |
| 30. How many ways are there to implement locking in ADO.NET ? |
| 31. How can we perform transactions in .NET? |
| 32. Whats difference between Dataset. clone and Dataset. copy ? |
