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