Summary

As you begin to develop in ADO.NET, you'll likely need to use providers not shipped with VS .NET. Microsoft and other vendors might build some of these, such as the Odbc, Oracle, and DB2 providers, or you might need to build your own within your organization. The programming pattern exposed in the System.Data and System.Data.Common namespaces makes both using new providers and building providers relatively straightforward.

Today you learned how the Odbc provider from Microsoft works, along with a few of its differences from SqlClient and OleDb. You also should now be familiar with the reasons you might build your own provider and what a lightweight implementation might look like.

Today's lesson ends Week 2 and the discussion of .NET Data ...

Get Sams Teach Yourself ADO.NET in 21 Days 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.