Problem with LINQ Filters in Telerik RadGrid

Question

Hi all.

I have a problem using Telerik RadGrid. When I apply a filter on a data column, I use the filter expression as a Linq expression. So (server side) I parse it with Dynamic Linq (from MIcrosoft LINQ examples) in NeedDataSource handler. The problem is that when I specify "Start With" as a filter, I receive the following as "Linq expression":

(iif(Name == null, "", Name).ToString().StartsWith("A"))

What is "iif"???? What corresponds to "iif"???? Usage is obvious: handling nulls....

The strange thing is that when I apply the filter on a grid that loads data from web services and not from server side callback, all works and this issue don't raise. Two ways, two parsing function, not only a common one.

Any idea? Thanks in advance

Answer 1

In Dynamic LINQ iif(x,y,z) is another syntax for the ternary if x ? y : z, the same name was used in VB for some time ("Immediate IF")

In this case, it looks like it a null-coalescing operator ??, but it seems that Dynamic LINQ doesn't support that

(Name ?? string.Empty).ToString().StartsWith("A")

Maybe try to substitute the iif with the ternary notation? Can you clarify what is the exact error that happens?