c# - 将 sql 查询转换为 Entity Framework

Question

以下 sql 查询正在运行并获取当月每天的访问量

select  date(date) as DayDate, count(*) As visitsaday from Visits group by DayDate having DayDate between date('now','start of month') and date('now','start of month','+1 month','-1 day')

几天来，我一直在努力弄清楚如何使用 Entity Framework 来运行它。到目前为止，我最好的方法是:

ObjectQuery<Visit> visits = fitent.VisitMenge;
                var uQuery =
                    from visit in visits
                    group visit by visit.Date into g
                    select new
                    {
                        DayOfMonth = g.Key,
                        VisitsPerDay = g.Count()
                    };

这里的问题是，它将按日期 + 时间分组，而不仅仅是日期。结果如下:

[0] = { DayOfMonth = {06.07.2009 12:38:59}, VisitsPerDay = 1 } 

但它应该是这样的

[0] = { DayOfMonth = {06.07.2009}, VisitsPerDay = 12 }

• 日期格式如何改变用于分组 ?
• 如何过滤SQL 查询中的当前月份？

Answer 1

你能做到吗:

ObjectQuery<Visit> visits = fitent.VisitMenge;
var uQuery = from visit in visits
             group visit by visit.Date.Day into g
             select new
             {
                 DayOfMonth = g.Key,
                 VisitsPerDay = g.Count()
             };

只需将 .Day 添加到您的“visit.Date”中 - 这行得通吗？

马克