public MigrationGenerator(SqlType sqlType)
{
_sqlFormatProvider = SqlFormatFactory.Provider(sqlType);
_ddlFactory = new DdlGeneratorFactory(sqlType);
IncludeSchema = (sqlType != SqlType.SqlServerCe && sqlType != SqlType.SQLite);
EscapeNames = true;
}
public static string Write(DatabaseSchema schema, ISqlFormatProvider formatter)
{
var sb = new StringBuilder();
foreach (var table in schema.Tables)
{
foreach (var foreignKey in table.ForeignKeys)
{
sb.AppendLine("-- ALTER TABLE " + formatter.Escape(table.Name) + " DROP CONSTRAINT " + foreignKey.Name + ";");
}
}
foreach (var table in schema.Tables)
{
sb.AppendLine("-- DROP TABLE " + formatter.Escape(table.Name) + ";");
}
return(sb.ToString());
}
public static string Write(DatabaseSchema schema, ISqlFormatProvider formatter)
{
var sb = new StringBuilder();
var lineEnding = formatter.LineEnding();
//if this is a GO, comment it out too
if (lineEnding.IndexOf(Environment.NewLine, StringComparison.Ordinal) != -1)
{
lineEnding = lineEnding.Replace(Environment.NewLine, Environment.NewLine + "--");
}
foreach (var table in schema.Tables)
{
foreach (var foreignKey in table.ForeignKeys)
{
sb.AppendLine("-- ALTER TABLE " + formatter.Escape(table.Name) + " DROP CONSTRAINT " + foreignKey.Name + lineEnding);
}
}
foreach (var table in schema.Tables)
{
sb.AppendLine("-- DROP TABLE " + formatter.Escape(table.Name) + lineEnding);
}
return(sb.ToString());
}
public static string Write(DatabaseSchema schema, ISqlFormatProvider formatter)
{
var sb = new StringBuilder();
var lineEnding = formatter.LineEnding();
//if this is a GO, comment it out too
if (lineEnding.IndexOf(Environment.NewLine, StringComparison.Ordinal) != -1)
{
lineEnding = lineEnding.Replace(Environment.NewLine, Environment.NewLine + "--");
}
foreach (var table in schema.Tables)
{
foreach (var foreignKey in table.ForeignKeys)
{
sb.AppendLine("-- ALTER TABLE " + formatter.Escape(table.Name) + " DROP CONSTRAINT " + foreignKey.Name + lineEnding);
}
}
foreach (var table in schema.Tables)
{
sb.AppendLine("-- DROP TABLE " + formatter.Escape(table.Name) + lineEnding);
}
return sb.ToString();
}
public MigrationGenerator(SqlType sqlType)
{
_sqlFormatProvider = SqlFormatFactory.Provider(sqlType);
_ddlFactory = new DdlGeneratorFactory(sqlType);
IncludeSchema = (sqlType != SqlType.SqlServerCe && sqlType != SqlType.SQLite);
}
