Hot to convert this sql query in linq.

Question

hi guys,

 

Please help me out from this. i stuck at this  query, i tried but not able to convert in linq. please help. Thanks.

 

select * from (select dl_master.deal_id as `Deal #`, dl_master.deal_name as `Name`,

 

str_to_date(if(dlStart.dlCon_Field is null, '01/01/1900 12:00:00 AM', dlStart.dlCon_Value),'%c/%e/%Y %r') as `Start`,

 

str_to_date(if(dlEnd.dlCon_Field is null, '01/01/9998 12:00:00 AM', dlEnd.dlCon_Value),'%c/%e/%Y %r') as `End`

 

from dl_master Left Join dl_condition dlStart ON dlStart.deal_id = dl_master.deal_id

and dlstart.dlCon_Field = 'Start Date'

Left Join dl_condition dlEnd ON dlEnd.deal_id = dl_master.deal_id and dlEnd.dlCon_Field = 'End Date'

where dl_master.flgDisabled=0) as t Where `start`<=now() AND (`end`>=now() or `end` is null)