Generated sql code of coalescing expression for boolean

Hi,

I have this code:

  public List<Model.UserAccount> GetActiveUsers()
  {
     return this.Query().Where(x => !(x.Inactive ?? false)).OrderBy(x => x.FullName).ToList();
  }

The generated sql code of lightspeed is:

SELECT
  UserAccount.Id AS [UserAccount.Id],
  UserAccount.Email AS [UserAccount.Email],
FROM
  UserAccount
WHERE
  NOT (UserAccount.Inactive = True)

The where clause is not what I want and the results is also not what I want.

To get a valid result, I must do:

  public List<Model.UserAccount> GetActiveUsers()
  {
     return this.Query().Where(x => (x.Inactive ?? false) == false).OrderBy(x => x.FullName).ToList();
  }

The generated sql is:

...
COALESCE(UserAccount.Inactive, 0) = 0
...

Could you please explain to me why I must do the second solution? Is it a bug in the first case?

Thank you very much.

This will be a translation issue. The first statement infers a predicate where as the second one actually defines one when it comes to how these are represented in the LINQ expression trees. I will have a look at this, it sounds like we will just need to add some additional detection and translation for this particular case.

Jeremy

This was indeed a translation issue and I have added in a fix for this which will be available in tonights nightly build for you. Let me know if you continue to have any issues.

Jeremy

Thank you very much Jeremy.