In this chapter we learned about ADO.NET – the data access component of the Microsoft .NET Framework.
We started this chapter with a discussion of cover namespaces that contain classes used in the ADO.NET – the System.Data namespace, which can be found in the System.Data.dll assembly, and its secondary namespaces System.Data.Common, System.Data.OleDb, System.Data.SqlClient, and System.Data.SqlTypes.
After this we learned about managed providers to access OLE DB data sources and SQL Server databases. We also talked about the four main components of a managed provider – connections, commands, data readers, and data adapters.
We also discussed tables, rows, and columns exposed via the object model provided by the DataSet class. ...