I want to collaborate with DBs A, B, and C. Everybody uses the same tables (for example: users, products).
I want to leave it up to the user to select the database he wishes to use (at runtime). Therefore, I generated the ADBEntities, BDBEntities, and CDBEntities classes using EF5 and three edbx files.
How can I allow him to select the database so that I can access its users?
var dstuff = from user in selecteddb.users where user.UserEmail == userEmail select user.UserID;
Reflection and base classes (DBEntities) have crossed my mind, but I never really pursued those concepts.