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. ...
Get Programming Microsoft® ASP.NET 3.5 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
