How To : Entity framework and multiple schemas

Question

I am working with Entity framework. I am using a single database with multiple schemas as, mySchema1.Employee
mySchema2.Employee
mySchema3.Employee

When I generate edmx for this database, it renames the tables as Employee1, Employee2, Employee3 etc.

How to achieve multiple schemas implementation with single edmx.

Edit: The objects should be called by same name here as Employee. Only the variable part is schema. ctx.Employee - should fetch data from a specific schema. I am looking for something where I can specify which to be used.

Please help.

Answer 1

I'm not sure whether I understand the question... Do you want to have multiple diagrams per model ?

This feature is added in Entity Framework 5 which was recently released. Make sure you're using the latest version.