Objective 2.4: Query and manipulate data by using ADO.NET
Although the EF is clearly the predominant data access path, Microsoft appears to have chosen, ADO.NET has been around for roughly 12 years and is a tried-and-true technology. There are countless books written on ADO.NET. Although each new ADO.NET version adds features, the basic workings and concepts remain the same.
Querying data using Connection, DataReader, Command, DataAdapter, and DataSet
The Connection, DataReader, Command, DataAdapter, and Dataset/DataTable implementations are essential components of ADO.NET. ...