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
}
}
