dotConnect for SQL Server Documentation
Devart.Data.SqlServer Namespace / SqlCommandBuilder Class
Properties Methods Events

In This Topic
    SqlCommandBuilder Class Members
    In This Topic

    The following tables list the members exposed by SqlCommandBuilder.

    Public Constructors
     NameDescription
    Public ConstructorOverloaded. Initializes a new instance of the SqlCommandBuilder class.  
    Top
    Public Properties
     NameDescription
    Public PropertySpecifies which System.Data.ConflictOption is to be used by the System.Data.Common.DbCommandBuilder. (Inherited from System.Data.Common.DbCommandBuilder)
    Public PropertyGets the System.ComponentModel.IContainer that contains the System.ComponentModel.Component. (Inherited from System.ComponentModel.Component)
    Public PropertyGets or sets a SqlDataAdapter object for which this SqlCommandBuilder object will generate SQL statements.  
    Public PropertyGets or sets string containing list of key field names separated by semicolon. They are used to generate update commands.  
    Public PropertyGets or sets whether the command builder quotes all the names of data source objects. (Inherited from Devart.Common.DbCommandBuilderBase)
    Public PropertyOverridden. Gets or sets list of fields whose values should be retrieved after a DML statement execution.  
    Public PropertyGets or sets a value that indicates whether and how the Devart.Common.DbCommandBuilderBase should retrieve field values adjusted by server after an update. (Inherited from Devart.Common.DbCommandBuilderBase)
    Public PropertySpecifies whether all column values in an update statement are included or only changed ones. (Inherited from System.Data.Common.DbCommandBuilder)
    Public PropertyGets or sets the System.ComponentModel.ISite of the System.ComponentModel.Component. (Inherited from System.ComponentModel.Component)
    Public PropertyOverridden. Gets or sets list of fields to modify.  
    Public Property

    Gets or sets table name to generate update statements for.

     
    Public PropertySpecifies whether the catalog identifier is included in data source object names. (Inherited from Devart.Common.DbCommandBuilderBase)
    Public PropertySpecifies whether the schema identifier is included in data source object names. (Inherited from Devart.Common.DbCommandBuilderBase)
    Top
    Public Methods
     NameDescription
    Public MethodCreates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object. (Inherited from System.MarshalByRefObject)
    Public Methodstatic (Shared in Visual Basic)Populates the specified SqlCommand object's SqlCommand.Parameters collection with parameter information for the SQL statement specified in the CommandText.  
    Public MethodReleases all resources used by the System.ComponentModel.Component. (Inherited from System.ComponentModel.Component)
    Public MethodOverloaded. Gets the automatically generated SQL statement required to perform deletions on the data source.  
    Public MethodOverloaded. Gets the automatically generated SQL statement required to perform inserts on the data source.  
    Public MethodRetrieves the current lifetime service object that controls the lifetime policy for this instance. (Inherited from System.MarshalByRefObject)
    Public MethodOverloaded. Gets the automatically generated SQL statement required to refresh values from the data source.  
    Public MethodOverloaded. Gets the automatically generated SQL statement required to perform updates on the data source.  
    Public MethodObtains a lifetime service object to control the lifetime policy for this instance. (Inherited from System.MarshalByRefObject)
    Public MethodOverridden. Returns the string passed as the parameter enclosed in quotes.  
    Public MethodRefreshes the data source schema information used to generate INSERT, UPDATE, or DELETE statements. (Inherited from Devart.Common.DbCommandBuilderBase)
    Public MethodReturns a System.String containing the name of the System.ComponentModel.Component, if any. This method should not be overridden. (Inherited from System.ComponentModel.Component)
    Public MethodOverridden. Removes quote strings from identifier.  
    Top
    Public Events
     NameDescription
    Public EventOccurs when the component is disposed by a call to the System.ComponentModel.Component.Dispose method. (Inherited from System.ComponentModel.Component)
    Top
    See Also