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