The specified LINQ expression contains references to queries

Question

I'm getting error after this join. Normal linq query working fine. I'm using database first approach.

When I'm collecting data from more than one table its throwing exception. The specified LINQ expression contains references to queries that are associated with different contexts.

public partial class EfRepository<T> : IRepository<T> where T : class

{

private readonly WebEntities _context;

private IDbSet<T> _entities;

public EfRepository(WebEntities context)

{

this._context = context;

}

public virtual IQueryable<T> Table

{

get

{

return this.Entities;

}

}

protected virtual IDbSet<T> Entities

{

get

{

if (_entities == null)

_entities = _context.Set<T>();

return _entities;

}

}

}

Query on Service.cs

 

var query = from rc in _FAQRepository.Table

join r in _FAQCategoryRepository.Table on rc.FAQCategoryID equals r.FAQCategoryID

select rc;

return query.ToList();