Access Synonym And View Tables

Question

How to access synonyms and view tables in visual studio through .edmx...........using asp.net

Vincent Maverick Durano · Answer

You can add Views in Entity Framework (EDMX) just like adding database tables. For synonyms I don't think there's a direct way. What I would do is create a view that selects data from your synonym and then add the view to your model. Giving the view in your model the name of the synonym. Also see if this helps: http://stackoverflow.com/questions/6036357/making-an-entity-framework-model-span-multiple-databases