I need to know how (if possible) to establish a connection with a table from another database using the framework entity. I have one edmx for my xyz database and the other for my zyx I need to link them using EF. I know how to fix this with FK, this is not what I want, I want to be able to do it with a visual editor, and not manually add FK to my database.
Here is an example of what I want:
Table User - database: abc Table Message - database: xyz
I need to associate the user with the message and vice versa.
Can anyone help me?
Thank!
source
share