如何在linq to sql的查询中使用Order statment [英] how can I use Order statment in my query in linq to sql

问题描述

Hy我在linq中查询到sqal

Hy I have a query in linq to sqal

from r in db.Reports
join ri in db.ReportItems on r.ID equals ri.ReportID
join rt in db.ReportTypes on ri.ReportTypeID equals rt.ID into q_join
from q in q_join.DefaultIfEmpty()
join st in db.SwitchTypes on q.SwitchTypeID equals st.ID into j_join
from j in j_join.DefaultIfEmpty()
join c in db.Centers on j.ID equals c.Switch into k_join
from k in k_join.DefaultIfEmpty()
where (k.ID == Center.Selected.ID) && (r.Date.Value == date) && (r.Shift.Value == (int)User.Current.Shift)
select r).FirstOrDefault();

我想通过rt.Rank订购。

我该怎么做？

I want to order by rt.Rank .
How can I do this ?

推荐答案

使用订单在Where子句之后，在Select之前。以下是样本

Use Order by after Where clause, before Select. Below is the sample

from r in db.Reports
join ri in db.ReportItems on r.ID equals ri.ReportID
join rt in db.ReportTypes on ri.ReportTypeID equals rt.ID into q_join
from q in q_join.DefaultIfEmpty()
join st in db.SwitchTypes on q.SwitchTypeID equals st.ID into j_join
from j in j_join.DefaultIfEmpty()
join c in db.Centers on j.ID equals c.Switch into k_join
from k in k_join.DefaultIfEmpty()
where (k.ID == Center.Selected.ID) && (r.Date.Value == date) && (r.Shift.Value == (int)User.Current.Shift)

orderby rt.Rank

select r.FirstOrDefault();

希望这会对你有所帮助。

Hope this helps you.

这篇关于如何在linq to sql的查询中使用Order statment的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！