private void CreateDatabase() { SQLiteConnection.CreateFile(Settings.Default.DBLocation); using (conn = new SQLiteConnection(connectionString)) { conn.Open(); new SQLiteCommand(SQLFixedQueries.CreateTables(), conn).ExecuteNonQuery(); new SQLiteCommand(SQLFixedQueries.CreateViews(), conn).ExecuteNonQuery(); new SQLiteCommand(SQLFixedQueries.CreateDefaultData(), conn).ExecuteNonQuery(); new SQLiteCommand(SQLFixedQueries.InsertTestData(), conn).ExecuteNonQuery(); //TODO remove this when releasing } }