Hi Leonardo,

What error are you getting? From reading your code, it looks like one issue might be that you are missing a closing bracket ) in both of your Where calls.

Thanks, Dan.

Hey Dan,

This is the error:

CS1593: Delegate 'System.Func

Hi Leonardo,

I'm really sorry as I don't want to sound patronising but are you sure its not related to the missing bracket? I just want to make sure you've added it as the two code samples you've given don't contain it. The error you've just given would suggest it might be related to it.

Thanks, Dan.

Hi Dan,

Relax. :)

I understand you.

But I have checked, there is not any brackets missing.

Anyway, please, check it out:

Ah my bad. That makes sense. You're not missing a bracket at all :)

Dan, it is ok!

Check:

I have found it:

https://our.umbraco.org/forum/developers/razor/45189-Error-when-running-lambda-query-in-Razor

And now its become be more weird:

If I try it:

if(!string.IsNullOrEmpty(Request.QueryString["search"])){    

search  =   Request.QueryString["search"];
var selection = Model.Content.Site().FirstChild("main").FirstChild("news").Children().Where(x => x.IsVisible()).OrderBy("Name");

}

Its work. I can not understand.

Hi Leonardo

The only thing that is worried me that .OrderBy(x => x.Name) should be strongly typed, like that:

    var selection = Model.Content.Site().FirstChild("main").FirstChild("news").Children()
            .Where(x => x.IsVisible() && x.GetPropertyValue<string>("newsName")
            .Substring(0, 1).ContainsAny(!string.IsNullOrEmpty(letter) ? letter : "#,1,2,3,4,5,6,7,8,9,0"))
            .OrderBy(x => x.Name);

The code is working for me, if it's not for you, then the issue is with data, so something wrong with data coming from Umbraco

/Alex

Hi there,

Thank you so much for your help and support.

I have discovered the error.

I have done it:

@{ 
   string searchterm = !string.IsNullOrEmpty(Request.Form["searchterm"]) ? Request.Form["searchterm"] : "";
   var error  = false;
   var number = 0;
}
@if(!string.IsNullOrEmpty(searchterm)){
         var selection = Model.Content.Site().FirstChild("main").FirstChild("news").Children()
            .Where(x => x.IsVisible() &&  (x.GetPropertyValue<string>("dealerName").Contains(searchterm.ToUpper())));
            number =  selection.Count();

        if(number > 0){
        continue my code...
        }
}

The problem was: When I was trying to get the selection value outside the conditional, its caused the error. I created everything inside the same IF and now everything works perfectly.

I guess if you create this var selection = Model.Content.Site()... inside the any conditional and try call it outside the conditional this action will create errors.

Hi,

This is because it's not in scope outside of where it's declared.

If you want to declare var selection in the top section to use in other conditionals you can do this (note untested, not at my own machine).

@{ 
   string searchterm = !string.IsNullOrEmpty(Request.Form["searchterm"]) ? Request.Form["searchterm"] : "";
   var error  = false;
   var number = 0;
   var selection = Enumerable.Empty<IPublishedContent>();
}
@if(!string.IsNullOrEmpty(searchterm)){
         selection = Model.Content.Site().FirstChild("main").FirstChild("news").Children()
            .Where(x => x.IsVisible() &&  (x.GetPropertyValue<string>("dealerName").Contains(searchterm.ToUpper())));
            number =  selection.Count();

        if(number > 0){
        continue my code...
        }
}

Hi Steve, You rock.

Thank you so much!

is working on a reply...