Sqlite upsert
More.ĬreateIndex (string indexName, string tableName, string columnName, bool unique=false)Ĭreates an index for the specified table and column. More.ĬreateTables ( CreateFlags createFlags= CreateFlags.None, params Type types)ĬreateIndex (string indexName, string tableName, string columnNames, bool unique=false)Ĭreates an index for the specified table and columns. You can later access this schema by calling GetMapping. It uses a schema automatically generated from the specified type. It also creates any specified indexes on the columns of the table.
More.ĬreateTable (Type ty, CreateFlags createFlags= CreateFlags.None)ĬreateTables ( CreateFlags createFlags= CreateFlags.None)Įxecutes a "create table if not exists" on the database for each type.
More.ĬreateTable ( CreateFlags createFlags= CreateFlags.None)Įxecutes a "create table if not exists" on the database. More.Įxecutes a "drop table" on the database. Retrieves the mapping that is automatically generated for the given type. GetMapping ( CreateFlags createFlags= CreateFlags.None) GetMapping (Type type, CreateFlags createFlags= CreateFlags.None, object obj=null, SQLiteConnection conn=null) Reset all the values of the columns rows Added for the foreignKey / multiple records editing More. More.Įnable or disable extension loading. You only need to call this function once in the lifetime of the database. WAL is significantly faster in most scenarios by providing better concurrency and better disk IO performance than the normal jounral mode.
SQLiteConnection ( SQLiteConnectionString connectionString)Įnables the write ahead logging. SQLiteConnection (string databasePath, SQLiteOpenFlags openFlags, bool storeDateTimeAsTicks=true) SQLiteConnection (string databasePath, bool storeDateTimeAsTicks=true)Ĭonstructs a new SQLiteConnection and opens a SQLite database specified by databasePath. Column information on the connection to determine the migration option(s) More.ĭata structure for the Many to Many Reference Table this class is used to make columns with different types.