SqlCeDatabase Members

  • Article
Retired Content

This content is outdated and is no longer being maintained. It is provided as a courtesy for individuals who are still using these technologies. This page may contain URLs that were valid when originally published, but now link to sites or pages that no longer exist.
The latest Enterprise Library information can be found at the Enterprise Library site.

The SqlCeDatabase type exposes the following members.

Constructors

  Name Description
Ee761407.pubmethod(en-us,PandP.10).gif SqlCeDatabase
Initializes a new instance of the SqlCeDatabase class with a connection string.

Methods

  Name Description
Ee761407.pubmethod(en-us,PandP.10).gif AddInParameter Overloaded.
Ee761407.pubmethod(en-us,PandP.10).gif AddOutParameter
Adds a new Out DbParameter object to the given command.
(Inherited from Database.)
Ee761407.pubmethod(en-us,PandP.10).gif AddParameter Overloaded.
Ee761407.protmethod(en-us,PandP.10).gif AddParameters
Adds any parameters to the command
Ee761407.pubmethod(en-us,PandP.10).gif BuildParameterName
Builds a value parameter name for the current database.
(Overrides DatabaseBuildParameterName(String).)
Ee761407.pubmethod(en-us,PandP.10).gif CloseSharedConnection
This will close the "keep alive" connection that is kept open once you first access the database through this class. Calling this method will close the "keep alive" connection for all instances. The next database access will open a new "keep alive" connection.
Ee761407.protmethod(en-us,PandP.10).gif ConfigureParameter
Configures a given DbParameter.
(Inherited from Database.)
Ee761407.pubmethod(en-us,PandP.10).gif CreateConnection

Creates a connection for this database.

(Overrides DatabaseCreateConnection().)
Ee761407.pubmethod(en-us,PandP.10).gif CreateFile
Creates a new, empty database file using the file name provided in the Data Source attribute of the connection string.
Ee761407.pubmethod(en-us,PandP.10).gif CreateParameter Overloaded.
Ee761407.protmethod(en-us,PandP.10).gif DeriveParameters
Don't need an implementation for SQL Server CE.
(Overrides DatabaseDeriveParameters(DbCommand).)
Ee761407.pubmethod(en-us,PandP.10).gif DiscoverParameters
Discovers the parameters for a DbCommand.
(Inherited from Database.)
Ee761407.protmethod(en-us,PandP.10).gif DoExecuteNonQuery
Executes the query for command.
(Inherited from Database.)
Ee761407.pubmethod(en-us,PandP.10).gif Equals (Inherited from Object.)
Ee761407.pubmethod(en-us,PandP.10).gif ExecuteDataSet Overloaded.
Ee761407.pubmethod(en-us,PandP.10).gif ExecuteDataSetSql
Executes a SQL SELECT statement and returns a dataset.
Ee761407.pubmethod(en-us,PandP.10).gif ExecuteNonQuery Overloaded.
Ee761407.pubmethod(en-us,PandP.10).gif ExecuteNonQuerySql Overloaded.
Ee761407.pubmethod(en-us,PandP.10).gif ExecuteReader Overloaded.
Ee761407.pubmethod(en-us,PandP.10).gif ExecuteReaderSql
Execute a command and return a DbDataReader that contains the rows returned.
Ee761407.pubmethod(en-us,PandP.10).gif ExecuteResultSet Overloaded.
Ee761407.pubmethod(en-us,PandP.10).gif ExecuteScalar Overloaded.
Ee761407.pubmethod(en-us,PandP.10).gif ExecuteScalarSql
Executes the command and returns the first column of the first row in the result set returned by the query. Extra columns or rows are ignored.
Ee761407.protmethod(en-us,PandP.10).gif Finalize (Inherited from Object.)
Ee761407.pubmethod(en-us,PandP.10).gif GetDataAdapter Overloaded.
Ee761407.pubmethod(en-us,PandP.10).gif GetHashCode (Inherited from Object.)
Ee761407.pubmethod(en-us,PandP.10).gif GetInstrumentationEventProvider
Returns the object to which the instrumentation events have been delegated.
(Inherited from Database.)
Ee761407.protmethod(en-us,PandP.10).gif GetOpenConnection Overloaded.
Ee761407.pubmethod(en-us,PandP.10).gif GetParameterValue
Gets a parameter value.
(Inherited from Database.)
Ee761407.pubmethod(en-us,PandP.10).gif GetSqlStringCommand

Creates a DbCommand for a SQL query.

(Inherited from Database.)
Ee761407.pubmethod(en-us,PandP.10).gif GetStoredProcCommand Overloaded.
Ee761407.pubmethod(en-us,PandP.10).gif GetStoredProcCommandWithSourceColumns
Wraps around a derived class's implementation of the GetStoredProcCommandWrapper method and adds functionality for using this method with UpdateDataSet. The GetStoredProcCommandWrapper method (above) that takes a params array expects the array to be filled with VALUES for the parameters. This method differs from the GetStoredProcCommandWrapper method in that it allows a user to pass in a string array. It will also dynamically discover the parameters for the stored procedure and set the parameter's SourceColumns to the strings that are passed in. It does this by mapping the parameters to the strings IN ORDER. Thus, order is very important.
(Inherited from Database.)
Ee761407.pubmethod(en-us,PandP.10).gif GetType (Inherited from Object.)
Ee761407.pubmethod(en-us,PandP.10).gif LoadDataSet Overloaded.
Ee761407.protmethod(en-us,PandP.10).gif MemberwiseClone (Inherited from Object.)
Ee761407.protmethod(en-us,PandP.10).gif OpenConnection Obsolete.

Opens a connection.

(Inherited from Database.)
Ee761407.protmethod(en-us,PandP.10).gif SameNumberOfParametersAndValues
Determines if the number of parameters in the command matches the array of parameter values.
(Inherited from Database.)
Ee761407.pubmethod(en-us,PandP.10).gif SetParameterValue
Sets a parameter value.
(Inherited from Database.)
Ee761407.protmethod(en-us,PandP.10).gif SetUpRowUpdatedEvent
Sets the RowUpdated event for the data adapter.
(Overrides DatabaseSetUpRowUpdatedEvent(DbDataAdapter).)
Ee761407.pubmethod(en-us,PandP.10).gif TableExists
Checks to see if a table exists in the open database.
Ee761407.pubmethod(en-us,PandP.10).gif ToString (Inherited from Object.)
Ee761407.pubmethod(en-us,PandP.10).gif UpdateDataSet Overloaded.
Ee761407.protmethod(en-us,PandP.10).gif UserParametersStartIndex
Returns the starting index for parameters in a command.
(Inherited from Database.)

Fields

  Name Description
Ee761407.protfield(en-us,PandP.10).gif instrumentationProvider
The DataInstrumentationProvider instance that defines the logical events used to instrument this Database instance.
(Inherited from Database.)

Properties

  Name Description
Ee761407.pubproperty(en-us,PandP.10).gif ConnectionString

Gets the string used to open a database.

(Inherited from Database.)
Ee761407.protproperty(en-us,PandP.10).gif ConnectionStringNoCredentials

Gets the connection string without the username and password.

(Inherited from Database.)
Ee761407.pubproperty(en-us,PandP.10).gif ConnectionStringWithoutCredentials
Gets the connection string without credentials.
(Inherited from Database.)
Ee761407.pubproperty(en-us,PandP.10).gif DbProviderFactory

Gets the DbProviderFactory used by the database instance.

(Inherited from Database.)
Ee761407.protproperty(en-us,PandP.10).gif ParameterToken

Gets the parameter token used to delimit parameters for the SQL Server database.

See Also

SqlCeDatabase Class

Microsoft.Practices.EnterpriseLibrary.Data.SqlCe Namespace