Data Binding Error ch14 p491

mmakia · October 14th, 2014, 01:44 PM

Hello,

I keep getting this error even after going back and redoing it:

" Data binding directly to a store query (DbSet, DbQuery, DbSqlQuery, DbRawSqlQuery) 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().
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.NotSupportedException: Data binding directly to a store query (DbSet, DbQuery, DbSqlQuery, DbRawSqlQuery) 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().

Source Error:

Line 17: select review;
Line 18: GridView1.DataSource = authorizedReviews;
Line 19: GridView1.DataBind();
Line 20: }
Line 21: }

Source File: c:\TestBegASPNET\WebSite1\Reviews\All.aspx.cs Line: 19 "

any Ideas?

Imar · October 14th, 2014, 05:37 PM

Hi there,

Are you using Visual Studio with the ASP.NET 4.5 version of the book? If so, take a look at this thread: Chapter 14 PlanetWrox.edmx

If not, can you tell me which version of the book and Visual Studio you're using?

Imar

mmakia · October 14th, 2014, 07:16 PM

Thank you Imar for the reply, I am using Visual Studio Express 2013 for Web and the book version I am using is Beginning ASP.NET 4.5.1.

Mohammed

Imar · October 15th, 2014, 01:49 AM

Ah, in that case it looks like you missed the call to ToList on authorizedReviews:

GridView1.DataSource = authorizedReviews.ToList()

as shown on page 491 and the explanation at the end of that try it out.

Hope this helps,

Imar

mmakia · October 15th, 2014, 12:41 PM

Solved.... Thank you so much Imar