Combine multiple edmx data? RRS feed

  • Question

  • I just separate one database into two because some tables just didn't belong in it. So I have one db that is applications specific and one that is management specific (users, logins, etc). I have an ID in the mdb (management db) that points to my adb (application db). But now I am faced with an issue. I have a created a Dynamic Data Entities Web Application and I want to be able to see my users in mdb and 'click through' to my adb information. I was able to earlier when all the data was in one data base but not now.

    Can I some how combine dbs at a conceptual layer?




    Thursday, July 21, 2011 12:18 PM


All replies

  • No, you can't.


    but you can create views that queries the mdb database and mapped it to appear in the model

    Olavo Oliveira Neto
    Se for útil marque como resposta e faça um Developer feliz :)
    Thursday, July 21, 2011 6:36 PM
  • Hi,

    I am writing to check the status of the issue on your side.  Would you mind letting us know the result of the suggestions?

    If you need further assistance, please feel free to let me know.   I will be more than happy to be of assistance.

    Have a nice day.

    Alan Chen[MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Tuesday, August 2, 2011 3:54 PM