convert Oracle query (to_timestamp) into LINQ statement

Question

I realize I need this for LINQ, as from http://stackoverflow.com/questions/11135820/convert-oracle-query-as-of-timestamp-to-linq

SELECT --DISTINCT MAINSERNO, to_char(TIMESTAMP, 'MM/DD/YYYY HH24:MI:SS') as TIMESTAMP
COUNT(DISTINCT MAINSERNO) AS TOTAL
FROM PPL_PRODUCT_TESTID2
WHERE (MONO = '5750327') AND (ITNO = '132959') AND (SYSTEMTYPE = '0036') AND (TESTFLAG = '1')
     AND (TIMESTAMP > to_timestamp('08/05/2013 23:30:00', 'MM/DD/YYYY HH24:MI:SSFF2')) 
     AND (TIMESTAMP < to_timestamp('08/06/2013 00:30:00', 'MM/DD/YYYY HH24:MI:SSFF2')) 
Order by  TIMESTAMP ASC