Export (0) Print
Expand All

SqlConnection Members

Represents an open connection to a SQL Server database. This class cannot be inherited.

The SqlConnection type exposes the following members.

  NameDescription
Public method Supported by the .NET Compact Framework SqlConnection Overloaded. Initializes a new instance of the SqlConnection class.
Top

  NameDescription
Protected method BeginDbTransaction Starts a database transaction. (Inherited from DbConnection.)
Public method Supported by the .NET Compact Framework BeginTransaction Overloaded. Starts a database transaction.
Public method Supported by the .NET Compact Framework ChangeDatabase Changes the current database for an open SqlConnection. (Overrides DbConnection.ChangeDatabase(String).)
Public method Static member ChangePassword Changes the SQL Server password for the user indicated in the connection string to the supplied new password.
Public method Static member ClearAllPools Empties the connection pool.
Public method Static member ClearPool Empties the connection pool associated with the specified connection.
Public method Supported by the .NET Compact Framework Close Closes the connection to the database. This is the preferred method of closing any open connection. (Overrides DbConnection.Close().)
Public method Supported by the .NET Compact Framework CreateCommand Creates and returns a SqlCommand object associated with the SqlConnection.
Protected method CreateDbCommand Creates and returns a DbCommand object associated with the current connection. (Inherited from DbConnection.)
Public method CreateObjRef Creates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object. (Inherited from MarshalByRefObject.)
Public method Supported by the .NET Compact Framework Dispose Overloaded. Releases the resources used by the Component.
Public method EnlistDistributedTransaction Enlists in the specified transaction as a distributed transaction.
Public method EnlistTransaction Enlists in the specified transaction as a distributed transaction. (Overrides DbConnection.EnlistTransaction(Transaction).)
Public method Supported by the .NET Compact Framework Equals Determines whether the specified Object is equal to the current Object. (Inherited from Object.)
Protected method Supported by the .NET Compact Framework Finalize Releases unmanaged resources and performs other cleanup operations before the Component is reclaimed by garbage collection. (Inherited from Component.)
Public method Supported by the .NET Compact Framework GetHashCode Serves as a hash function for a particular type. (Inherited from Object.)
Public method GetLifetimeService Retrieves the current lifetime service object that controls the lifetime policy for this instance. (Inherited from MarshalByRefObject.)
Public method GetSchema Overloaded. Returns schema information for the data source of this SqlConnection.
Protected method GetService Returns an object that represents a service provided by the Component or by its Container. (Inherited from Component.)
Public method Supported by the .NET Compact Framework GetType Gets the type of the current instance. (Inherited from Object.)
Public method InitializeLifetimeService Obtains a lifetime service object to control the lifetime policy for this instance. (Inherited from MarshalByRefObject.)
Protected method Supported by the .NET Compact Framework MemberwiseClone Overloaded.
Protected method OnStateChange Raises the StateChange event. (Inherited from DbConnection.)
Public method Supported by the .NET Compact Framework Open Opens a database connection with the property settings specified by the ConnectionString. (Overrides DbConnection.Open().)
Public method ResetStatistics If statistics gathering is enabled, all values are reset to zero.
Public method RetrieveStatistics Returns a name value pair collection of statistics at the point in time the method is called.
Public method ToString Returns a String containing the name of the Component, if any. This method should not be overridden. (Inherited from Component.)
Top

  NameDescription
Protected property CanRaiseEvents Gets a value indicating whether the component can raise an event. (Inherited from Component.)
Public property Supported by the .NET Compact Framework ConnectionString Gets or sets the string used to open a SQL Server database. (Overrides DbConnection.ConnectionString.)
Public property Supported by the .NET Compact Framework ConnectionTimeout Gets the time to wait while trying to establish a connection before terminating the attempt and generating an error. (Overrides DbConnection.ConnectionTimeout.)
Public property Container Gets the IContainer that contains the Component. (Inherited from Component.)
Public property Supported by the .NET Compact Framework Database Gets the name of the current database or the database to be used after a connection is opened. (Overrides DbConnection.Database.)
Public property Supported by the .NET Compact Framework DataSource Gets the name of the instance of SQL Server to which to connect. (Overrides DbConnection.DataSource.)
Protected property DbProviderFactory Gets the DbProviderFactory for this DbConnection. (Inherited from DbConnection.)
Protected property DesignMode Gets a value that indicates whether the Component is currently in design mode. (Inherited from Component.)
Protected property Supported by the .NET Compact Framework Events Gets the list of event handlers that are attached to this Component. (Inherited from Component.)
Public property FireInfoMessageEventOnUserErrors Gets or sets the FireInfoMessageEventOnUserErrors property.
Public property Supported by the .NET Compact Framework PacketSize Gets the size (in bytes) of network packets used to communicate with an instance of SQL Server.
Public property Supported by the .NET Compact Framework ServerVersion Gets a string that contains the version of the instance of SQL Server to which the client is connected. (Overrides DbConnection.ServerVersion.)
Public property Supported by the .NET Compact Framework Site Gets or sets the ISite of the Component. (Inherited from Component.)
Public property Supported by the .NET Compact Framework State Indicates the state of the SqlConnection. (Overrides DbConnection.State.)
Public property StatisticsEnabled When set to true, enables statistics gathering for the current connection.
Public property Supported by the .NET Compact Framework WorkstationId Gets a string that identifies the database client.
Top

  NameDescription
Public event Supported by the .NET Compact Framework Disposed Occurs when the component is disposed by a call to the Dispose method. (Inherited from Component.)
Public event Supported by the .NET Compact Framework InfoMessage Occurs when SQL Server returns a warning or informational message.
Public event Supported by the .NET Compact Framework StateChange Occurs when the state of the event changes. (Inherited from DbConnection.)

In .NET Compact Framework 3.5, this member is StateChange.
Top

Community Additions

ADD
Show:
© 2014 Microsoft