dotConnect for SQLite Documentation
In This Topic
    DML Options
    In This Topic

    To increase a configurability of dotConnect for SQLite as Entity Framework provider and provide more flexibility in behavior, we have added a number of DML options that influence the INSERT/UPDATE/DELETE commands and stored procedure calls.

    Currently this feature is not yet supported for Entity Framework Core. It is supported only for Entity Framework v1 - v6.

    Except for the batch updates settings, which are described in the Batch Updates topic, the list of DML options includes:

    These options can be set either in code as the properties of the EntityProviderConfig.DmlOptions object or in the project config file as the attributes of the DmlOptions element of the Devart.Data.SQLite.Entity tag.

    The example code that enables the ReuseParameters option:

    SQLiteEntityProviderConfig config = SQLiteEntityProviderConfig.Instance;  
    config.DmlOptions.ReuseParameters = true;  
    
    
    Dim Config As SQLiteEntityProviderConfig
    Config = SQLiteEntityProviderConfig.Instance
    Config.DmlOptions.ReuseParameters = True