c# - convert sql subquery to linq -

i'm trying convert simple subquery linq (c#):

select * tblfundtofiscalyear ftfy ftfy.fiscalyear = 2015      , ftfy.fundid =(         select fundid         tblaccountdirectparent]         parentaccountid = 19 ) 

something along lines of:

var queryftfy =     ftfy in fratcontext.tblfundtofiscalyear     ftfy.fiscalyear == 2015          && ftfy.fundid =             (from adp in fratcontext.tblaccountdirectparent              adp.parentaccountid == 19              select adp.fundid)     select new     {         ftfy.fundtofiscalyearid     }; 

assistance appreciated.

your sql relies on assumption subquery returns 1 result. can make explicit in linq:

var queryftfy =     ftfy in fratcontext.tblfundtofiscalyear     ftfy.fiscalyear == 2015 && ftfy.fundid ==     (         adp in fratcontext.tblaccountdirectparent         adp.parentaccountid == 19         select adp.fundid     ).single()     select ftfy; 

alternatively, reformulate query (in both cases) join:

var queryftfy =     ftfy in fratcontext.tblfundtofiscalyear     join adp in fratcontext.tblaccountdirectparent     on ftfy.fundid equals adp.fundid     ftfy.fiscalyear == 2015         && adp.parentaccountid == 19     select ftfy;