From many to many relationships using SQL and Linq (entity framework / for entities)

Question

I have two tables:

- Attendees
- Events

Typically, I would create a mapping table ' EventAttendeeMap' to associate these tables with the ratio of many or many.

Is this the best way to do this? Should I store the list AttendeeIdin the xml column instead in the Events table instead?

I am using .NET 3.5 / 4 with Linq as DAL (although I think this does not apply to the design asked question, maybe).

Interested in learning what people's opinions are.

Thank. Dave

Answer 1

, , - Entity Framework , .

Answer 2

- .

, .