Null in Queriers

[Reyhanejaffari]

this query does not work
organizationalRoles = organizationalRoles.Where("(Parent!=null ? parent.Name:Title)");
how did you handle null values in code

[Reyhanejaffari]

i add
if (_keywords.TryGetValue(_token.Text, out value))
{
var type = value as Type;
if (type != null) return ParseTypeAccess(type);
if (value == NullLiteral)
{
Expression expr = value as Expression;
NextToken();
return expr;
}
if ((string)value == KeywordIt) return ParseIt();
if ((string)value == KeywordOuterIt) return ParseOuterIt();
if ((string)value == KeywordIif) return ParseIif();
if ((string)value == KeywordNew) return ParseNew();
NextToken();
return null;
}
in Expression ParseIdentifier() and it works.
is this code true?

[umutozel]

Sorry for the late reply, I missed the notification I believe.

You should use a comparison in your expression, it should work with that, I am adding a new unit test right now;

        Assert.Equal(
            _query.Where(o => (o.Id == 5 ? 1 : 0) != 0),
            _query.Where("(Id == 5 ? 1 : 0) != 0")
        );

and it's working.

I believe your code should be like this;

organizationalRoles.Where("(Parent!=null ? parent.Name:Title) != null");

[gbreen12]

I'm trying to do something similar and it doesn't seem to work:

query.OrderBy($"{ob.Field}==null")

Any ideas?

[gbreen12]

Looks like I just needed to change it to:

query.OrderBy($"x => !x.{ob.Field}.HasValue")

[umutozel]

@gbreen12 first one should work, I'll look into it.