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