Entity Framework with multiple data sources
Is it possible to have an EDM that retrieves data from two data sources at the same time ? Say, it retrieves 3 tables from a开发者_如何学编程n SQL Server database and some other data from a binary file ?
short answer: no
You could link database servers within your edmx main database and write views or stored procedures that access the data from the linked server tables.
No, you'd need one EDMX per data source then use a repository to merge the results in memory.
精彩评论