Hwo to convert this query in LINQ.

Question

Hi frnds....

 

i have to  convert this query. So please lead me, or help me out.....

 

SELECT sum(Qty), Sum(round(errprice * Qty,2)) as 'Price' FROM ViewNoSale where tx_number=-1 and First_Name = 'Girish' and canceltime between '2015-12-10 00:00:00' and '2015-12-10 23:59:59' and date_format(Canceltime,'%m-%d-%Y %h:%i:%p') IN (select date_format(NSTime,'%m-%d-%Y %h:%i:%p') from nosale, tx_err_log where tx_err_log.userid=User_id and tx_err_log.registerno=reg_no and NSTime between '2015-12-10 00:00:00' and '2015-12-10 23:59:59')

 

 

 

Thnaks.....