public void InsertInitialData()
{
using (SqlConnection connection = new SqlConnection(sqlConnectionString))
{
connection.Open();
var tableInserts = SQLStatements.InsertTablesStatements();
exec.ExecuteNonQuery(connection, tableInserts);
}
}
public void InitializeMinionsDB()
{
using (SqlConnection connection = new SqlConnection(sqlConnectionStringMaster))
{
connection.Open();
var createMinionsDB = SQLStatements.CreateDBStatements();
exec.ExecuteNonQuery(connection, createMinionsDB);
}
using (SqlConnection connection = new SqlConnection(sqlConnectionString))
{
connection.Open();
var createTables = SQLStatements.CreateTablesStatements();
exec.ExecuteNonQuery(connection, createTables);
}
}