In the previous blog, we have seen about Entity Framework.
In this blog, we will see error resolution related to Data binding directly to a store query.
In Visual Studio 2015 I was using Entity Framework and wrote a code to bind data with GridView. I wrote the normal Linq and browse my web page. And surprised to see below line of error: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().
Below is the code which was throwing above error.
using (var ctx = new PracticeEntities())
{
var data = from d in ctx.Orders select d;
gvData.DataSource = data;
gvData.DataBind();
}
I changed above code to below and it works for me.
using (var ctx = new PracticeEntities())
{
var data = (from d in ctx.Orders select d).ToList();
gvData.DataSource = data;
gvData.DataBind();
}
Other Blogs on Entity framework-
Other Blogs on Entity framework-
- Introduction to Entity Framework
- Create login module using Entity framework
- Error- Data binding directly to a store query (DbSet, DbQuery, DbSqlQuery) is not supported
- How to Insert data to SQL using Entity framework
Keep following – SharePointCafe.Net – A technical blog on SharePoint, ASP.Net, Cloud Computing
