baran_bataravat
پنج شنبه 16 آذر 1391, 09:31 صبح
يك كوئري به شكل زير دارم معادل آن در linq به چه شكل مي باشد؟
select * from dbo.Gavahi g
where g.id not in (select GavahiID from dbo.AsnadMaliDetail ad group by GavahiID
having sum( MablaghMoredEstefade)>= (select mablagh from dbo.Gavahi g where g.id=ad.GavahiID))
select * from dbo.Gavahi g
where g.id not in (select GavahiID from dbo.AsnadMaliDetail ad group by GavahiID
having sum( MablaghMoredEstefade)>= (select mablagh from dbo.Gavahi g where g.id=ad.GavahiID))