Hi,

SQL Server, LLBLGen v.5.7.x

var qf = new QueryFactory();

var q = qf.Create()
          .Select
              (
               qf.XXX
                 .Select(XXX.Id)
                 .Where(XXX.JobId == Guid.NewGuid())
                 .Any()
              );

var exists = this.AdapterToUse.FetchScalar<bool>(q);

noticed that this query works fine even though it doesn't match any records but when the target table has data and fails when there's no data with "The database returned a NULL value however the type specified ('System.Boolean') isn't a nullable type". Can't say how .Any() was envisioned to work, but the solution is to use a nullable, i.e. .FetchScalar<bool?>(q) Docs seem to suggest that too, though there ?? is applied to a non-nullable values. Probably this needs to be corrected

Thank you!

We'll look into it

The Any query is run in the projection, of a query on the same table. This is done to get from 0 and 1 to true/false values. If the table doesn't have any rows, the projection isn't run as there's no row to project in the first place so the end result is indeed NULL. if there's at least 1 row, the first row is selected, the any clause is the projection and it will return the value of the any clause (which is a nested case / else).

It indeed needs clarification in the docs.

(Edit) We've added clarification to the v5.6 and 5.7 docs