Data Access Modes

Question: Which ADO.NET interface is used for connection-oriented data access? Which class is used for connectionless data access?

Answer: The interface IDataReader is used for connection-oriented data access. The classes DataSet and DataAdapter are intended for a connectionless data access.