帮忙看看这个怎么成LINQ？
select
count(a.fund_id) n
from
t_fund_info as a
inner join t_fund_join_year as b
on a.fund_id = b.fund_id
inner join t_fund_type as c
on b.type = c.type_id
where a.status in(1,2) and
b.category = 19 and
c.type_id in (24,25) and
b.join_year = 0 and
b.status = 1
and exists(
select * from t_fund_org_index as i
where
i.org_type in(100043)
and a.fund_id = i.fund_id
and (i.is_current = 1 OR a.status = 2)
and exists(
select * from t_org_class as os
where os.class_type in (100053) and os.org_id = i.org_id
)
)

对linq语法不是很懂。请大家帮帮忙

[解决办法]
不懂 帮顶
[解决办法]
select
ti.fund_id,
ti.fund_name,
dbo.fun_get_org_mebmer(fund_id,1),
dbo.fun_get_org_info(fund_id,100050)
from
t_fund_info as a
inner join t_fund_join_year as b
on a.fund_id = b.fund_id
inner join t_fund_type as c
on b.type = c.type_id
where a.status in(1,2) and
b.category = 19 and
c.type_id in (24,25) and
b.join_year = 0 and
b.status = 1
and exists(
select * from t_fund_org_index as i
where
i.org_type in(100043)
and a.fund_id = i.fund_id
and (i.is_current = 1 OR a.status = 2)
and exists(
select * from t_org_class as os
where os.class_type in (100053) and os.org_id = i.org_id
)
)

其实sql的原型是这个
[解决办法]
var query =(from a in db.t_fund_info
join b in db.t_fund_join_year on a.fund_id equals b.fund_id
join c in db.t_fund_type on b.type equals c.type_id
where
(
new int[]{1,2}
).Contains(a.status) && (b.category == 19) &&
(
new int[]{24,25}
).Contains(c.type_id) && (b.join_year == 0) &&(b.status == 1) &&
(db.t_fund_org_index.Any(c=>(c.org_type==100043)&&(a.fund_id = c.fund_id)&&(c.is_current == 1 || a.status == 2)&&(db.t_org_class.Any(d=>d.class_type==100053&&d.org_id==c.org_id)))
select a.fund_id).Count();

再试试这个，我都试过了，没有错误
顺便提下，你的这个也太长了
就不能分开来写吗
搞的这么长……
[解决办法]

C# code

var query=(from a in db.t_fund_info           join b in db.t_fund_join_year          on a.fund_id equals b.fund_id          join c in db.t_fund_type          on b.type equals c.type_id          let temp= from i in db.t_fund_org_index                    let t=db.t_org_class.Where(os=>new int[]{100053}.Contains(os.class_type)                                              && os.org_id ==i.org_id)                    where new int[]{100043}.Contains(i.org_type)                    && a.fund_id == i.fund_id                    && (i.is_current==1 || a.status==2)                    && t.Any()                    select i   //sorry for this place          where new int[]{1,2}.Contains(a.status)             &&new int[]{24,25}.Contains(c.type_id)             && b.category==19 && b.join_year==0 && b.status==1             && temp.Any()          select a.fund_id).Count();