locked
Include RRS feed

  • Question

  • Hi ,

    we working with  3 different databases on the same instance. Is it possible to use the include function on a table thats located in another database?

    Thx for your quick response

    L

    Thursday, February 26, 2015 3:03 PM

Answers

  • You are talking about querying across multiple database contexts is a single Linq query. I don't think that is supported.
    • Marked as answer by Fred Bao Friday, March 6, 2015 7:25 AM
    Thursday, February 26, 2015 3:31 PM
  • You can use synonyms or views to link in objects in other databases.  You'll probably want to use code-first to existing database to manage a model that spans tables and synonyms.

    David


    David http://blogs.msdn.com/b/dbrowne/

    • Marked as answer by Fred Bao Friday, March 6, 2015 7:25 AM
    Thursday, February 26, 2015 4:37 PM

All replies

  • You are talking about querying across multiple database contexts is a single Linq query. I don't think that is supported.
    • Marked as answer by Fred Bao Friday, March 6, 2015 7:25 AM
    Thursday, February 26, 2015 3:31 PM
  • You can use synonyms or views to link in objects in other databases.  You'll probably want to use code-first to existing database to manage a model that spans tables and synonyms.

    David


    David http://blogs.msdn.com/b/dbrowne/

    • Marked as answer by Fred Bao Friday, March 6, 2015 7:25 AM
    Thursday, February 26, 2015 4:37 PM
  • Hi

    I have the same situation.Please what is the solution that you find.

    Thank you

    Thursday, May 9, 2019 10:35 AM