April 2003
Beginner to intermediate
620 pages
21h 48m
English
Content preview from ADO.NET in a Nutshell
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,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Chapter 36. The System.Data.SqlClient Namespace
The
System.Data.SqlClient namespace contains the
provider-specific ADO.NET objects used to connect to a SQL Server 7
or SQL Server 2000 database, execute a command, and transfer
information to and from a DataSet. The SQL Server
.NET provider is optimized for accessing the SQL Server data source
protocol; it doesn’t use an intermediate OLE DB
provider or ODBC driver. The classes in this namespace can also be
used with MSDE databases. If you need to connect to a version of SQL
Server earlier than 7.0, you need to instead use the .NET OLE DB data
provider.
Many types in this namespace implement a common interface from the
System.Data namespace or inherit from a class in
the System.Data.Common namespace. This ensures a
high degree of commonality between these types and those supplied
with other ADO.NET data providers. The documentation for this
namespace refers to these inherited classes and implemented
interfaces where appropriate, and notes any SQL Server-specific
functionality. Figure 36-1 and Figure 36-2 show the types in this namespace.
 |
Figure 36-1. The System.Data.SqlClient namespace
 |
Figure 36-2. More types from System.Data.SqlClient
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
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.