How to write a ling query for group by

Question

0.00/5 (No votes)

See more:

Hi Friends,

I have a linq query which is used to group by, where the count is >1.

Linq query is like this:

SQL

var Serialnumberentered = from a in serialNumbercheck
                                        group a by new { a } into g
                                        where g.Count() > 1
                                        select new
                                        {
                                            g.Key
                                        };

when i entered empty values in "serialNumbercheck", the above query is taking the count of empty values also.can any one help me how can i ignore the empty values.

Posted 17-May-12 4:37am

inayat basha

Add a Solution

Comments

VJ Reddy 17-May-12 12:15pm

Thank you for accepting the solution :)

inayat basha 28-May-12 6:32am

Hi VJ,
from the query u have provided how can i check the duplicate for upper case and lower case. example i have "test" and "TEST" as the data it was not taking as duplicate. can you plz suggest me

1 solution

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)

VJ Reddy · Accepted Answer · 2012-05-17T05:38:00

Solution 1

Introduce a where clause to remove the empty strings as follows

C#

var Serialnumberentered = from a in serialNumbercheck
//For .NET 2.0 and 3.5      where a == null ? false : a.Trim() != string.Empty  
//or                        where (a ?? "").Trim()!= string.Empty
                            where !string.IsNullOrWhiteSpace(a)
                            group a by new { a } into g
                            where g.Count() > 1
                            select new
                            {
                                g.Key
                            };

Posted 17-May-12 5:38am

VJ Reddy

Updated 17-May-12 5:56am

v4

Comments

Pete O'Hanlon 17-May-12 11:59am

Gets my 5.

VJ Reddy 17-May-12 12:14pm

Thank you very much.

Maciej Los 17-May-12 12:51pm

Good answer, my 5!

VJ Reddy 17-May-12 13:00pm

Thank you, losmac :)

member60 17-May-12 23:51pm

my 5!

VJ Reddy 18-May-12 0:21am

Thank you, member60 :)

inayat basha 18-May-12 5:21am

Hi VJ, if i want to check any other condition after the where condition what should i have 2 written.. Means i have to check some text values also . can you plz help me