将sql查询转换为链接查询 [英] converting sql query into link query
本文介绍了将sql查询转换为链接查询的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
亲爱的朋友,
我有一个sql查询,发现有点难以将其转换为LINQ查询。
查询是:如何将其写入Linq查询?
SELECT Emp_Name, sum(salary) as salary FROM [dbo]。[Tblmst_Emp1]
GROUP BY Emp_Name
order by Emp_Name Asc
薪水> 10000
我谷歌但没有找到合适的答案..
谢谢..
解决方案
< blockquote>试试这个,
var result =(
来自
emp
in
DatabaseContext.Tblmst_Emp1
其中
emp.Salary < 10000
group
emp by new {emp.Emp_Name} 进入 e
选择
new {e.Key。 Emp_Name,Salary = e.Sum(x = > x.salary)}
).OrderBy(x = > ; x.Emp_Name)
.toList();
我希望这会有所帮助。
谢谢:)
Dear friend,
I got one sql query which found little bit difficult to convert it into LINQ query.
Query is : How can i write it into Linq query??
SELECT Emp_Name, sum(salary) as salary FROM [dbo].[Tblmst_Emp1]
GROUP BY Emp_Name
order by Emp_Name Asc
Having Salary > 10000
I google it but didn''t find suitable answer..
Thanks..
解决方案
Try this,
var result = ( from emp in DatabaseContext.Tblmst_Emp1 where emp.Salary < 10000 group emp by new { emp.Emp_Name} into e select new { e.Key.Emp_Name, Salary = e.Sum(x => x.salary)} ).OrderBy(x => x.Emp_Name) .toList();
I hope this will help.
Thanks :)
这篇关于将sql查询转换为链接查询的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文