Select a field that is not in Group By clause in LINQ

Question

0.00/5 (No votes)

See more:

Hi everyone, could anybody help me about
"How to select a field that is not in Group By clause in LINQ"

C#

var ReportData = from a in context.Table1
                                  from b in context.Table2

                                  where a.personelID == b.ID
                                  && a.DateField.Value.Year == 2011
                                  group a by new { a.personelID, b.Name, b.Surname} into grouping
                                  select new
                                  {
                                       // grouping.Key.DateField,
                                      Name= grouping.Key.Name,
                                      Surname= grouping.Key.Surname,
                                      PagaBruto =  grouping.Sum(i => i.Bruto)),


                                  };

I can't select the field "DateField" that is in Table1, I don't want to have this field in Group By, because I will get a wrong result.
THANKS!

Posted 28-Dec-11 4:05am

Valdet Zabeli

Add a Solution

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

gazmendmehmeti · Answer 1 · 2011-12-28T08:35:00

gazmendmehmeti - 20 mins ago
You can do it in this way:

C#

var ReportData = from a in context.Table1
                                  from b in context.Table2 
                                  where a.personelID == b.ID
                                  && a.DateField.Value.Year == 2011
                                  group a by new { a.personelID, b.Name, b.Surname} into grouping
                                  select new
                                  {
                                       // grouping.Key.DateField,
                                      DateField = grouping.First().DateField,
                                      Name= grouping.Key.Name,
                                      Surname= grouping.Key.Surname,
                                      PagaBruto =  grouping.Sum(i => i.Bruto))
                                  };

THANKS!
G.M.

Wendelius · Answer 2 · 2011-12-28T04:09:00

Solution 1

If you don't want the DateField in the group by section, then it means that for each grouped row you can have multiple values for the DateField. For these values you must choose what aggregate to use, sum/min/max etc.

Posted 28-Dec-11 4:09am

Wendelius

Comments

Valdet Zabeli 28-Dec-11 10:41am

the only thing that i need is to change data in this query after first initialization. for example:
ReportData = ReportData.Where(a => a.DateField.Value.Month != 1);

Wendelius 28-Dec-11 13:25pm

Sorry, but now I didn't understand. Can you provide an example of the source data and the desired results.