How to use group by in C# using LINQ?

Question

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

Mayank · Answer

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.

Manas Mohapatra · Answer

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..