Question: Issue with DateTime Field

[dixitsuneel]

If the model contains a DateTime field

class Entity {
   public DateTime DateLastModified { get;set; }
}

If I apply a filter using queryable.Where("DateLastModified > '2018-07-17'") then with Ef Core 2.1 I am seeing that the query is translated to

where DateLastModified>'2018-07-17T00:00:00.0000000'

This leads to the sql query being failed.

It wasn't an issue with Ef Core 2.0 but I am seeing this issue with Ef Core 2.1.1

[StefH]

Hello @dixitsuneel.

I did test this with EF 2.1.1 with real database en with in-memory database, and in both cases all works.

Note that you need \" instead '.

Example:

var carDateLastModified = context.Cars.Where(config, "DateLastModified > \"2018-01-16\"");

[StefH]

@dixitsuneel Closing this issue, if you still have problems, comment here of create a new issue.