How do I add a value to an explicit through entity when creating the association?

Hi there,

Regarding a ManyToMany association using an explicit through entity - e.g. the ContributionTags example -

http://www.mindscapehq.com/documentation/lightspeed/Working-with-Models-in-the-Visual-Designer/ManytoMany-Associations

What's the correct syntax for specifying a value for 'CreatedBy' on the associative entity when creating it?

Thanks.

LightSpeed will assign these values automatically provided you have set the AuditInfoMode on your LightSpeedContext. Have a read through this page from the documentation: http://www.mindscapehq.com/documentation/lightspeed/Implementing-Storage-Policies-with-LightSpeed/User-Ids-for-Entity-Tracking-and-Soft-Deletion for details on how to set this up.

Jeremy

Sorry, my mistake - was just using that as an example.

I have an explicit through entity (RoleQuestions) with an int called Weight on it. I want to set the value of this property at the time I create the association that uses the through entity.

Roles --> RoleQuestions (includes Weight) <-- Questions

At the moment I'm using role.Questions.Add(question); to add the Question, but I'm not sure of how I get a reference to the RoleQuestion object to set the value for Weight.

A simple way to do this would be to create the RoleQuestions instance e.g.

var roleQuestion = new RoleQuestions() { Role = role, Question = question, Weight = weight };

This performs the wireup directly through property assignment so you dont actually need to do anything else with the object after that other than as needed by your application. Because this is associated with both role and question it will be picked up for persistance when you call UnitOfWork.SaveChanges().

If you want to go with the approach you are already using then you could get the reference to the specific RoleQuestions instance after the fact by looking for the instance in the RoleQuestions collection on either the role or the question - e.g.

question.RoleQuestions.Single(rq => rq.Role == role) 

and then assign the Weight on that.

Jeremy

That's awesome thanks Jeremy.