I am trying to use the Model First approach implemented in the Entity Framework with VS2010 / .Net 4.0, and now I really don't know how to do this. I start with the following objects:
Contact Event
******* *****
Id (Int32, not null, pk) Id (Int32, not null, pk)
Name (Name, not null) Name (String, not null)
Address (Address, not null) Duration (Duration, not null)
Email (String)
Phone (String)
where Name, Addressand Durationare the complex types that I defined.
Now I want to add an RSVPEntity object that works like a many-to-many mapping from Contactsto Events, but also contains some additional information in a complex type I called Payment. The table will probably look something like this:
RSVP
****
ContactId (int, not null, pk)
EventId (int, not null, pk)
Payment_Date (datetime, not null)
Payment_Amount (double, not null)
Model Designer ContactId EventId, " " , , ( ).
?