tags:

views:

26

answers:

0
Q: 

Entity Framework 4 and 0:1, 0:1 relationships

I'm using the Model First approach with EF 4 and hit a snag with two tables, Participant (singular because pre-existing from another app) and ActiveParticipants.

A Participant may or may not be associated with exactly one ActiveParticipant and vice versa.

When I create an association, everything seems to go well on the surface, but then I get a runtime error complaining that Participant does not contain the column ActiveParticipant_Id. It does contain a column ActiveParticipantId (no underscore).

When I view the diagram as XML, there's a line like this:

<Property Name="ActiveParticipant_Id" Type="uniqueidentifier" Nullable="true" />

Why is it adding an underscore? Is there anything special I need to do for 0:1, 0:1 relationships?

related questions

Best method of profiling Entity Framework 4 dynamic queries?
Unique Keys not recognized by Entity Framework
caching problem in entity framework 4
Inserting an entity related to another using POCOs with EF
one-to-one relationships in Entity Framework 4 v2 with POCO
'Generic' ViewModel
named connection not found (Entity framework problem)
Using ADO.net Entity Framework 4 with Enumerations? How do I do it ?
Entity Framework 4.0: Why Would One Use the Code Generated EntityObjects Over POCO Objects?
Retrieve only base class from Entity Framework
EF4 POCO - Updating a navigation property
Using an Interface with a navigation property
EF4 POCO one to many Navigation property is null
Silverlight 4.0 + MVC 2.0 + WCF RIA Services + EF 4.0 = Load Error
How can I add constraints to an ADO.NET Entity?
Entity Splitting with Code Only
Using sql date data type and EF4
Table per hierarchy inheritance with POCO entities in Entity Framework 4
Is there any way to install EF4 on VS2008 SP1?
RIA services, EF and stored procs
Mocking Entity Context in EF4
Entity Framework 4 Multiple Object Delete(RemoveAll)
Exclude a field/property from the database with Entity Framework 4 & Code Only
.NET 4.0 CTP and EF CTP - is it good enough for production code?
Selecting particlar fields with EF4.0