Could not find an implementation of the query pattern for source type 'System.Data.Entity.DbSet'
you will need to add reference to System.Data.Linq
System.Data.Linq is LINQ-SQL specific (DataContext, etc)
using System;
using System.Collections.Generic;
using System.Data.Entity;
using System.Data.Linq;
using System.Linq;
public static class QueryClass
{
public static void Query()
{
using (var context = new MyDbEntities())
{
IQueryable<MyTable> qTable= from t in context.Tables
select t; // can you confirm if your context has Tables or MyTables?
Console.WriteLine("Table Names:");
foreach (var t in qTable)
{
Console.WriteLine(t.Name);//put the relevant property instead of Name
}
}
}
}
Just added a reference using System.Linq;
and worked fine as already mentioned above.