sql query to linq query

Question

select rm.doc,rm.name,pd.address,volumename=(select vaolum from CDMaster where di.code =Cdmaster.code) From RegistrationMaster RM inne rjoin Partydetails pd on rm.doc=pd.doc inner join DocumentInfo DI on rm.cdcode=DI.cdcode  

please 
send linq for that sql query 


how can i get this 
(select vaolum from CDMaster where di.code =Cdmaster.code)


other than this i got all fields 

Answer 1

ok.. but i want to know the above script i posted giving correct output or not?

Answer 2

no
 i want in linq 

Answer 3

 resolved?

 will this not work...

 select rm.doc,rm.name,pd.address, cd.vaolum 'volumename'

 From RegistrationMaster RM inner join Partydetails pd 

 on rm.doc=pd.doc 

 inner join DocumentInfo DI 

 on rm.cdcode=DI.cdcode

 inner join CDMaster cd 

 on di.code = cd.code