public void CreateCommandStoreTable()
{
using (var connection = new SqlConnection(ConnectionString))
{
_tableName = "command_" + _tableName;
string createTableSql = SqlCommandStoreBuilder.GetDDL(_tableName);
connection.Open();
using (var command = connection.CreateCommand())
{
command.CommandText = createTableSql;
command.ExecuteNonQuery();
}
}
}
public void CreateCommandStoreTable()
{
using (var connection = new SqlConnection(_sqlSettings.TestsBrighterConnectionString))
{
_tableName = $"[command_{_tableName}]";
var createTableSql = SqlCommandStoreBuilder.GetDDL(_tableName);
connection.Open();
using (var command = connection.CreateCommand())
{
command.CommandText = createTableSql;
command.ExecuteNonQuery();
}
}
}
private static void CreateTestDb()
{
var en = new SqlCeEngine(ConnectionString);
en.CreateDatabase();
var sql = SqlCommandStoreBuilder.GetDDL(TableName);
using (var cnn = new SqlCeConnection(ConnectionString))
using (var cmd = cnn.CreateCommand())
{
cmd.CommandText = sql;
cnn.Open();
cmd.ExecuteNonQuery();
}
}
