Column getting lost in LINQ with Method Syntax after group by-CodePudding

I'm pretty new to LINQ and trying to figure it out. I have the following statement:

Context.dataset1
    .Join(
        Context.dataset2, 
        r => r.ID, o => o.ID, 
        (r, o) => new  { PartID = r.PartID, Quantity = r.Quantity1 - r.Quantity2, Date = o.Date })
    .GroupBy(
        column => new { column.Date }, 
        (key, group) => new {Date = key.Date, Quantity = group.Sum(g => g.Quantity) })
    .Where(x => x.Quantity > 0);

the return data set looks like this

| Date          | Quantity |
| ------------- | ---------|
| 2022-01-01    | 333      |
| 2022-01-02    | 444      |
| 2022-03-03    | 444      |

what i want it to look like is

| PartID |          Date | Quantity |
|--------| ------------- | ---------|
|1       | 2022-01-01    | 333      |
|1       | 2022-01-02    | 444      |
|2       | 2022-03-03    | 444      |

Basically it seems that when I do the groupby I lose access to the PartId column since i'm no specifying it inside the groupby. I'm not sure how to make it appear without grouping by it which I don't want to do. Any help would be great. Thanks.

CodePudding user response：

What if two different part ids exist for the same date? What part id would it show? If you really want the part id, then you need to include the part id in your group by. For example:

column => new { column.PartID, column.Date }

This will mean that if you have multiple part ids for the same date, you will have as many rows for that date as you have distinct part ids. Based on your comments, this seems like what you're after.