public void Migration_SQL_Generation_AddRemoveColumns()
{
Migration m = new MigrationTest003();
string sql = m.BuildSqlStatement(Migration.MigrationDirection.Up);
Assert.AreEqual("ALTER TABLE [dbo].[Products] ADD [ProductExpiration] datetime NULL;\r\nALTER TABLE [dbo].[Products] DROP COLUMN [ProductName];\r\n", sql);
}
public void MigrationAddRemoveColumns()
{
Migration m = new MigrationTest003();
m.Migrate("Northwind", Migration.MigrationDirection.Up);
DataService.ClearSchemaCache("Northwind");
TableSchema.Table table = DataService.GetSchema("Products", "Northwind");
Assert.IsNotNull(table.GetColumn("ProductExpiration"));
Assert.IsNull(table.GetColumn("ProductName"));
}
public void Migration_SQL_Generation_AddRemoveColumns()
{
Migration m = new MigrationTest003(); // Object reference not set to an instance of an object.
string sql = m.BuildSqlStatement(Migration.MigrationDirection.Up);
string expected =
"ALTER TABLE `main`.`Products` ADD `ProductExpiration` datetime NULL;\r\n" +
"ALTER TABLE `main`.`Products` DROP COLUMN `ProductName`;\r\n";
Assert.AreEqual(expected, sql);
}
public void Migration_SQL_Generation_AddRemoveColumns()
{
Migration m = new MigrationTest003();
string sql = m.BuildSqlStatement(Migration.MigrationDirection.Up);
Assert.AreEqual("ALTER TABLE [dbo].[Products] ADD [ProductExpiration] datetime NULL;\r\nALTER TABLE [dbo].[Products] DROP COLUMN [ProductName];\r\n", sql);
}
public void MigrationAddRemoveColumns()
{
Migration m = new MigrationTest003();
m.Migrate("Northwind", Migration.MigrationDirection.Up);
DataService.ClearSchemaCache("Northwind");
TableSchema.Table table = DataService.GetSchema("Products", "Northwind");
Assert.IsNotNull(table.GetColumn("ProductExpiration"));
Assert.IsNull(table.GetColumn("ProductName"));
}
