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. ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access