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
Post a Comment