FirstOrDefault does not work

[Simson43]

FirstOrDefault and the same methods dont work this (very simplified) example returns always 0:

context.Departments
                .Where(x => x.Employees.Where(y => y.Date == DateTime.Now).Select(y=>y.IsActive).FirstOrDefault() == false)
                .ToLinqToDB()
                .Count();

Version 3.17.0 EFCore3

[sdanyliv]

Use the following workaround before fix:

context.Departments
    .Where(x => !x.Employees.Any(y => y.Date == DateTime.Now && y.IsActive))
    .ToLinqToDB()
    .Count();

[Simson43]

yes there are workarounds but would be nice to support such methods in the future versions thanks much!

[MaceWindu]

Cannot reproduce. Please reopen if you still observe this issue with additional details like used database type and generated SQL