c# - Translating TSQL query to LINQ -


i have created sql statement gathers unprocessed files database. uses dicomdatatype_lk table limit results interested in. when run it, get 2 results.

select * [procedure].dicomdata dicoms join [procedure].dicomdatatype_lk dtype     on dicoms.dicomdatatypeid = dtype.dicomdatatypeid dicoms.procedureid = '00000000-0000-0000-0000-000000000000'     , dicoms.createdate > '3/27/2017'     , (dtype.dicomdatatype 'v density'         or dtype.dicomdatatype 'q density'         or dtype.dicomdatatype 'i density'         or dtype.dicomdatatype 'u density') 

i have translated linq sql, same connection getting 0 results.

            iqueryable<dicomdata> rows = dicoms in db.dicomdatas                join dtype in db.dicomdatatype_lks                   on dicoms.dicomdatatypeid equals dtype.dicomdatatypeid                dicoms.procedureid == guid.empty                   && dicoms.createdate > fromtime                   && (dtype.dicomdatatype.equals("v density")                   || dtype.dicomdatatype.equals("q density")                   || dtype.dicomdatatype.equals("i density")                   || dtype.dicomdatatype.equals("u density"))                select dicoms; 

i have confirmed fromtime gives value should include 2 results. please let me know doing wrong in translation?

from can see:

and dicoms.createdate >= '3/27/2017' not same && dicoms.createdate > fromtime

i.e. >= not same >


Comments