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 void CallingConstraintExistsReturnsFalseIfConstraintDoesNotExist() { using (var table = new SqlServerCeTestTable(Processor, "id int")) { table.WithUniqueConstraintOn("id"); Processor.ConstraintExists(null, table.Name, "DoesNotExist").ShouldBeFalse(); } }
public override void CallingIndexExistsReturnsFalseIfIndexDoesNotExistWithSchema() { using (var table = new SqlServerCeTestTable(Processor, "id int")) { table.WithIndexOn("id"); Processor.IndexExists("NOTUSED", table.Name, "DoesNotExist").ShouldBeFalse(); } }
public override void CallingIndexExistsCanAcceptIndexNameWithSingleQuote() { using (var table = new SqlServerCeTestTable(Processor, "id int")) { table.WithIndexOn("id", "UI'id"); Processor.IndexExists("NOTUSED", table.Name, "UI'id").ShouldBeTrue(); } }
public override void CallingColumnExistsReturnsTrueIfColumnExistsWithSchema() { using (var table = new SqlServerCeTestTable(Processor, Quoter.QuoteColumnName("id") + " int")) Processor.ColumnExists("NOTUSED", table.Name, "id").ShouldBeTrue(); }
public override void CallingColumnExistsReturnsFalseIfColumnDoesNotExistWithSchema() { using (var table = new SqlServerCeTestTable(Processor, "id int")) Processor.ColumnExists("NOTUSED", table.Name, "DoesNotExist").ShouldBeFalse(); }
public override void CallingColumnExistsCanAcceptTableNameWithSingleQuote() { using (var table = new SqlServerCeTestTable("Test'Table", Processor, Quoter.QuoteColumnName("id") + " int")) Processor.ColumnExists("NOTUSED", table.Name, "id").ShouldBeTrue(); }
public override void CallingTableExistsReturnsTrueIfTableExistsWithSchema() { using (var table = new SqlServerCeTestTable(Processor, "id int")) Processor.TableExists("NOTUSED", table.Name).ShouldBeTrue(); }
public override void CallingTableExistsCanAcceptTableNameWithSingleQuote() { using (var table = new SqlServerCeTestTable("Test'Table", Processor, "id int")) Processor.TableExists("NOTUSED", table.Name).ShouldBeTrue(); }
public void CallingColumnExistsReturnsTrueIfColumnExists() { using (var table = new SqlServerCeTestTable(Processor, "\"id\" int")) Processor.ColumnExists(null, table.Name, "id").ShouldBeTrue(); }
public void CallingColumnExistsReturnsFalseIfColumnDoesNotExist() { using (var table = new SqlServerCeTestTable(Processor, "id int")) Processor.ColumnExists(null, table.Name, "DoesNotExist").ShouldBeFalse(); }
public void CallingTableExistsReturnsTrueIfTableExists() { using (var table = new SqlServerCeTestTable(Processor, "id int")) Processor.TableExists(null, table.Name).ShouldBeTrue(); }
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 void CallingConstraintExistsReturnsTrueIfConstraintExistWithSchema() { using (var table = new SqlServerCeTestTable(Processor, "id int")) { table.WithUniqueConstraintOn("id"); Processor.ConstraintExists("NOTUSED", table.Name, "UC_id").ShouldBeTrue(); } }
public override void CallingIndexExistsReturnsTrueIfIndexExists() { using (var table = new SqlServerCeTestTable(Processor, "id int")) { table.WithIndexOn("id"); Processor.IndexExists(null, table.Name, "UI_id").ShouldBeTrue(); } }