Esempi in C# (CSharp) per SQLite sqlite3.Execute

Esempio n. 1

File: Extensions.cs Progetto: chingham/SQLite.NetStandard

        public static void CreateIndexIfNotExists(this sqlite3 db, string table, string column)
        {
            var exists = TableColumnExists(db, table, column);

            if (exists)
            {
                return;
            }

            var query = $"CREATE INDEX IF NOT EXISTS {table}_{column} ON {table}({column})";

            db.Execute(query);
        }