Say i have a database table called Registration with these properties:
public DateTime DateReference { get; set; }public int MinuteWorked { get; set; }public int Status { get; set; }
The table has over 200K+ records...
How can i group all the records based on the DateReference for instance:
- group all the records where the date day is equal
SO:
- it would be check all the records DateReference and then group the ones that are equal into lists?
So far i've been trying to do everything with GroupBy but still no clue on how to make this query simple and as efficent as possible? Please help me, i've been all day here at my desk trying to solve this...