GROUP BY WEEK EF Core 2.1

Question

GROUP BY WEEK EF Core 2.1

.net c# entity-framework entity-framework-core

Question

I need to group per week based on the registration date ?

Javier Flores

Popular Answer

using System.Globalization;

 .GroupBy( 
              g => CultureInfo.CurrentCulture.Calendar.GetWeekOfYear( g.Trsdt, 
              CalendarWeekRule.FirstDay,DayOfWeek.Monday )
           )

Javier Flores

View more on Stack Overflow

Ivan Stoev · Accepted Answer · 11/14/2018 8:25:14 PM

It's not quite clear what CalendarWeekRule do you have in mind, so assuming you want the simplest (FirstDay), i.e. the formula like

Week = 1 + (DateTime.DayOfYear - 1) / 7

EF Core supports translation of the DayOfWeek to SQL, so you could use something like this (not sure if you need Year):

.GroupBy(g => new { g.Trsdt.Year, Week = 1 + (g.Trsdt.DayOfYear - 1) / 7 })

GROUP BY WEEK EF Core 2.1

Question

Fastest Entity Framework Extensions

Accepted Answer

Popular Answer

Performance

Expression Evaluator

Related