CODEWITHSUNDEEP
entity-frameworkdatabase-first
NS.X.
NS.X.

Reputation: 2142

EF4 db-first: how to add missing relationships

I am using db-first to creating object model for a readonly database, but some relationships are not automatically picked up. For example in Foo.BarId is not automatically connected to Bar object. If I click on BarId property, I don't see anything to associate it to a Bar in the context menu or properties window. How can I manually claim foreign keys without messing up anything?

Upvotes: 1

Views: 2308

Answers (2)

NS.X.
NS.X.

Reputation: 2142

Figured out myself... here are the steps:

(On model designer)

  1. Delete BarId property from Foo entity.
  2. Right click Foo entity (not any of its properties), add association between Foo and Bar.
  3. Click the association arrow.
  4. In Mapping Details window, add "Foo" table.
  5. Map Foo.Id to Foo.Id, map Bar.Id to Foo.BarId.

Done.

Upvotes: 2

Bishnu Paudel
Bishnu Paudel

Reputation: 2079

Make sure that both tables have primary keys and Bar table has foreign key defined.

Upvotes: 0

Related Questions