hi,

i have a many to many relationship between 2 entities in my datamodel.

so i have a simple link entity with just the keys of the other entities....

[Beer] beerid , beername

[Person] personid, personname

[LinkEntity] personid, beerid

using the entity framework it handles this well by hiding the link entity and implementing the relationship but in LINQ 2 SQL it doesn't hide the link entity and when you click on the link entity from the "details" page of either Beer or Person it displays all of the link entity records without filtering on beerid or personid.

Do I need to abandon LINQ 2 SQL as it doesn't work and just use the Entity framework?

Entity Framework is the way forward as far as m:m is concerned  see this post Update on LINQ to SQL and LINQ to Entities Roadmap on the ADO.Net blog it says they are going to make some improvements but give no details although Scott Guthrie at the Guathon in Manchester  says there are some new feature in L2S I've yet to hear anyone talk about them