Search for all appearances of “Articles” in AdminModel.edmx.In GuestModel.Now you just need to Search & Replace “Articles” with “MyArticles” in GuestModel.edmx To add the “MyArticles” synonym to GuestModel you need to copy all the parts related to “Articles” from AdminModel to the corresponding place edmx file is composed of 3 parts: the storage model, the conceptual model and the mapping between them. Open AdminModel.edmx in the text editor by right-clicking on it and selecting “Open With…” -> XML (Text) Editor.Do the same with “guest” credentials and save it as GuestModel.edmx.Create a new ADO.NET Entity Data Model from the database using “admin” credentials and save it as AdminModel.edmx.The user “admin” has access to the real table “Articles”, but the user “guest” can only access the synonym “MyArticles” Assuming that all the objects are located in the “Blog” DB as an example. I’ll explain the workaround step by step. Alternatively you can add the entities for the synonyms by hand and create the mapping, or you can merge the EDMXs generated for the separate schemas. Anyway synonyms work fine at run time, once you get the entity model correctly generated One option to generate the entity model is to create a schema with the superset of all the tables only for the purposes of model For other external users here is the response. Hi David, As i understand you have opened a case with Microsoft Support and have an answer to this issue.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |