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 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);
}
