|Title:||In-place creation of DateTime vs as assigned variable in the same query produced different result|
|Last Modified:||2014-05-30 00:43:43|
|Version Found In:||1.0.92|
anonymous added on 2014-05-29 22:05:34:
I am sorry about opening a new ticket. The previous one has been closed, and I discovered something different. Below is the description of the problem: The definition of the table is: CREATE TABLE "Order" ("Id" bigint PRIMARY KEY NOT NULL , "Date" DATETIME NOT NULL , "Type" varchar(8) NOT NULL ) I ran some more tests with how the date is created. I found that how the date is created (in place or as a variable) instead of the syntax style caused the behavior difference. // query 1 - passed, returned 2 var c = db.Orders.Where(i => i.Date == new DateTime(2014, 5, 23)).Count(); // query 2 - failed, returned 0 var date = new DateTime(2014, 5, 23); var c = db.Orders.Where(i => i.Date == date).Count(); Same behavior for both styles and both DATE and DATETIME sql type.
mistachkin added on 2014-05-30 00:43:43:
Duplicate ticket, see [da9f18d039670357688a27968aab836199f1ac49]. Please click on "Edit" to add comments there.