How to convert sub query in linq using entity framwork

[AnkitKumar2016]

Hi,

What is the best way to convert following query into linq-

select *
, (select
count([ContractStatus] )
from contracts where [ContractStatus]
in ('ACTIVE', 'PM CONTRACT', 'T&M ONLY')
and contracts.jobid=jobs.jobid
)
from jobs

Thanks

Continue reading...