multiple database in a single edmx?

Question

Is it possible to use multiple database in a single edmx.

for eg, now i am using a database "abc"and a edmx to work with the database tables. now i want to add a new database "security" to this edmx? is it possible?

Answer 1

Don't beleive our idea it is wrong because each edmx generate the contextclass. However, consider WCF class library then you can use more than 10 database.

Answer 2

can u provide any example relating the post......

Answer 3

is it better to add another edmx for the second database?

Answer 4

An another edmx will use an another connection too and probably you'll need it.

Regards, Greg