SELECT CONVERT(varchar(10),uDatetime,120), COUNT(*)
FROM Logs
WHERE uType='警告'
GROUP BY CONVERT(varchar(10),uDatetime,120)
HAVING CONVERT(varchar(10),uDatetime,120) BETWEEN '2013-12-21' AND '2013-12-22'
求问，如何将上面的SQL代码转为linq to entity。
entities.Logs.Where(o => o.uDatetime >= timeStart && o.uDatetime < timeend && o.uType == type).ToList().GroupBy(o => new DateTime(o.uDatetime.Value.Year, o.uDatetime.Value.Month, o.uDatetime.Value.Day)).Select(z => new Propertys { Datetime = new DateTime(z.Key.Year, z.Key.Month, z.Key.Day), Count = z.Count() }).ToList<Propertys>();
我是这样子写的，可是性能超级差，主要是GroupBy前面的ToList()，不加的话会报错，加了又变得很慢。
