SQL查询到Linq的转换 [英] Sql Query to Linq Conversion

问题描述

select br.batchkey, count(rj.id) as ratejobcreated, 
(select COUNT(ID) from RATEJOB inner join batch_ratejob on batch_ratejob.ratejobkey = ratejob.id
where batch_ratejob.batchkey = br.batchkey and completedflag = 1)
Farhan Iqbal (3:28:06 PM):	as ratejobcompleted, u.loginname,
COUNT(rp.id) as shipment_count
from batch_ratejob br
inner join ratejob rj on br.ratejobkey = rj.id
inner join users u on rj.userkey = u.id
inner join batch b on br.batchkey = b.id
inner join rateprocess rp on rp.batchkey = b.id
group by br.batchkey, u.loginname

如何在linq中转换以上查询?
请帮帮我.

How to convert above query in linq?
Please help me out.

推荐答案

看看 Linqer [^ ]演示.可能有帮助.

Take a look at the Linqer[^] demo. It might help.

请参考上面的sql的LINQ查询，可能会对您有所帮助. [OperationContract]
公共IQueryable fun()
{
DataClasses1DataContext db =新的DataClasses1DataContext();
从db.batch_ratejob中的br返回(IQueryable)(< 从db.ratejobs中的rj加入br.ratejobkey等于rj.idinner
在rj.userkey上从db.users中的u加入等于u.idinner
从br.batchkey上的db.batchs中的b加入等于b.idinner
从rp.batchkey上的db.rateprocesss中的rp联接等于b.id
按br.batchkey分组，u.loginname
选择新的{br.batchkey，count(rj.id)作为ratejobcreated，
(来自db.RATEJOBs中的
从db.batch_ratejobs中的b加入
在b.ratejobkey上等于a.id
其中b.batchkey等于br.batchkey&& completedflag等于1选择new(COUNT(ID));)
作为ratejobcompleted，u.loginname，COUNT(rp.id)作为shipping_count});

Refer this LINQ Query for above sql, may be it will help you..
[OperationContract]
public IQueryable fun()
{
DataClasses1DataContext db = new DataClasses1DataContext();
return (IQueryable)( from br in db.batch_ratejob
join from rj in db.ratejobs on br.ratejobkey equals rj.idinner
join from u in db.users on rj.userkey equals u.idinner
join from b in db.batchs on br.batchkey equals b.idinner
join from rp in db.rateprocesss on rp.batchkey equals b.id
group by br.batchkey, u.loginname
select new {br.batchkey, count(rj.id) as ratejobcreated,
(from a in db.RATEJOBs
join from b in db.batch_ratejobs
on b.ratejobkey equals a.id
where b.batchkey equals br.batchkey && completedflag equals 1 select new (COUNT(ID));)
as ratejobcompleted, u.loginname,COUNT(rp.id) as shipment_count });

这篇关于SQL查询到Linq的转换的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！