Use tables from two different databases - entity structure

Question

I have a model obtained from sql 2008 database, now I need, in the same model file, to create an entity representing a user database from another database. How can I do this in the same model and not create a database view.

Answer 1

You can create a VIEW in SSDL. That is, not a database view, but an Entity Framework view.

Take a look at the documentation for DefiningQuery . DefiningQueries have their own SQL body, like a database view, but you do not need a view in the database.

Entity readonly, ( SSDL) " ModificationFunction" ( MSL), Read-Write Entity.

, SSDL, , XML.

SSDL - , , , , , , procs.

, CommandText SSDL SSDL (, SQL).

, , .

, .

, ( , , ).

Alex ( Entity Framework)