System.Data.SqlClient
Namespace with 35 public types
Classes
                                     SqlBulkCopy
                                    Lets you efficiently bulk load a SQL Server table with data from another source.
                                
                            
                            
                                
                                     SqlBulkCopyColumnMapping
                                    Defines the mapping between a column in a  instance's data source and a column in the instance's destination table.
                                
                            
                            
                                
                                     SqlBulkCopyColumnMappingCollection
                                    Collection of  objects that inherits from .
                                
                            
                            
                                
                                     SqlClientFactory
                                    Represents a set of methods for creating instances of the  provider's implementation of the data source classes.
                                
                            
                            
                                
                                     SqlCommand
                                    Represents a Transact-SQL statement or stored procedure to execute against a SQL Server database. This class cannot be inherited.
                                
                            
                            
                                
                                     SqlCommandBuilder
                                    Automatically generates single-table commands that are used to reconcile changes made to a  with the associated SQL Server database. This class cannot be inherited.
                                
                            
                            
                                
                                     SqlConnection
                                    Represents a connection to a SQL Server database. This class cannot be inherited.
                                
                            
                            
                                
                                     SqlConnectionStringBuilder
                                    Provides a simple way to create and manage the contents of connection strings used by the  class.
                                
                            
                            
                                
                                     SqlCredential
                                    provides a more secure way to specify the password for a login attempt using SQL Server Authentication.
 is comprised of a user id and a password that will be used for SQL Server Authentication. The password in a  object is of type .
 cannot be inherited.
Windows Authentication () remains the most secure way to log in to a SQL Server database.
                                
                            
                            
                                
                                     SqlDataAdapter
                                    Represents a set of data commands and a database connection that are used to fill the  and update a SQL Server database. This class cannot be inherited.
                                
                            
                            
                                
                                     SqlDataReader
                                    Provides a way of reading a forward-only stream of rows from a SQL Server database. This class cannot be inherited.
                                
                            
                            
                                
                                     SqlDependency
                                    The  object represents a query notification dependency between an application and an instance of SQL Server. An application can create a  object and register to receive notifications via the  event handler.
                                
                            
                            
                                
                                     SqlError
                                    Collects information relevant to a warning or error returned by SQL Server.
                                
                            
                            
                                
                                     SqlErrorCollection
                                    Collects all errors generated by the .NET Framework Data Provider for SQL Server. This class cannot be inherited.
                                
                            
                            
                                
                                     SqlException
                                    The exception that is thrown when SQL Server returns a warning or error. This class cannot be inherited.
                                
                            
                            
                                
                                     SqlInfoMessageEventArgs
                                    Provides data for the  event.
                                
                            
                            
                                
                                     SqlNotificationEventArgs
                                    Represents the set of arguments passed to the notification event handler.
                                
                            
                            
                                
                                     SqlParameter
                                    Represents a parameter to a  and optionally its mapping to  columns. This class cannot be inherited. For more information on parameters, see Configuring Parameters and Parameter Data Types.
                                
                            
                            
                                
                                     SqlParameterCollection
                                    Represents a collection of parameters associated with a  and their respective mappings to columns in a . This class cannot be inherited.
                                
                            
                            
                                
                                     SqlRowsCopiedEventArgs
                                    Represents the set of arguments passed to the .
                                
                            
                            
                                
                                     SqlRowUpdatedEventArgs
                                    Provides data for the  event.
                                
                            
                            
                                
                                     SqlRowUpdatingEventArgs
                                    Provides data for the  event.
                                
                            
                            
                                
                                     SqlTransaction
                                    Represents a Transact-SQL transaction to be made in a SQL Server database. This class cannot be inherited.
                                
                            
                        
                        Enumerations
                                     ApplicationIntent
                                    Specifies a value for . Possible values are  and .
                                
                            
                            
                                
                                     SortOrder
                                    Specifies how rows of data are sorted.
                                
                            
                            
                                
                                     SqlBulkCopyOptions
                                    Bitwise flag that specifies one or more options to use with an instance of .
                                
                            
                            
                                
                                     SqlNotificationInfo
                                    This enumeration provides additional information about the different notifications that can be received by the dependency event handler.
                                
                            
                            
                                
                                     SqlNotificationSource
                                    Indicates the source of the notification received by the dependency event handler.
                                
                            
                            
                                
                                     SqlNotificationType
                                    Describes the different notification types that can be received by an  event handler through the  parameter.
                                
                            
                        
                        Static Classes
                                     SqlClientMetaDataCollectionNames
                                    Provides a list of constants for use with the GetSchema method to retrieve metadata collections.