public void CanCreateMultiIncludeIndexWithDefaultSchema()
{
var expression = GeneratorTestHelper.GetCreateMultiIncludeIndexExpression();
var sql = generator.Generate(expression);
sql.ShouldBe("CREATE INDEX [TestIndex] ON [dbo].[TestTable1] ([TestColumn1] ASC) INCLUDE ([TestColumn2], [TestColumn3])");
}
public void CanCreateMultiColumnIncludeIndexWithCustomSchema()
{
var expression = GeneratorTestHelper.GetCreateMultiIncludeIndexExpression();
expression.Index.SchemaName = "TestSchema";
var result = Generator.Generate(expression);
result.ShouldBe("CREATE INDEX [TestIndex] ON [TestSchema].[TestTable1] ([TestColumn1] ASC) INCLUDE ([TestColumn2], [TestColumn3])");
}
