如何在LINQ写EF包括由小写比较 [英] How to write EF in linq to include comparison by lower case

问题描述

我有这个疑问：选择较低（名称）从用户

如何使LINQ相同以EF避免用户的LINQ to对象。

解决方案

  VAR的查询= context.Users。选择（U => u.Name.ToLower（））; 
  

实体框架可以转化成String.ToLower SQL。该查询将被翻译为：

  SELECT 
 LOWER（[Extent1] [名]。）AS [C1] 
 FROM [DBO]。[用户] AS [Extent1] 
  

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

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

解决方案

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]

这篇关于如何在LINQ写EF包括由小写比较的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！