SqlCeCommandBuilder Members

  • Article

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

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

Public Constructors

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

Top

Public Properties

(see also Protected Properties )

  Name Description
Public property Supported by the .NET Compact Framework CatalogLocation Overridden. Not supported in SQL Server Mobile.
Public property Supported by the .NET Compact Framework CatalogSeparator Overridden. Not supported in SQL Server Mobile.
Public property Supported by the .NET Compact Framework ConflictOption Overridden.  
Public property Supported by the .NET Compact Framework DataAdapter Gets or sets a SqlCeDataAdapter object for which SQL statements are automatically generated.
Public property Supported by the .NET Compact Framework 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.
Public property Supported by the .NET Compact Framework 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.
Public property Supported by the .NET Compact Framework SchemaSeparator Overridden. Not supported in SQL Server Mobile.
Public property Supported by the .NET Compact Framework SetAllValues  Specifies whether all column values in an update statement are included or only changed ones.(Inherited from DbCommandBuilder.)
Public property Supported by the .NET Compact Framework Site  Gets or sets the ISite of the Component.(Inherited from Component.)

Top

Protected Properties

  Name Description
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 Dispose  Overloaded. Releases the resources used by the DbCommandBuilder. (Inherited from DbCommandBuilder.)
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 GetDeleteCommand Overloaded. Gets the automatically generated SqlCeCommand object required to perform deletions on the database.
Public method Supported by the .NET Compact Framework GetHashCode  Serves as a hash function for a particular type. GetHashCode is suitable for use in hashing algorithms and data structures like a hash table. (Inherited from Object.)
Public method Supported by the .NET Compact Framework GetInsertCommand Overloaded. Gets the automatically generated SqlCeCommand object required to perform insertions on the database
Public method Supported by the .NET Compact Framework GetType  Gets the Type of the current instance. (Inherited from Object.)
Public method Supported by the .NET Compact Framework GetUpdateCommand Overloaded. Gets the automatically generated SqlCeCommand object required to perform updates on the database.
Public method Supported by the .NET Compact Framework 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.)
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 RefreshSchema  Clears the commands associated with this DbCommandBuilder. (Inherited from DbCommandBuilder.)
Public method Supported by the .NET Compact Framework ToString  Returns a String that represents the current Object. (Inherited from Object.)
Public method Supported by the .NET Compact Framework 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
Protected method Supported by the .NET Compact Framework ApplyParameterInfo  Allows the provider implementation of the DbCommandBuilder class to handle additional parameter properties. (Inherited from DbCommandBuilder.)
Protected method Supported by the .NET Compact Framework Dispose  Overloaded. Releases the resources used by the DbCommandBuilder. (Inherited from DbCommandBuilder.)
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 Supported by the .NET Compact Framework GetParameterName  Overloaded. Returns the name of the specified parameter. (Inherited from DbCommandBuilder.)
Protected method Supported by the .NET Compact Framework GetParameterPlaceholder  Returns the placeholder for the parameter in the associated SQL statement. (Inherited from DbCommandBuilder.)
Protected method Supported by the .NET Compact Framework GetSchemaTable  Returns the schema table for the DbCommandBuilder. (Inherited from DbCommandBuilder.)
Protected method Supported by the .NET Compact Framework InitializeCommand  Resets the CommandTimeout, Transaction, CommandType, and UpdateRowSource properties on the DbCommand. (Inherited from DbCommandBuilder.)
Protected method Supported by the .NET Compact Framework MemberwiseClone  Creates a shallow copy of the current Object. (Inherited from Object.)
Protected method Supported by the .NET Compact Framework RowUpdatingHandler  Adds an event handler for the RowUpdating event. (Inherited from DbCommandBuilder.)
Protected method Supported by the .NET Compact Framework SetRowUpdatingHandler  Registers the DbCommandBuilder to handle the RowUpdating event for a DbDataAdapter. (Inherited from DbCommandBuilder.)

Top

Public Events

  Name Description
Public event Supported by the .NET Compact Framework Disposed  Adds an event handler to listen to the Disposed event on the component.(Inherited from Component.)

Top

See Also

Reference

SqlCeCommandBuilder Class
System.Data.SqlServerCe Namespace