public void T1_CreateSingleRelation(string customerId, string customerName, string groupId, string groupDesc)
{
var ctx = Default.DataContext();
var group = new DemographicGroup {
CustomerTypeID = groupId, CustomerDesc = groupDesc
};
Expect(group.IsValid);
var customer = new Customer {
CustomerID = customerId, CompanyName = customerName
};
Expect(customer.IsValid);
customer.CustomerDemographics.Add(group);
Expect(customer.CustomerDemographics.Contains(group));
Expect(group.Customers.Contains(customer));
Expect(group.IsValid);
Expect(customer.IsValid);
ctx.Add(customer);
ctx.SaveChanges();
Expect(group.ChangeTracker.State, Is.EqualTo(ObjectState.Unchanged));
Expect(customer.ChangeTracker.State, Is.EqualTo(ObjectState.Unchanged));
}
static ManyToManyRelationTests()
{
var male = new DemographicGroup {
CustomerTypeID = "DemoGroup5", CustomerDesc = "Male"
};
var female = new DemographicGroup {
CustomerTypeID = "DemoGroup6", CustomerDesc = "Female"
};
var smoker = new DemographicGroup {
CustomerTypeID = "DemoGroup7", CustomerDesc = "Smoker"
};
var noSmoker = new DemographicGroup {
CustomerTypeID = "DemoGroup8", CustomerDesc = "NoSmoker"
};
var undefined = new DemographicGroup {
CustomerTypeID = "DemoGroup9", CustomerDesc = "Undefined"
};
var customerDemographics = new DemographicGroup[] { male, female, smoker, noSmoker, undefined };
var customer5 = new Customer {
CustomerID = "CUST5", CompanyName = "Test Customer 5"
};
var customer6 = new Customer {
CustomerID = "CUST6", CompanyName = "Test Customer 6"
};
var customer7 = new Customer {
CustomerID = "CUST7", CompanyName = "Test Customer 7"
};
var customer8 = new Customer {
CustomerID = "CUST8", CompanyName = "Test Customer 8"
};
customer5.CustomerDemographics.Add(male);
customer5.CustomerDemographics.Add(smoker);
customer6.CustomerDemographics.Add(male);
customer6.CustomerDemographics.Add(noSmoker);
customer7.CustomerDemographics.Add(female);
TestCases = new object[]
{
new object[] {
new Customer[] { customer5 },
new DemographicGroup[0]
},
new object[] {
new Customer[] { customer6, customer7 },
customerDemographics
},
new object[] {
new Customer[] { customer7, customer8 },
customerDemographics
}
};
}
