private void CreateTables() { var queryable = new SQLiteQueryableConnection(this.connectionstring); queryable.Connect(); var tables = queryable.ListTableNames(); if (!tables.Contains("connection")) { var ddl = "CREATE TABLE `connection` (" + " `id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT," + " `type` INTEGER NOT NULL DEFAULT 1," + " `name` TEXT NOT NULL," + " `host` TEXT NOT NULL," + " `port` INTEGER NOT NULL," + " `username` TEXT NOT NULL," + " `password` TEXT NOT NULL," + " `databasename` TEXT NOT NULL," + " `extraparams` TEXT NOT NULL" + "); "; ExecuteDDL(ddl); } if (!tables.Contains("query")) { var ddl = "CREATE TABLE `query` (" + " `id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT," + " `connection_id` INTEGER NOT NULL," + " `name` TEXT NOT NULL," + " `sqltext` TEXT NOT NULL" + " ); "; ExecuteDDL(ddl); } }