Loading

sql query to linq query

Naresh Babu Gopavaram

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

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Suthish Nair15y ago
ok.. but i want to know the above script i posted giving correct output or not?
Naresh Babu Gopavaram15y ago
no
i want in linq
Suthish Nair15y ago
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