实体框架 4：SQL 到 Linq：如何选择非大写的字符串？

发布于 2024-10-11 11:04:20 字数 291 浏览 2 评论 0原文

此 SQL 选择所有非大写的名称：

select name
from   myTable
where  not (UPPER(name) = name collate Latin1_General_BIN )

您如何在 Linq（实体框架 4？）中做同样的思考？

编辑：

String.Compare 和 string = string 都解析为 UPPER 的 SQL (name) = name 不区分大小写。

原文

This SQL selects all names that are not uppercase:

select name
from   myTable
where  not (UPPER(name) = name collate Latin1_General_BIN )

How would you do the same think in Linq (Entity Framework 4?)

Edit:

Both String.Compare and string = string resolve to SQL of UPPER(name) = name which is case insensitive.

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

踏雪无痕 2024-10-18 11:04:20

它不是纯LINQ，但您可以使用ExecuteQuery，例如

 string sql = @"
     select id , name 
     from   myTable
     where  not (UPPER(name) = name collate Latin1_General_BIN )
  ";

var results = 
   (from r in dc.ExecuteQuery<myTable>(sql) 
    select  new { r.Name } 
   ).ToList();

注意，您需要在查询中包含id，即使您只想要名称。

It's not pure LINQ, but you could use ExecuteQuery, eg

 string sql = @"
     select id , name 
     from   myTable
     where  not (UPPER(name) = name collate Latin1_General_BIN )
  ";

var results = 
   (from r in dc.ExecuteQuery<myTable>(sql) 
    select  new { r.Name } 
   ).ToList();

Note, you need to include id in the query, even if you only want name.

回复收藏 0 原文

成熟的代价 2024-10-18 11:04:20

您可以使用 ToUpper() 方法将字符串转换为大写，例如

entities.Where(x => x.Name != x.Name.ToUpper()).Select(x => x.Name)

显然您应该考虑是否需要向 ToUpper() 方法提供特定的 CultureInfo 并是否要进行特定于区域性的比较而不是使用 != 运算符。

You can use the ToUpper() method to convert a string to upper case, e.g.

entities.Where(x => x.Name != x.Name.ToUpper()).Select(x => x.Name)

Obviously you should consider whether you need to supply a particular CultureInfo to the ToUpper() method and whether you want to do a culture specific comparison instead of using the != operator.

回复收藏 0 原文