Hello,
I'm using the "System.Data.SQLite.Core" lib to connect to a sqlite-database and try to query a dataset by using DateTime in the WHERE clause. If I directly use the DateTime object as parameter to the WHERE clause I don't get any result. If I reproduce this against, for example, a MySQL database it handles the paramter correctly. I started a discussion at https://www.reddit.com/r/csharp/comments/4gexh6/cant_query_datetime_in_sqlit edapper/ which let me to the conclusion that it might be a bug in the SQLite driver. It seems to be dependent on the culture that my application is running in. Here the gist: https://gist.github.com/anonymous/0e11f74f075231f5c5be3dcc0dd7510b The following nuget packages were used: Dapper, System.Data.SQLite.Core, FluentMigrator, FluentMigrator.Runner What I expect is that "QueryAndFilterDatabaseSide" also returns one record. Best regards
