嗨,需要帮助。如何将SQL转换为LINQ?谢谢 [英] Hi need help please. how to Convert SQL to LINQ? thanks
本文介绍了嗨,需要帮助。如何将SQL转换为LINQ?谢谢的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
SELECT convert ( varchar ,TraDate, 101 )作为 ' 日期',count( 1 ) as ' 否。 of Applications'
FROM table
where TraDate ' 04-20-2015' 和 ' 04-27-2015'
group by convert ( varchar ,TraDate, 101 )
< span class =code-keyword> order by convert ( varchar ,TraDate, 101 ) desc
解决方案
试试这个:
DateTime dFrom = new DateTime( 20 , 4 , 2015 跨度>);
DateTime dTo = new DateTime( 27 , 4 , 2015 );
var qry = datacontext
。其中(a => a.TraDate> = dFrom&& a.TraDate< = dTo)
.GroupBy(a => a.TraDate.ToString( MM-dd-yyyy))
。选择(grp => new
{
Date = grp.Key,
CountOfApps = grp.Count()
});
SELECT convert(varchar, TraDate, 101) As 'Date', count(1) as 'No. of Applications'
FROM table
where TraDate between '04-20-2015' and '04-27-2015'
group by convert(varchar, TraDate, 101)
order by convert(varchar, TraDate, 101) desc
解决方案
Try this:
DateTime dFrom = new DateTime(20,4,2015); DateTime dTo = new DateTime(27,4,2015); var qry = datacontext .Where(a=>a.TraDate>=dFrom && a.TraDate<=dTo) .GroupBy(a=>a.TraDate.ToString("MM-dd-yyyy")) .Select(grp=>new { Date = grp.Key, CountOfApps = grp.Count() });
这篇关于嗨,需要帮助。如何将SQL转换为LINQ?谢谢的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文