How do I ignore case in linq groupby when grouping using an anonymouse object

Question

0.00/5 (No votes)

See more:

I have a query that I want to run where I GroupBy based on TeamID and ActivityName. The TeamID is an int and the ActivityName is a string. I want to perform a GroupBy query where the key in the GroupBy is (TeamID, ActivityName) with the case being ignored in the ActivityName. The code below returns 4 groups as the the activities are all different based on content or case, I want there to be 2 by ignoring the case. I have tried adding StringComparer.InvariantCultureIgnoreCase to the query but I get a compilation error stating "The type arguments for method 'System.Linq.Enumerable.GroupBy<tsource,tkey,tresult>(System.Collections.Generic.IEnumerable<tsource>, System.Func<tsource,tkey>, System.Func<tkey,system.collections.generic.ienumerable><tsource>,TResult>' cannot be inferred from the usage. Try specifying the type arguments explicitly." I have also tried using ToUpper() in the query but with no success.
I can't figure out how this should be done, any help would be appreciated.

What I have tried:

public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
            PerformQuery();
        }

        public void PerformQuery()
        {
            List<team> teams = new List<team>();
            teams.Add(new Team { TeamId = 1, ActivityName = "Football" });
            teams.Add(new Team { TeamId = 1, ActivityName = "football" });
            teams.Add(new Team { TeamId = 2, ActivityName = "Rugby" });
            teams.Add(new Team { TeamId = 2, ActivityName = "rugby" });

            var activities = teams
                .GroupBy(e => new { e.TeamId, e.ActivityName });
        }
    }

    public class Team 
    {
        public int TeamId { get; set; }
        public string ActivityName { get; set; }
    }

Posted 24-Apr-16 22:51pm

alywaly

Updated 24-Apr-16 23:16pm

Karthik_Mahalingam

v2

Add a Solution

2 solutions

Add a Solution

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

OriginalGriff · Accepted Answer · 2016-04-24T23:06:00

Solution 1

Try:
C#

var activities = teams.GroupBy(e => new { e.TeamId, e.ActivityName.ToLower() });

:doh: - I need more coffee...
Try this:

C#

public class Team
    {
    public int TeamId { get; set; }
    public string ActivityName { get; set; }
    public string ActivityNameLower { get { return ActivityName.ToLower(); } }
    }

And then:

C#

var activities = teams.GroupBy(e => new { e.TeamId, e.ActivityNameLower });

Posted 24-Apr-16 23:06pm

OriginalGriff

Updated 24-Apr-16 23:11pm

v2

Comments

alywaly 25-Apr-16 5:30am

Perfect, Thank you!

OriginalGriff 25-Apr-16 5:35am

You're welcome!

khaleelsyed 21-Jul-20 5:42am

will not throw exeception if value is null in the string

OriginalGriff 21-Jul-20 5:58am

Of course it won't: it won't look at the content unless you tell it to ...

Karthik_Mahalingam · Accepted Answer · 2016-04-24T23:16:00

Solution 2

check this

C#

var activities = teams.GroupBy(e => new { TeamId = e.TeamId, ActivityName = e.ActivityName.ToLower() }).ToList();
foreach (var item in activities)
{
    var key = item.Key;
    var items = item.ToList();

}

Posted 24-Apr-16 23:16pm

Karthik_Mahalingam

Comments

alywaly 25-Apr-16 5:30am

Perfrect, Thank you!

Karthik_Mahalingam 25-Apr-16 5:34am

welcome :)

How do I ignore case in linq groupby when grouping using an anonymouse object

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

How do I ignore case in linq groupby when grouping using an anonymouse object

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us