public void AddTwoColumnsToTable_GetCorrectUpScript()
        {
            // Arrange

            // Act
            var tableAlteration = new TableAlteration<MyData>("MyTable");
            tableAlteration.AddColumn(m => m.MyNewColumn, 100);
            tableAlteration.AddColumn(m => m.MyOtherNewColumn);
            var script = tableAlteration.GetUpScript().Single();

            // Assert
            Assert.Equal("ALTER TABLE MyTable ADD\r\nMyNewColumn nvarchar(100) NOT NULL,\r\nMyOtherNewColumn int NOT NULL\r\n", script);
        }
        public void AddOneColumnWithAllowNullToTable_GetCorrectUpScript()
        {
            // Arrange

            // Act
            var tableAlteration = new TableAlteration<MyData>("MyTable");
            tableAlteration.AddColumn(m => m.MyNewColumn, 100).Null();
            var script = tableAlteration.GetUpScript().Single();

            // Assert
            Assert.Equal("ALTER TABLE MyTable ADD\r\nMyNewColumn nvarchar(100)\r\n", script);
        }