O'Reilly logo

Programming Microsoft® ASP.NET 3.5 by Dino Esposito

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Connecting to Data Sources

The ADO.NET programming model is based on a relatively standard and database-independent sequence of steps. You first create a connection, then prepare and execute a command, and finally process the data retrieved. As far as basic operations and data types are involved, this model works for most providers. Some exceptions are BLOB fields management for Oracle databases and perhaps bulk copy and XML data management for SQL Server databases.

In the rest of the chapter, we'll mostly discuss how ADO.NET data classes work with SQL Server (from version 7.0 onward). However, we'll promptly point out any aspect that is significantly different than other .NET data providers. To start out, let's see how connections take place. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required