dotConnect for Zoho Books Documentation
Devart.Common Namespace / DbCommandBuilder Class
Properties Methods Events

In This Topic
    DbCommandBuilder Class Members
    In This Topic

    The following tables list the members exposed by DbCommandBuilder.

    Public Properties
     NameDescription
    Public PropertyCatalogLocationSets or gets the System.Data.Common.CatalogLocation for an instance of the System.Data.Common.DbCommandBuilder class. (Inherited from System.Data.Common.DbCommandBuilder)
    Public PropertyCatalogSeparatorSets or gets a string used as the catalog separator for an instance of the System.Data.Common.DbCommandBuilder class. (Inherited from System.Data.Common.DbCommandBuilder)
    Public PropertyConflictOptionSpecifies which System.Data.ConflictOption is to be used by the System.Data.Common.DbCommandBuilder. (Inherited from System.Data.Common.DbCommandBuilder)
    Public PropertyContainerGets the System.ComponentModel.IContainer that contains the System.ComponentModel.Component. (Inherited from System.ComponentModel.Component)
    Public PropertyDataAdapterGets or sets a System.Data.Common.DbDataAdapter object for which Transact-SQL statements are automatically generated. (Inherited from System.Data.Common.DbCommandBuilder)
    Public PropertyKeyFieldsGets or sets string containing list of key field names separated by semicolon. They are used to generate update commands. (Inherited from Devart.Common.DbCommandBuilderBase)
    Public PropertyQuotedGets or sets whether the command builder quotes all the names of data source objects. (Inherited from Devart.Common.DbCommandBuilderBase)
    Public PropertyRefreshingFieldsGets or sets list of fields whose values should be retrieved after a DML statement execution. (Inherited from Devart.Common.DbCommandBuilderBase)
    Public PropertyRefreshModeGets or sets a value that indicates whether and how the DbCommandBuilderBase should retrieve field values adjusted by server after an update. (Inherited from Devart.Common.DbCommandBuilderBase)
    Public PropertySchemaSeparatorGets or sets the character to be used for the separator between the schema identifier and any other identifiers. (Inherited from System.Data.Common.DbCommandBuilder)
    Public PropertySetAllValuesSpecifies whether all column values in an update statement are included or only changed ones. (Inherited from System.Data.Common.DbCommandBuilder)
    Public PropertySiteGets or sets the System.ComponentModel.ISite of the System.ComponentModel.Component. (Inherited from System.ComponentModel.Component)
    Public PropertyUpdatingFieldsGets or sets the list of the fields, separated with ';' (semicolon), that should be updated with the update commands in the DbCommandBuilder. If the field is not included in the list, it will not be updated.  
    Public PropertyUpdatingTableGets or sets table name to generate update statements for. (Inherited from Devart.Common.DbCommandBuilderBase)
    Public PropertyUseCatalogSpecifies whether the catalog identifier is included in data source object names. (Inherited from Devart.Common.DbCommandBuilderBase)
    Public PropertyUseSchemaSpecifies whether the schema identifier is included in data source object names. (Inherited from Devart.Common.DbCommandBuilderBase)
    Top
    Public Methods
     NameDescription
    Public MethodCreateObjRefCreates 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 MethodDisposeReleases all resources used by the System.ComponentModel.Component. (Inherited from System.ComponentModel.Component)
    Public MethodGetDeleteCommandOverloaded. Gets the automatically generated SQL statement required to perform deletions.  
    Public MethodGetInsertCommandOverloaded. Gets the automatically generated SQL statement required to perform inserts.  
    Public MethodGetLifetimeServiceRetrieves the current lifetime service object that controls the lifetime policy for this instance. (Inherited from System.MarshalByRefObject)
    Public MethodGetRefreshCommandOverloaded. Gets the automatically generated SQL statement required to refresh values from the data source.  
    Public MethodGetUpdateCommandOverloaded. Gets the automatically generated SQL statement required to perform updates on the data source.  
    Public MethodInitializeLifetimeServiceObtains a lifetime service object to control the lifetime policy for this instance. (Inherited from System.MarshalByRefObject)
    Public MethodQuoteIdentifierOverridden. Returns the string passed as the parameter enclosed in quotes.  
    Public MethodRefreshSchemaRefreshes the data source schema information used to generate INSERT, UPDATE, or DELETE statements. (Inherited from Devart.Common.DbCommandBuilderBase)
    Public MethodToStringReturns 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 MethodUnquoteIdentifierGiven a quoted identifier, returns the correct unquoted form of that identifier, including properly un-escaping any embedded quotes in the identifier. (Inherited from System.Data.Common.DbCommandBuilder)
    Top
    Public Events
     NameDescription
    Public EventDisposedOccurs when the component is disposed by a call to the System.ComponentModel.Component.Dispose method. (Inherited from System.ComponentModel.Component)
    Top
    See Also

    Reference

    DbCommandBuilder Class
    Devart.Common Namespace

     

     

    © 2015 - 2024 Devart. All Rights Reserved.

    Send Feedback