LINQ中的重复项用于上/下 [英] Duplicate in LINQ for upper/ lower

问题描述

如何使用linq检查小写和大写的重复项.

我的Linq:

Hi,

How can i check the duplicate for lower case and upper case using linq.

My Linq :

var ExactDuplicate = from a in DuplicateNumber
                                 where !string.IsNullOrWhiteSpace(a.SerialNumber)
                                 group a by new { a.SerialNumber} into g
                                 where g.Count() > 1
                                 select new
                                 {
                                     g.Key.SerialNumber

                                 };

当我检查两个数字时，即

大写字母:TEST1
小写:test1.

linq表达式不被视为与上述表达式重复

问候，
basha

when i am checking for two numbers i.e.

upper case: TEST1
Lower case: test1.

the linq expression is not considering as duplicate from the above one

Regards,
basha

推荐答案

如果我正确理解了您的问题，那么您的目标是

If I understand your question correctly, you aim for

var ExactDuplicate = from a in DuplicateNumber
         where !string.IsNullOrWhiteSpace(a.SerialNumber)
         group a by new { SerialNumber = a.SerialNumber.ToLower() } into g
         where g.Count() > 1
         select new
         {
             g.Key.SerialNumber
         };

干杯
Andi

Cheers
Andi

使用扩展方法更容易:

Even easier using extension methods:

public test(string a, string b)
{
    A = a;
    B = b;
}

var xy = new test[] {new test("aa", "this is one"), new test("Aa", "this is two"), new test("Ba", "this is three")};

var yz = xy.Where(i => !(string.IsNullOrEmpty(i.A))).GroupBy(j => j.A.ToUpper()).Where(k => k.Count() > 1);

查看此链接，您可能会有所了解
http://forums.asp.net/t/1346775.aspx [

see this link you may get some idea
http://forums.asp.net/t/1346775.aspx[^]

这篇关于LINQ中的重复项用于上/下的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！