System.Data.SqlClient Namespace

The System.Data.SqlClient namespace is the.NET Framework Data Provider for SQL Server.

The.NET Framework Data Provider for SQL Server describes a collection of classes used to access a SQL Server database in the managed space. Using the SqlDataAdapter, you can fill a memory-resident DataSet that you can use to query and update the database.

NoteNote

For conceptual information about using this namespace when programming with the .NET Framework, see SQL Server and ADO.NET.

Caution ADO.NET 2.0 does not support Asynchronous commands over shared memory for SQL Server 2000 or lower. However, you can force TCP instead of shared memory. You can do that by prefixing tcp: to the server name in the connection string or you can use localhost.

  ClassDescription
Public classSqlBulkCopyLets you efficiently bulk load a SQL Server table with data from another source.
Public classSqlBulkCopyColumnMappingDefines the mapping between a column in a SqlBulkCopy instance's data source and a column in the instance's destination table.
Public classSqlBulkCopyColumnMappingCollectionCollection of SqlBulkCopyColumnMapping objects that inherits from CollectionBase.
Public classSqlClientFactoryRepresents a set of methods for creating instances of the System.Data.SqlClient provider's implementation of the data source classes.
Public classSqlClientMetaDataCollectionNamesProvides a list of constants for use with the GetSchema method to retrieve metadata collections.
Public classSqlClientPermissionEnables the .NET Framework Data Provider for SQL Server to help make sure that a user has a security level sufficient to access a data source.
Public classSqlClientPermissionAttributeAssociates a security action with a custom security attribute.
Public classSqlCommandRepresents a Transact-SQL statement or stored procedure to execute against a SQL Server database. This class cannot be inherited.
Public classSqlCommandBuilderAutomatically generates single-table commands that are used to reconcile changes made to a DataSet with the associated SQL Server database. This class cannot be inherited.
Public classSqlConnectionRepresents an open connection to a SQL Server database. This class cannot be inherited.
Public classSqlConnectionStringBuilderProvides a simple way to create and manage the contents of connection strings used by the SqlConnection class.
Public classSqlDataAdapterRepresents a set of data commands and a database connection that are used to fill the DataSet and update a SQL Server database. This class cannot be inherited.
Public classSqlDataReaderProvides a way of reading a forward-only stream of rows from a SQL Server database. This class cannot be inherited.
Public classSQLDebuggingInfrastructure. Included to support debugging applications. Not intended for direct use.
Public classSqlDependencyThe SqlDependency object represents a query notification dependency between an application and an instance of SQL Server 2005. An application can create a SqlDependency object and register to receive notifications via the OnChangeEventHandler event handler.
Public classSqlErrorCollects information relevant to a warning or error returned by SQL Server.
Public classSqlErrorCollectionCollects all errors generated by the .NET Framework Data Provider for SQL Server. This class cannot be inherited.
Public classSqlExceptionThe exception that is thrown when SQL Server returns a warning or error. This class cannot be inherited.
Public classSqlInfoMessageEventArgsProvides data for the InfoMessage event.
Public classSqlNotificationEventArgsRepresents the set of arguments passed to the notification event handler.
Public classSqlParameterRepresents a parameter to a SqlCommand and optionally its mapping to DataSet columns. This class cannot be inherited. For more information on parameters, see Configuring Parameters and Parameter Data Types (ADO.NET).
Public classSqlParameterCollectionRepresents a collection of parameters associated with a SqlCommand and their respective mappings to columns in a DataSet. This class cannot be inherited.
Public classSqlRowsCopiedEventArgsRepresents the set of arguments passed to the SqlRowsCopiedEventHandler.
Public classSqlRowUpdatedEventArgsProvides data for the RowUpdated event.
Public classSqlRowUpdatingEventArgsProvides data for the RowUpdating event.
Public classSqlTransactionRepresents a Transact-SQL transaction to be made in a SQL Server database. This class cannot be inherited.

  DelegateDescription
Public delegateOnChangeEventHandlerHandles the OnChange event that is fired when a notification is received for any of the commands associated with a SqlDependency object.
Public delegateSqlInfoMessageEventHandlerRepresents the method that will handle the InfoMessage event of a SqlConnection.
Public delegateSqlRowsCopiedEventHandlerRepresents the method that handles the SqlRowsCopied event of a SqlBulkCopy.
Public delegateSqlRowUpdatedEventHandlerRepresents the method that will handle the RowUpdated event of a SqlDataAdapter.
Public delegateSqlRowUpdatingEventHandlerRepresents the method that will handle the RowUpdating event of a SqlDataAdapter.

  EnumerationDescription
Public enumerationApplicationIntentSpecifies a value for ApplicationIntent. Possible values are ReadWrite and ReadOnly.
Public enumerationSortOrderSpecifies how rows of data are sorted.
Public enumerationSqlBulkCopyOptionsBitwise flag that specifies one or more options to use with an instance of SqlBulkCopy.
Public enumerationSqlNotificationInfoThis enumeration provides additional information about the different notifications that can be received by the dependency event handler.
Public enumerationSqlNotificationSourceIndicates the source of the notification received by the dependency event handler.
Public enumerationSqlNotificationTypeDescribes the different notification types that can be received by an OnChangeEventHandler event handler through the SqlNotificationEventArgs parameter.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft