Chapter 14 Page 483

tariq · September 12th, 2010, 12:59 PM

I am getting an error in the code behine of the first try it out in chapter 14.
I think its related to the chapter 13 but i am not able to figure it our or may it's only a mistake in chapter 14.
This is my cod behind file:

Code:

public partial class Reviews_All : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        using (PlanetWroxEntities myEntities = new PlanetWroxEntities())
        {
            var allReviews = from review in myEntities.Reviews
                             where review.Authorized == true
                             orderby review.CreateDateTime descending
                             select review;
            GridView1.DataSource = allReviews;
            GridView1.DataBind();
        }
    }
}

The error i get is this in red:

Code:

Line 14:         {
Line 15:             var allReviews = from review in myEntities.Reviews
Line 16:                              where review.Authorized == true
Line 17:                              orderby review.CreateDateTime descending
Line 18:                              select review;

Any kind of input is welcome to get me started:
Thanks in advance for your time.
Tariq

bertus · September 12th, 2010, 02:59 PM

what is the error message you get? Because I came across the same yesterday (maybe)...

tariq · September 12th, 2010, 07:04 PM

Thanks for looking into it:
This is the error i get:

Code:

Compilation Error 
Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately. 

Compiler Error Message: CS1593: Delegate 'System.Func<PlanetWroxModel.Review,int,bool>' does not take 1 arguments

Source Error:

 

Line 14:         {
Line 15:             var allReviews = from review in myEntities.Reviews
Line 16:                              where review.Authorized == true
Line 17:                              orderby review.CreateDateTime descending
Line 18:                              select review;
 

Source File: c:\BegASPNETCS\Site\Reviews\All.aspx.cs    Line: 16

bertus · September 13th, 2010, 02:04 AM

Hey Tariq,

I had a somewhat similar error, which showed up as an error in the same codeblock. In my case something got changed in my web.config (targetFramework). Only difference is that in my case the error was in the 'Using' statement.

I guess in your case too, that it isn't a syntax error, but what it is???

Greetz from Sneek

Imar · September 13th, 2010, 02:46 AM

Hi Tariq,

That code looks fine to me.

Are you sure you created the Entity Framework model correctly? Do you get IntelliSense on the myEntities variable? Do you see any other errors in the Error List of Visual Studio?

Imar

tariq · September 13th, 2010, 07:14 AM

thanks for the reply Imar i got it fixed by changing the spelling of:

Authorized
to
Athorized

without a 'u'.
not sure why is that?

Tariq

andreas5 · September 13th, 2010, 08:19 AM

You probably wrote it wrong when you made the attribute in the Reviews table

Imar · September 13th, 2010, 08:35 AM

Or you misspelled the column name when you created the database.

You can fix the database and update or recreate the model, or you can just fix the name in the model and leave the database as it is.

Imar

tariq · September 14th, 2010, 07:10 AM

Yes i spelled it Athorized that is why i was getting an error.
Thanks for that and hope to chat 2 u if another issure arises.

Tariq

Imar · September 14th, 2010, 08:47 AM

But does that also mean you're not using IntelliSense to the max by letting it complete the property name for you (misspelled or not)?

Imar