c# - DevForce 2010 Formatting Dates for EntityQuery -

i've run situation need query date , time. i'm trying write entityquery date , time in same format. query below returns no rows. if remove 2 date clauses, rows returned , can check dates looping through results. prefer use dates in query.

the variable ap in query c# object  var query = log in manager.logs             log.startdttm == ap.startdttm                   && log.enddttm == ap.enddttm                   && log.typeid == 1             select log; 

i came workaround query between midnight , 11:59:59pm each date. don't either, @ least reduce number of rows returned query.

var query = log in manager.logs             && log.startdttm >= ap.startdttmquerybegin                   && log.startdttm <= ap.startdttmqueryend                   && log.enddttm >= ap.enddttmquerybegin                   && log.enddttm <= ap.enddttmqueryend                   && log.typeid == 1             select log; 

devforce doesn't expect specific date/time formats or modify them when query built , executed, it's not date format per se precision of data stored in database vs. precision of datetime fields in "ap" object causing issue.

in ef can use entityfunctions and/or sqlfunctions apis perform date/time truncating/formatting, these difficult use in devforce due client/server serialization , entityquery objectquery conversion devforce performs. these apis can made work on "server side" of devforce via rpc call.

your workaround, although may feel cumbersome, best option. try calling stored procedure or using esql passthru query, both of give little more control on resulting sql query.