Chandradev's Blog

Data binding directly to a store query (DbSet, DbQuery, DbSqlQuery) is not supported.

Hi

I was doing some test with code first approach in EF. Then while populating the Gridview i was getting error like this


Data binding directly to a store query (DbSet, DbQuery, DbSqlQuery) is not supported. Instead populate a DbSet with data, for example by calling Load on the DbSet, and then bind to local data. For WPF bind to DbSet.Local. For WinForms bind to DbSet.Local.ToBindingList().

For solving this error we have to write the code like this

 private void FillGrid()
        {
            using (var Context = new EmpDatabaseContext())
            {
                var query = Context.Emps.Select(m => m);
                //var query = from m in Context.Emps
                //            select m;
               // Gridview1.DataSource = query;
                Gridview1.DataSource = query.ToList();
                Gridview1.DataBind();
            }
        }
  We canot bind Iqueryable directly. We have to change into ToList()

• Share This Post:
• 
• 
• 
•   Short Url: http://wblo.gs/cpR

Print posted @ Monday, April 9, 2012 6:21 AM