Summary

for RuBoard

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 Providers. From here on out, you'll learn how to apply everything discussed in the previous weeks and look to the future.

for RuBoard