There is no implicit reference conversion from 'ApplicationDbContext' to 'System.Data.Linq.DataContext'

Question

I am working on Compiled Queries to improve the performance of the LINQ queries. I defined a separate class & written a function :-

 public static Func<ApplicationDbContext, IQueryable<EmployeeDetail>>
           CompliedQueryForEmployee = 
CompiledQuery.Compile((ApplicationDbContext context) => from c in 
context.tblEmployee select c);

If I use DataContext above then while using the above function it gives error as Invalid arguments.

This is how I access the tables :-

 using (var ctx = new ApplicationDbContext(schemaName))
{
....
ctx.tblEmployee.ToList();
}

Exactly how to write & use compiled Queries?

Answer 1

Compiled Queries, as you are using them, come from LINQ to SQL (DataContext) and Entity Framework pre-Code First (ObjectContect). Entity Framework Code First (DbContext and ApplicationDbContext) do not use them, or, rather, LINQ queries are always compiled and cached the first time they are used. See https://msdn.microsoft.com/en-gb/data/hh949853.aspx.