Entity Framework + Many-To-Many Inserts + WCF Class Library

Question

EF does not include the junction table in the model when representing many-to-many relationships. I understand the logic behind this as objects can do this relationship thus; ObjectA can have a collection of ObjectB and vice versa whereas databases cannot. My example is:

Entity called EBR and Entity called Warning (in the databas the junction table is EBRWarning).

I can't figure out how to insert a record into the juction table. In the client-side intellisense, neither object has a property of the other.

The junction table itself is available i.e. EBRWarning exists as an object but there is no 'Context.Add' method as thre is for other tables that I marked as Editable.

Answer 1

Context.EBRWarnings.Add option is Available use it..

Answer 2

RIA Services doesn't support Many-To-Many without using http://m2m4ria.codeplex.com. The alternative is to add the linking table to the model. The easiest way to do that is to add an additional  non-key field to the linking (aka junction) table before generating your model.

Answer 3

Thanks.

I'd come across lots of suggestions on how this works but not this.

Answer 4

Refer this article. It talks about how it insert record in junction table. Hope this is useful.

http://nileshhirapra.blogspot.in/2012/03/entity-framework-insert-operation-with.html