public void SetUp()
{
string constr = ConfigurationManager.AppSettings["SqlServer2005ConnectionString"];
if (constr == null)
{
throw new ArgumentNullException("SqlServer2005ConnectionString", "No config file");
}
Provider = new SqlServerTransformationProvider(new SqlServer2005Dialect(), constr);
Provider.BeginTransaction();
AddDefaultTable();
}
private static void ResetDb()
{
var transformationProvider = new SqlServerTransformationProvider(new SqlServerDialect(), connectionString);
var tables = transformationProvider.GetTables();
foreach (var table in tables)
{
transformationProvider.RemoveTable(table);
}
MigrationsHelper.Run(connectionString);
}
public ITransformationProvider CreateTransformationProvider(MigratorDbType type, string constr, bool cached = true)
{
ITransformationProvider result = null;
string key = constr;
if (cached == true && caches.ContainsKey(key))
{
result = caches[key];
if (result != null)
{
return(result);
}
}
switch (type)
{
case MigratorDbType.SqlServer:
result = new SqlServerTransformationProvider(new SqlServer2005Dialect(), constr);
break;
case MigratorDbType.SqlServerCe:
result = new SQLiteTransformationProvider(new SQLiteDialect(), constr);
break;
case MigratorDbType.MySQL:
result = new MySqlTransformationProvider(new MysqlDialect(), constr);
break;
case MigratorDbType.Sqlite:
result = new SQLiteTransformationProvider(new SQLiteDialect(), constr);
break;
case MigratorDbType.PostgreSQL:
result = new PostgreSQLTransformationProvider(new PostgreSQLDialect(), constr);
break;
case MigratorDbType.Oracle:
result = new OracleTransformationProvider(new OracleDialect(), constr);
break;
case MigratorDbType.OracleManaged:
result = new OracleManagedTransformationProvider(new OracleDialect(), constr);
break;
default:
throw new NotImplementedException(type.ToString());
}
if (cached == true)
{
caches[key] = result;
}
return(result);
}
