public void ReturnsSwitchTableCommand()
{
// Arrange
var connection = new SqlConnection();
var viewName = "myViewName";
var tableName = "myTableName";
var columns = new[]
{
"key_part_1",
"key_part_2",
"nullable_text",
"nullable_number",
"nullable_datetimeoffset",
"nullable_money",
"nullable_varbinary",
"nullable_image",
};
// Act
var command = SqlConnectionExtensions.GetSwitchTableCommand(connection, viewName, tableName, columns);
// Assert
Assert.Equal(@"ALTER VIEW [myViewName]
AS
SELECT [key_part_1], [key_part_2], [nullable_text], [nullable_number], [nullable_datetimeoffset], [nullable_money], [nullable_varbinary], [nullable_image]
FROM [myTableName];", command.CommandText, ignoreLineEndingDifferences: true);
}
