Handling foreign keys in multiple contexts/domains using Entity Framework Code First and Migrations

Question

I'm building a new system that utilizes data from an existing legacy system. A requirement is for our application to use the same physical database but a different schema for isolation. Our application will need read access only from the dbo schema, but our new structure will have foreign keys from the dbo schema so we'll need to enforce that.

I'm planning on creating two different projects with two different contexts. This will facilitate using Reverse Engineer Code First from EF Power Tools on the dbo schema, and using EF Migrations on our new schema. However, I'm unsure how this approach will handle Foreign Keys across contexts/domains. How would I map these so Migrations interprets it correctly?

Did you ever find a solution for this problem?

JasonlPrice
– JasonlPrice

2015-01-15 15:32:30 +00:00
Commented Jan 15, 2015 at 15:32 — JasonlPrice
– JasonlPrice, Commented Jan 15, 2015 at 15:32
No, the joining across contexts was always manual.

Mike Cole
– Mike Cole

2015-01-15 15:37:17 +00:00
Commented Jan 15, 2015 at 15:37 — Mike Cole
– Mike Cole, Commented Jan 15, 2015 at 15:37

Phil3992 · Accepted Answer · 2018-04-23 09:54:47Z

1

If you use different schemas and\or different contexts, that means this data can be stored anywhere, even at different storages (files, azure, services). You should not use explicit foregin keys across across contexts/domains. You have to make separate queries to each contexts.
If you really need to do that, you can use databse VIEWS with any joins you need (even from other server). Then just map our EF entity to view:

[Table("MyView")]

public class MyEntity {...}

Obviously, it will read-only entity.

edited Apr 23, 2018 at 9:54

Phil3992

1,0557 gold badges21 silver badges46 bronze badges

answered May 6, 2016 at 8:06

Timur Lemeshko

2,8795 gold badges29 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Handling foreign keys in multiple contexts/domains using Entity Framework Code First and Migrations

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related