SqlCeCommand Members

Represents an SQL statement to execute against a data source.

The SqlCeCommand type exposes the following members.

Constructors

	Name	Description
	SqlCeCommand() () () ()	Initializes a new instance of the SqlCeCommand class.
	SqlCeCommand(String)	Initializes a new instance of the SqlCeCommand class with the text of the query.
	SqlCeCommand(String, SqlCeConnection)	Initializes a new instance of the SqlCeCommand class with the text of the query and a SqlCeConnection.
	SqlCeCommand(String, SqlCeConnection, SqlCeTransaction)	Initializes a new instance of the SqlCeCommand class with the text of the query, a SqlCeConnection, and the SqlCeTransaction.

Top

Methods

	Name	Description
	Cancel() () () ()	Attempts to cancel the execution of a SqlCeCommand. (Overrides DbCommand. . :: . .Cancel() () () ().)
	CreateDbParameter() () () ()	(inherited from DbCommand)
	CreateObjRef(Type)	(inherited from MarshalByRefObject)
	CreateParameter() () () ()	Creates a new instance of a SqlCeParameter object.
	Dispose() () () ()	(inherited from Component)
	Dispose(Boolean)	(inherited from Component)
	Equals(Object)	(inherited from Object)
	ExecuteDbDataReader(CommandBehavior)	(inherited from DbCommand)
	ExecuteNonQuery() () () ()	Executes an SQL statement against the SqlCeConnection and returns the number of rows affected. (Overrides DbCommand. . :: . .ExecuteNonQuery() () () ().)
	ExecuteReader() () () ()	Sends the CommandText to the Connection and builds a SqlCeDataReader.
	ExecuteReader(CommandBehavior)	Sends the CommandText to the Connection and builds a SqlCeDataReader by using one of the CommandBehavior values.
	ExecuteResultSet(ResultSetOptions)	Sends the CommandText to the Connection and builds a SqlCeResultSet by using the ResultSetOptions.
	ExecuteResultSet(ResultSetOptions, SqlCeResultSet)	Sends the CommandText to the Connection and builds a SqlCeResultSet by using the ResultSetOptions.
	ExecuteScalar() () () ()	Executes the query and returns the first column of the first row in the result set that is returned by the query. Extra columns or rows are ignored. (Overrides DbCommand. . :: . .ExecuteScalar() () () ().)
	Finalize() () () ()	(inherited from Component)
	GetHashCode() () () ()	(inherited from Object)
	GetLifetimeService() () () ()	(inherited from MarshalByRefObject)
	GetService(Type)	(inherited from Component)
	GetType() () () ()	(inherited from Object)
	InitializeLifetimeService() () () ()	(inherited from MarshalByRefObject)
	MemberwiseClone() () () ()	(inherited from Object)
	MemberwiseClone(Boolean)	(inherited from MarshalByRefObject)
	Prepare() () () ()	Creates a prepared (or compiled) version of the command on the data source. (Overrides DbCommand. . :: . .Prepare() () () ().)
	SetRange(DbRangeOptions, array<Object> [] () [] [], array<Object> [] () [] [])	Restricts the set of rows that will be read by the SqlCeDataReader.
	ToString() () () ()	(inherited from Component)

Top

Properties

	Name	Description
	CanRaiseEvents	(inherited from Component)
	CommandText	Gets or sets an SQL statement to execute at the data source. (Overrides DbCommand. . :: . .CommandText.)
	CommandTimeout	Gets or sets the wait time before terminating the attempt to execute a command and generating an error. (Overrides DbCommand. . :: . .CommandTimeout.)
	CommandType	Gets or sets a value indicating how the CommandText property is interpreted. (Overrides DbCommand. . :: . .CommandType.)
	Connection	Gets or sets the SqlCeConnection used by this instance of the SqlCeCommand.
	Container	(inherited from Component)
	DbConnection	(inherited from DbCommand)
	DbParameterCollection	(inherited from DbCommand)
	DbTransaction	(inherited from DbCommand)
	DesignMode	(inherited from Component)
	DesignTimeVisible	Get always returns false; set always throws a NotSupportedException. (Overrides DbCommand. . :: . .DesignTimeVisible.)
	Events	(inherited from Component)
	IndexName	Specifies the index to be opened.
	Parameters	Gets the SqlCeParameterCollection.
	Site	(inherited from Component)
	Transaction	Gets or sets the transaction in which the SqlCeCommand executes.
	UpdatedRowSource	Gets or sets how command results are applied to the DataRow when used by the Update method of the DbDataAdapter. This property should not be used with the .NET Compact Framework Data Provider for . (Overrides DbCommand. . :: . .UpdatedRowSource.)

Top

Events

	Name	Description
	Disposed	(inherited from Component)

Top

Explicit Interface Implementations

	Name	Description
	ICloneable. . :: . .Clone() () () ()
	IDbCommand. . :: . .Connection	(inherited from DbCommand)
	IDbCommand. . :: . .CreateParameter() () () ()	(inherited from DbCommand)
	IDbCommand. . :: . .ExecuteReader() () () ()	(inherited from DbCommand)
	IDbCommand. . :: . .ExecuteReader(CommandBehavior)	(inherited from DbCommand)
	IDbCommand. . :: . .Parameters	(inherited from DbCommand)
	IDbCommand. . :: . .Transaction	(inherited from DbCommand)

Top

See Also

Reference

SqlCeCommand Class

System.Data.SqlServerCe Namespace