public void ShouldBuildCreateRelation() { IQuery query; ICommandBuilder builder; DbCommand command; query = new CreateRelation <int>(TestDB.JobTypeTable, PersonnTable.PersonnID, JobTypeTable.JobTypeID); builder = new SqlCommandBuilder(); command = builder.BuildCommand(query); Assert.AreEqual("ALTER TABLE [JobType] WITH CHECK ADD CONSTRAINT [FK_JobType_JobTypeID_Personn] FOREIGN KEY ([JobTypeID]) REFERENCES [Personn] ([PersonnID])", command.CommandText); Assert.AreEqual(0, command.Parameters.Count); }
public void ShouldCreateRelationUsingExplicitParameters() { ICreateRelation query; query = new CreateRelation <int>(TestDB.PersonnTable, PersonnTable.PersonnID, JobTypeTable.JobTypeID); Assert.ThrowsException <ArgumentNullException>(() => new CreateRelation <int>(null, PersonnTable.PersonnID, JobTypeTable.JobTypeID)); Assert.ThrowsException <ArgumentNullException>(() => new CreateRelation <int>(TestDB.PersonnTable, null, JobTypeTable.JobTypeID)); Assert.ThrowsException <ArgumentNullException>(() => new CreateRelation <int>(TestDB.PersonnTable, PersonnTable.PersonnID, null)); Assert.AreEqual(TestDB.PersonnTable, query.Table); Assert.AreEqual(PersonnTable.PersonnID, query.PrimaryColumn); Assert.AreEqual(JobTypeTable.JobTypeID, query.ForeignColumn); }