Summary

In this chapter, you added more data providers to your data provider list. You learned about various data providers to access Oracle databases. We discussed the Oracle .NET data provider in detail and showed you how you can access Oracle databases.

The SQLXML .NET data provider provides a fast and optimized way to communicate between SQL Server and XML. In this chapter, you saw how to install and work with the XML .NET data provider.

In the next chapter, you'll put all the data provider–related pieces together and work with some data provider internals. You'll also learn how to build your own custom data provider.