public override void CallingIndexExistsCanAcceptTableNameWithSingleQuote()
{
using (var table = new SqlServerCeTestTable("Test'Table", Processor, "id int"))
{
table.WithIndexOn("id");
Processor.IndexExists("NOTUSED", table.Name, "UI_id").ShouldBeTrue();
}
}
public override void CallingIndexExistsReturnsFalseIfIndexDoesNotExistWithSchema()
{
using (var table = new SqlServerCeTestTable(Processor, "id int"))
{
table.WithIndexOn("id");
Processor.IndexExists("NOTUSED", table.Name, "DoesNotExist").ShouldBeFalse();
}
}
public void CallingIndexExistsReturnsTrueIfIndexExistWithSchema()
{
using (var table = new SqlServerCeTestTable(Processor, "id int"))
{
table.WithIndexOn("id");
Processor.IndexExists("NOTUSED", table.Name, "UI_id").ShouldBeTrue();
}
}
public void CallingIndexExistsReturnsFalseIfIndexDoesNotExist()
{
using (var table = new SqlServerCeTestTable(Processor, "id int"))
{
table.WithIndexOn("id");
Processor.IndexExists(null, table.Name, "DoesNotExist").ShouldBeFalse();
}
}
public override void CallingIndexExistsReturnsTrueIfIndexExists()
{
using (var table = new SqlServerCeTestTable(Processor, "id int"))
{
table.WithIndexOn("id");
Processor.IndexExists(null, table.Name, "UI_id").ShouldBeTrue();
}
}