Linq query to select distinct rows from a table without case sensitive

Question

1.00/5 (1 vote)

See more:

I am using the following dynamic Linq query to select distinct rows:

C#

var distinctValue = (from row in orgdt.AsEnumerable()
                                     select new { NAME = row.Field<string>("NAME")}).Distinct().ToList(); </string>

NAME is column of the table - in that there may be two rows like Emp and emp.
In list 2 names are displayed, but my requirement is that only one should be displayed. How can this be done?

Posted 16-Jul-10 0:18am

sowjanyam

Updated 17-Mar-20 21:48pm

Deeksha Shenoy

v3

Add a Solution

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

Ian Shlasko · Answer 1 · 2010-08-24T05:25:00

Solution 3

Distinct() can take an IEqualityComparer as an argument. Provide one that does a case-insensitive string comparison.

Posted 24-Aug-10 5:25am

Ian Shlasko

Not Active · Answer 2 · 2010-07-16T02:23:00

Solution 1

Use a where clause. As in,

from row in orgdt.AsEnumerable()
where row.Field("NAME") == "Emp"

Posted 16-Jul-10 2:23am

Not Active

Magnus_ · Answer 3 · 2010-08-24T05:17:00

Solution 2

You have to change to collation of that column (or the complete database) to "case insensitive" or perform the distinct operation in code.

Posted 24-Aug-10 5:17am

Magnus_

binurajv · Answer 4 · 2020-03-17T21:48:00

Solution 4

Try this:

var distNames = Data.Select(s => s.Name.ToLower()).Distinct().ToList()

Posted 17-Mar-20 21:48pm

binurajv

Comments

Richard Deeming 18-Mar-20 15:32pm

A terrible idea. You're creating a new copy of every string in the list, which will be inefficient. And you're normalizing to lower-case, which means you could get hit by the "Turkish i" problem.

The Turkish İ Problem and Why You Should Care | You’ve Been Haacked[^]
CA1308: Normalize strings to uppercase - Visual Studio | Microsoft Docs[^]

Solution 3 is the correct solution: pass a case-insensitive equality comparer to the Distinct method.