Using LINQ to SQl to achieve column Query -

can below query achieved linq sql?

select id,        (select statename b_mstates id=stateidfk) [state name],        cityname  b_mcities 

var result = b_mcities.where(x => b_mstates.where(y => y.id == stateidfk)                                     .contains(x.statename)).tolist(); 

your question pretty tough, because sql wont run(it malformed , missing logic). jist of need do.