I am working on an ASP.NET MVC 4 web application. I am using [Entity Framework](https://msdn.microsoft.com/en-us/data/ef.aspx) as the data access layer, using database first approach (`.edmx` file).

Currently I have a problem in join tables that are defined inside two different databases (i.e. I have two `.edmx` files).

For example if I want to join tables I am performing the following query:-

```
public ActionResult AutoComplete(string term)
{
   var tech = repository.AllFindTechnolog(term).Take(100);//Call to the first database
   var resources = repository.GetResources(tech.Select(a => a.IT360ID.Value).ToArray(), false);//call to the second database

   var query = from techItems in tech
         join resourcesItems in resources
         on techItems.IT360ID.Value equals resourcesItems.RESOURCEID // join based on db2ID
         orderby techItems.PartialTag
         select new //code goes here

   return Json(query, JsonRequestBehavior.AllowGet);
}

```

I will have two separate calls to the database, and a join inside the application server, which is not the best performance-oriented solution. Ideally the joins will happen completely inside the database engine.

I know that a stored procedure will allow me to join tables from different databases purely on the server, but I do not want to use SP because it will make my code less maintainable and less testable. 

So I am searching for a solution where I can do the join using entity framework and to result in a single database join?