EF programmaticlly insert many to many

Question

Hi I have table with this structure ID PK and two columns with FK for example ActivityID and ContactID. I try programmaticlly insert some value in this two FK columns. How can I do this, any help is appriciated.Tnx

Answer 1

I think the best solution would be to get rid of primary key, set up combination of ActivityID and ContactID as PK and then recreate whole model in visual designer. Every Activity object will have Contacts navigation property and every Contact will have Activities. You will be able to add contacts to activity by calling:

activity.Contacts.Add(contact);

If you really need additional ID, it will be more complicated.

Answer 2

If you want to use your structure - you have to get instances of Activity and of Contact and just set corresponding properties on new entity.

var newActivityContact = new ActivityContact();// m_Entities.CreateActivityContact(0);
newActivityContact.Activity = activityRepository.GetById(activityId);
newActivityContact.Contact = contactRepository.GetById(contactId);
m_Entities.AddToActivityContact(newActivityContact);
m_Entities.SaveChanges();