public override void CallingConstraintExistsCanAcceptTableNameWithSingleQuote()
{
using (var table = new SqlServerCeTestTable("Test'Table", Processor, "id int"))
{
table.WithUniqueConstraintOn("id");
Processor.ConstraintExists("NOTUSED", table.Name, "UC_id").ShouldBeTrue();
}
}
public override void CallingConstraintExistsReturnsFalseIfConstraintDoesNotExistWithSchema()
{
using (var table = new SqlServerCeTestTable(Processor, "id int"))
{
table.WithUniqueConstraintOn("id");
Processor.ConstraintExists("NotUsed", table.Name, "DoesNotExist").ShouldBeFalse();
}
}
public override void CallingConstraintExistsReturnsTrueIfConstraintExistsWithSchema()
{
using (var table = new SqlServerCeTestTable(Processor, "id int"))
{
table.WithUniqueConstraintOn("id");
Processor.ConstraintExists("NOTUSED", table.Name, "UC_id").ShouldBeTrue();
}
}
public override void CallingConstraintExistsReturnsTrueIfConstraintExists()
{
using (var table = new SqlServerCeTestTable(Processor, QuoterOptions, "id int"))
{
table.WithUniqueConstraintOn("id");
Processor.ConstraintExists(null, table.Name, "UC_id").ShouldBeTrue();
}
}