Week 2 In Review

for RuBoard

This week you learned about the various objects that make up the second major component of ADO.NET, the .NET Data Providers. Along the way, I hope you picked up some techniques for using the objects in various situations. In addition, one of the key insights you should have gained is that providers come in two basic flavors, narrow and specific, and that both are based on the common base classes and interfaces in the System.Data namespace.

You started the week by learning about the responsibilities of the various objects typically included in a .NET Data Provider. You then proceeded to go in-depth with each object in turn . This included learning about connections and transactions and how to use connection pooling and connection strings, command objects and the various methods they expose, data readers and their differences from DataSet objects, data adapters and how DataSet objects are filled and updated, various aspects of accessing SQL Server, and techniques for using the ODBC .NET Data Provider as well as building your own provider.

You should now be quite familiar with using the objects in the .NET Data Providers and also be ready to apply them in the design and implementation of a modern multi- tier application, as you'll learn about next week. So, take a short break to prepare your mind for a week of implementation and futures .

for RuBoard