In summary, what is the best development technique for updating many-to-many entity relationships where you are inserting two of three entities in the same functional transaction and using Silverlight 4 w/ WCF RIA & SQL Server 2008?
The entities are "category", "link" and "category-link-xref". A category can have many links and a link can be associated with many categories. In the GUI when creating a "link" record I am trying to decide the best method of inserting the "category-link-xref"
record along with it. Should I let WCF RIA do the Insert of "link" and add logic to the DS class to add the category-link-xref row?
Does WCF RIA have anything built in for this type situation, or am I better off just adding code to the domain services class for inserting the associative table, or maybe a stored procedure would be better?
Any guidance, tips, or sample code greatly appreciated!
View Complete Post