问个LINQ排序问题
var query = (from a in db.BANK_FIN_PRDjoin b in db.BANK_FIN_DETAIL
on a.INNER_CODE equals b.INNER_CODE
where SqlMethods.Like(a.PRD_NAME, "%" + ProName + "%")
select new MulTable
{
Proid = a.INNER_CODE.ToString(),
ProName = a.PRD_NAME,
ProPrice = b.ENTR_MIN_CURNCY.ToString(),
ProLicai = b.INC_DATE.ToString(),
}
);
List<MulTable> list = query.Take(takes).Skip(skips).ToList();
return list;
这个是我写的一个查询。现在要根据INNER_CODE PRD_NAME 这几个字段进行动态升序降序。。求大神们指点。 linq --------------------编程问答-------------------- order by new{INNER_CODE=a.INNER_CODE,PRD_NAME=a.PRD_NAME}
--------------------编程问答--------------------
var query = (from a in db.BANK_FIN_PRD--------------------编程问答-------------------- 你要是动态升序或降序,估计得加if条件了 --------------------编程问答--------------------
join b in db.BANK_FIN_DETAIL
on a.INNER_CODE equals b.INNER_CODE
where SqlMethods.Like(a.PRD_NAME, "%" + ProName + "%")
orderby a.INNER_CODE descending,a.PRD_NAME ascending
select new MulTable
{
Proid = a.INNER_CODE.ToString(),
ProName = a.PRD_NAME,
ProPrice = b.ENTR_MIN_CURNCY.ToString(),
ProLicai = b.INC_DATE.ToString(),
}
);
楼上正解 --------------------编程问答-------------------- 反正是 延迟查询,可以用if 判断。
补充:.NET技术 , LINQ