System.Data.SqlClient Namespace

The System.Data.SqlClient namespace is the .NET Data Provider for SQL Server. The classes in this namespace bypass OLE DB and communicate directly with SQL Server, therefore increasing performance tremendously when using SQL Server.

SqlCommand Object Members

The SqlCommand class represents a Transact-SQL query or stored procedure to execute at a SQL Server database. Tables B.43 through B.46 list the constructor, properties, methods, and events for the SqlCommand class.

Table B.43. SqlCommand Constructor
Name Parameters Description
SqlCommand none Initializes a new instance of the SqlCommand class.
SqlCommand cmdText (String) Initializes a new instance of the SqlCommand class with the specified command text.
SqlCommand ...

Get ASP.NET by Example now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.