SqlCeConnection Members

  • Article

Represents an open connection to a data source.

The following tables list the members exposed by the SqlCeConnection type.

Public Constructors

  Name Description
Public method Supported by the .NET Compact Framework SqlCeConnection Overloaded. Initializes a new instance of the SqlCeConnection class.

Top

Public Properties

(see also Protected Properties )

  Name Description
Public property Supported by the .NET Compact Framework ConnectionString Overridden. Gets or sets the string used to open a database.
Public property Supported by the .NET Compact Framework ConnectionTimeout Overridden. Gets the time to wait while trying to establish a connection before terminating the attempt and generating an error.
Public property Container  Gets the IContainer that contains the Component.(inherited from Component)
Public property Supported by the .NET Compact Framework Database Overridden. Gets the name of the current database or the database to be used when a connection is open.
Public property Supported by the .NET Compact Framework DataSource Overridden. Gets the file name of the data source. In SQL Server Compact Edition, databases are always stored in separate files.
Public property Supported by the .NET Compact Framework ServerVersion Overridden. Returns the SQL Server Compact Edition version number as a string.
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 Overridden. Gets the current state of the connection.

Top

Protected Properties

  Name Description
Protected property CanRaiseEvents  Gets a value indicating whether the component can raise an event.(inherited from Component)
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)

Top

Public Methods

(see also Protected Methods )

  Name Description
Public method Supported by the .NET Compact Framework BeginTransaction Overloaded. Begins a database transaction.
Public method Supported by the .NET Compact Framework ChangeDatabase Overridden. Changes the current database for an open SqlCeConnection.
Public method Supported by the .NET Compact Framework Close Overridden. Closes the connection to the data source. This is the preferred method of closing any open connection.
Public method Supported by the .NET Compact Framework CreateCommand Creates and returns a SqlCeCommand object associated with the SqlCeConnection.
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. (inherited from Component)
Public method EnlistTransaction  Enlists in the specified transaction. (inherited from DbConnection)
Public method Supported by the .NET Compact Framework Equals  Overloaded. Determines whether two Object instances are equal. (inherited from Object)
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 Supported by the .NET Compact Framework GetSchema  Overloaded. Returns schema information for the data source of this DbConnection. (inherited from DbConnection)
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)
Public method Supported by the .NET Compact Framework Open Overridden. Opens a database connection with the property settings specified by the ConnectionString.
Public method Static Supported by the .NET Compact Framework ReferenceEquals  Determines whether the specified Object instances are the same instance. (inherited from Object)
Public method Supported by the .NET Compact Framework ToString  Returns a String containing the name of the Component, if any. This method should not be overridden. (inherited from Component)

Top

Protected Methods

  Name Description
Protected method Supported by the .NET Compact Framework BeginDbTransaction  Starts a database transaction. (inherited from DbConnection)
Protected method Supported by the .NET Compact Framework CreateDbCommand  Creates and returns a DbCommand object associated with the current connection. (inherited from DbConnection)
Protected method Supported by the .NET Compact Framework Dispose  Overloaded. Releases the resources used by the Component. (inherited from Component)
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)
Protected method GetService  Returns an object that represents a service provided by the Component or by its Container. (inherited from Component)
Protected method Supported by the .NET Compact Framework MemberwiseClone  Overloaded. (inherited from MarshalByRefObject)
Protected method Supported by the .NET Compact Framework OnStateChange  Raises the StateChange event. (inherited from DbConnection)

Top

Public Events

  Name Description
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 FlushFailure Occurs when the background flush fails.
Public event Supported by the .NET Compact Framework InfoMessage Occurs when the .NET Compact Framework Data Provider for SQL Server sends a warning or an informational message.
Public event Supported by the .NET Compact Framework StateChange Occurs when the state of the connection changes.

Top

Explicit Interface Implementations

  Name Description
Explicit interface implementation Supported by the .NET Compact Framework System.Data.IDbConnection.BeginTransaction Overloaded.  
Explicit interface implementation Method Supported by the .NET Compact Framework System.Data.IDbConnection.CreateCommand  

Top

See Also

Reference

SqlCeConnection Class
System.Data.SqlServerCe Namespace
SqlCeDataAdapter
SqlCeCommand