How to write EF in linq to include comparison by lower case

Question

I have this query: select lower(Name) from User

How to make the same with linq to EF avoiding to user linq to object.

Answer 1

var query = context.Users.Select(u => u.Name.ToLower());

Entity Framework can translate String.ToLower into SQL. This query will be translated as:

SELECT 
LOWER([Extent1].[Name]) AS [C1]
FROM [dbo].[Users] AS [Extent1]