ADO.NET Difference Between Questions List-1

1. Difference between Clone and Copy methods of DataSet
2. Difference between DataSet and DataReader
3. Difference between Classic ADO and ADO.Net
4. Difference between Optimistic and Pessimistic Locking
5. Difference between ADO.Net DataSet and ADO RecordSet
6. Difference between ADO.Net DataSet and Entity Framework
7. Difference between ExecuteScalar(), ExecuteReader() and ExecuteNonQuery()
8. Difference between OLEDB SQL Server and OLEDB Dotnet Provider
9. Difference between SqlCommand object and CommandBehaviour object
10. Difference between Typed and Untyped DataSet
11. Difference between DataView and DataTable
12. Difference between Connected and Disconnected environment
13. Difference between DataSet and DataTable
14. Difference between OLEDB Reader and DataSet
15. Difference between DataGrid, DataList and Repeater
16. Difference between DataReader and DataAdapter
17. Difference between DataList and GridView
18. Difference between DataGrid and GridView
19. Difference between DetailsView and FormView
20. Difference between GridView and ListView
21. Difference between OLEDB Provider and SqlClient
22. Difference between DataRow.Delete() and DataRow.Remove()
23. Difference between COMMAND BUILDER and COMMAND