Is there a way for a database novice to use tables from two different databases using the Visual Studio entity developer addin? I need to do some joins using database Foo.Documents and database Bar.Locations. I have created separate models for Foo and Bar but not together.
Database Foo is managed and updated by a source that I do not want to touch.
Database Bar holds supplemental data that I have created and have control over.
Using two separate databases on same SQL server
Re: Using two separate databases on same SQL server
There is no way to add tables from different databases in the same model. Please use two separate models.
Re: Using two separate databases on same SQL server
I discovered one way at the end of the day yesterday. I just finished testing it this morning. Create a view on the server. The view can be a query that uses any databases that the user has access to. When you update (and save) the Entity Designer model you can then add the view as what looks like a table.
Re: Using two separate databases on same SQL server
Views allow you to SELECT data but you may encounter issues to UPDATE data in the corresponding tables.