I have two databases. MasterData and ProductData. I store users and employees in MasterData, and I store tasks in ProdcutData. The Task object has a User property. It shows which user created this task.
If I used only one database and one DataContext, I could define one or more relationships between two objects. But I have to use two databases and datacontexts.
Is any solution a definition of the relationship between two objects that are in different databases, datacontexts?
thanks in advance: l.
This is not a complete answer, but you might think of a different solution.
( - ) . , DataContext / .
sql-: http://msdn.microsoft.com/en-us/library/ms177544.aspx
, -, / , , L2S EF. - , , , linq , , , . "" , DataSet? . L2S/EF, .
, dbs, ref-?
- , EF .
http://data.uservoice.com/forums/72025-ado-net-entity-framework-ef-feature-suggestions/suggestions/1052345-support-for-multiple-databases?ref=title
Thanks again!