12.10. Conclusion

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. ...

Get A Programmer's Guide to .NET now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.