Loading

How to use group by in C# using LINQ?

How to use group by in C# using LINQ?

Thiyagarajan E

Thiyagarajan E

10y940Learn iOS Programming

Hi All,

I have a item list, it contains a category. i want to group by the list using category in LINQ.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mayank10y ago
```
public class PriceLog { public DateTime LogDateTime {get; set;} public int Price {get; set;} }
```
If you need to get list of PriceLog objects:
var query = from p in PriceLogList group p by p.LogDateTime.ToString("MMM yyyy") into g select new PriceLog { LogDateTime = DateTime.Parse(g.Key), GoldPrice = (int)g.Average(x => x.GoldPrice), SilverPrice = (int)g.Average(x => x.SilverPrice) }; If it resolve your issue then mark as answer.
0
Manas Mohapatra10y ago
Please follow below links:

http://www.c-sharpcorner.com/blogs/group-by-with-linq1

http://stackoverflow.com/questions/7325278/group-by-in-linq

https://msdn.microsoft.com/en-us/library/bb545971.aspx

If above links doesn't help then share list of category entity details..
0