Duplicate in LINQ for upper/ lower

Question

0.00/5 (No votes)

See more:

Hi,

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

My Linq :

SQL

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

                                 };

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

Posted 28-May-12 0:06am

inayat basha

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Andreas Gieriet · Answer 1 · 2012-05-28T01:37:00

Solution 2

If I understand your question correctly, you aim for

C#

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
         };

Cheers
Andi

Posted 28-May-12 1:37am

Andreas Gieriet

Comments

inayat basha 28-May-12 7:50am

Thx u.. it works.. but i have a doubt i have a linq query like this:
var DuplicatesDisplayPopUp = from a in DuplicateSerial
join b in ExactDuplicate
on a.SerialNumber equals b.SerialNumber
select new
{
Line = a.Line,
SAPLine = a.SAPLine,
SortCode = a.SortCode,
Description = a.Description,
SerialNumber = a.SerialNumber,
SerialNumberID = a.SerialNumberID,
SortCodeID = a.SortCodeID

};

i have the duplicates in lower case(which u have written the query) but when my main query will have duplicates in upper case and lower case(TEST1,test1). the above DuplicatesDisplayPopUp query how can i check

Andreas Gieriet 28-May-12 8:57am

Try this:
static void Main()
{
List<X> dupNum = new List<X>()
{
new X() {SerialNumber="Test2"},
new X() {SerialNumber="test1"},
new X() {SerialNumber="Test1"},
new X() {SerialNumber="Test11"},
};
List<Y> dupSerial = new List<Y>()
{
new Y() { Line = 0, SerialNumber = "Test1" },
new Y() { Line = 1, SerialNumber = "Test2" },
new Y() { Line = 2, SerialNumber = "Test11" },
new Y() { Line = 3, SerialNumber = "test1" },
};

var exactDuplicate = from a in dupNum
where !string.IsNullOrWhiteSpace(a.SerialNumber)
group a by a.SerialNumber.ToLower() into g
where g.Count() > 1
select g.Key; // select the string

var dupPopup = from a in dupSerial
from b in exactDuplicate
where a.SerialNumber.ToLower() == b
select a; // select the matchin object

foreach (var item in exactDuplicate)
{
Console.WriteLine("{0}", item);
}
foreach (var item in dupPopup)
{
Console.WriteLine("{0} at {1}", item.SerialNumber, item.Line);
}
}

Please note how I simplified the exactDuplicate query.
BTW: Your naming of the items seem a bit confusing to me.

Cheers
Andi

Clifford Nelson · Answer 2 · 2012-06-01T10:47:00

Even easier using extension methods:

C#

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);

vangapally Naveen Kumar · Answer 3 · 2012-05-28T00:17:00

Solution 1

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

Posted 28-May-12 0:17am

vangapally Naveen Kumar