SqlCeCommandBuilder Members

Article
12/12/2007

Provides a means of automatically generating single-table commands used to reconcile changes made to a DataSet with the associated Microsoft SQL Server 2005 Compact Edition database. This class cannot be inherited.

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

Public Constructors

	Name	Description
	SqlCeCommandBuilder	Overloaded. Initializes a new instance of the SqlCeCommandBuilder class.

Top

Public Properties

(see also Protected Properties )

	Name	Description
	CatalogLocation	Overridden. Not supported in SQL Server Compact Edition.
	CatalogSeparator	Overridden. Not supported in SQL Server Compact Edition.
	ConflictOption	Overridden. Specifies which ConflictOption is to be used by the SqlCeCommandBuilder.
	Container	Gets the IContainer that contains the Component.(inherited from Component)
	DataAdapter	Gets or sets a SqlCeDataAdapter object for which SQL statements are automatically generated.
	QuotePrefix	Overridden. Gets or sets the beginning character or characters to use when specifying SQL Server database objects (for example, tables or columns) whose names contain characters such as spaces or reserved tokens.
	QuoteSuffix	Overridden. Gets or sets the ending character or characters to use when specifying SQL Server database objects (for example, tables or columns) whose names contain characters, such as spaces or reserved tokens.
	SchemaSeparator	Overridden. Not supported in SQL Server Compact Edition.
	SetAllValues	Specifies whether all column values in an update statement are included or only changed ones.(inherited from DbCommandBuilder)
	Site	Gets or sets the ISite of the Component.(inherited from Component)

Top

Protected Properties

	Name	Description
	CanRaiseEvents	Gets a value indicating whether the component can raise an event.(inherited from Component)
	DesignMode	Gets a value that indicates whether the Component is currently in design mode.(inherited from Component)
	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
	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)
	Dispose	Overloaded. (inherited from DbCommandBuilder)
	Equals	Overloaded. Determines whether two Object instances are equal. (inherited from Object)
	GetDeleteCommand	Overloaded.
	GetHashCode	Serves as a hash function for a particular type. (inherited from Object)
	GetInsertCommand	Overloaded.
	GetLifetimeService	Retrieves the current lifetime service object that controls the lifetime policy for this instance. (inherited from MarshalByRefObject)
	GetType	Gets the Type of the current instance. (inherited from Object)
	GetUpdateCommand	Overloaded.
	InitializeLifetimeService	Obtains a lifetime service object to control the lifetime policy for this instance. (inherited from MarshalByRefObject)
	QuoteIdentifier	Given an unquoted identifier in the correct catalog case, returns the correct quoted form of that identifier, including properly escaping any embedded quotes in the identifier. (inherited from DbCommandBuilder)
	ReferenceEquals	Determines whether the specified Object instances are the same instance. (inherited from Object)
	RefreshSchema	Clears the commands associated with this DbCommandBuilder. (inherited from DbCommandBuilder)
	ToString	Returns a String containing the name of the Component, if any. This method should not be overridden. (inherited from Component)
	UnquoteIdentifier	Given a quoted identifier, returns the correct unquoted form of that identifier, including properly un-escaping any embedded quotes in the identifier. (inherited from DbCommandBuilder)

Top

Protected Methods

	Name	Description
	ApplyParameterInfo	Allows the provider implementation of the DbCommandBuilder class to handle additional parameter properties. (inherited from DbCommandBuilder)
	Dispose	Overloaded. (inherited from DbCommandBuilder)
	Finalize	Releases unmanaged resources and performs other cleanup operations before the Component is reclaimed by garbage collection. (inherited from Component)
	GetParameterName	Overloaded. Returns the name of the specified parameter. (inherited from DbCommandBuilder)
	GetParameterPlaceholder	Returns the placeholder for the parameter in the associated SQL statement. (inherited from DbCommandBuilder)
	GetSchemaTable	Returns the schema table for the DbCommandBuilder. (inherited from DbCommandBuilder)
	GetService	Returns an object that represents a service provided by the Component or by its Container. (inherited from Component)
	InitializeCommand	Resets the CommandTimeout, Transaction, CommandType, and UpdateRowSource properties on the DbCommand. (inherited from DbCommandBuilder)
	MemberwiseClone	Overloaded. (inherited from MarshalByRefObject)
	RowUpdatingHandler	Adds an event handler for the RowUpdating event. (inherited from DbCommandBuilder)
	SetRowUpdatingHandler	Registers the DbCommandBuilder to handle the RowUpdating event for a DbDataAdapter. (inherited from DbCommandBuilder)

Top

Public Events

	Name	Description
	Disposed	Occurs when the component is disposed by a call to the Dispose method. (inherited from Component)

Top

Share via