如何将数据分组到工作日？ [英] How Can I Group Data Into Weekdays?

问题描述

如何将我的数据分组为星期几，例如

周六，周日，周一，周二，周三，周四，周五



使用linq到Entity Framework。

How can i group my data into days of week like
Saturday,Sunday,Monday,Tuesday,Wednesday,Thursday,Friday

using linq to Entity Framework.

推荐答案

你可以使用 SqlFunctions.DatePart： [ ^ ]

you can use SqlFunctions.DatePart:[^]

var results = data.GroupBy(i =>SqlFunctions.DatePart("weekday", i.DateFieldName));

检查此类似的问题和解答以获取更多信息 [ ^ ]

我没有使用Entity FrameWork，但是这是Linq中DayOfWeek分组的一个例子，我假设这可以很容易地与EF一起使用;为了让它变得更有趣我已经过滤以仅返回具有多个实例的非周末天组：

I have not used Entity FrameWork, but here's an example in Linq of grouping by DayOfWeek, and I assume this can be easily used with EF; to make it more fun I've filtered to return only groups of non-weekend days with more than one instance:

private List<datetime> days = new List<datetime>();

private void TestGroupByDayOfWeekNotWeekend(object sender, EventArgs e)
{
    for (int i = 1; i < 31; i++)
    {
        int mod = i%7 + 1;
        days.Add(new DateTime(2014,11,mod));
    }

    var dayOfWeekGroups = days
        .Where(dy =>
         dy.DayOfWeek != DayOfWeek.Saturday && dy.DayOfWeek != DayOfWeek.Sunday)
        .GroupBy(dt => dt.DayOfWeek)
        .Where(grp => grp.Count() > 1);

    foreach (var grp in dayOfWeekGroups)
    {
        Console.WriteLine(grp.First().DayOfWeek.ToString());

        foreach (var dt in grp)
        {
            Console.WriteLine('\t' + dt.ToShortDateString());
        }

        Console.WriteLine();
    }
}

这篇关于如何将数据分组到工作日？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！