Building strange query in linq to db, how to fix?

Question

C++ / C#

Linq to DB

return await dbSet.FirstOrDefaultAsync(u => u.Email.ToUpper() == email.ToUpper());

Turns into

FROM [dbo].[Users] AS [Extent1]
    WHERE ((UPPER([Extent1].[Email])) = (UPPER(@p__linq__0))) OR ((UPPER([Extent1].[Email]) IS NULL) AND (UPPER(@p__linq__0) IS NULL))

How to remove or?

Answer 1

By default, there should be no case sensitivity, and if this was not done intentionally, then there is no need to do ToUpper() .

return await dbSet.FirstOrDefaultAsync(u => u.Email == email);