In this chapter, you learned about the first level of database access with ADO.NET: connected access. In many cases, using simple commands and quick read-only cursors to retrieve results provides the easiest and most efficient way to write data access code for a web application. Along the way, you considered some advanced topics, including SQL injection attacks, transactions, and provider-agnostic code.
In the next chapter, you’ll learn how to use these techniques to build your own data access classes and how to use ADO.NET’s disconnected DataSet.
KeywordsData Provider Snapshot Isolation Isolation Level Nest Transaction Connection Object
Unable to display preview. Download preview PDF.