ADO.NET Entity Framework - LINQ to multiple dbms

Question

Is it possible to create an 'Entity' that will be an abstraction of a relationship between tables that live in two different tables, in two different databases, on two different machines, and even possibly using two different dbms?

For example, if I have a SQL Server db on one machine that stores all my customers, and I have an Oracle db on a different machine that stores all my orders, is it possible to wrap this in an entity and then use the entity in a LINQ expression as if they were together?

Thanks!

Program.X · Accepted Answer · 2009-03-26 12:58:20Z

1

Wow, that would be the ultimate n-Tier solution!

Not as far as I know. Unless you create a view and bind EF to the view, but then it would be read-only (obviously)?

answered Mar 26, 2009 at 12:58

Program.X

7,41212 gold badges53 silver badges86 bronze badges

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

Comments

Sharique · Accepted Answer · 2009-03-27 06:51:37Z

0

You can use multiple dbml files with different namespace for each file (like Myproject.Data.Customer,Myproject.Data.Orders etc..).

I think is this manner you can use multiple databases residing on different machines. using different namespaces for different dbs provide very good isolation, it will helps you to keep each db layer separate and you can have separate person/team working on each layer independently.

You can put all these in single layers/namespace, but that will be make things more complicated and difficult to maintain.

edited Mar 27, 2009 at 6:51

answered Mar 26, 2009 at 12:58

Sharique

4,2296 gold badges38 silver badges54 bronze badges

Collectives™ on Stack Overflow

ADO.NET Entity Framework - LINQ to multiple dbms

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related