System.Data.SQLite
View Ticket
Not logged in
Ticket UUID: e783306b26b7b5f22188f6166761141a04c8a6df
Title: DateTimekind doesn't work
Status: Closed Type: Incident
Severity: Important Priority: Medium
Subsystem: Convert Resolution: Works_As_Designed
Last Modified: 2018-01-24 17:46:13
Version Found In: 1.0.106 System.Data.SqLite.Core
User Comments:
anonymous added on 2017-12-06 13:50:26:
Hi,

I have a test which:
1. create object with property of type DateTime to which I assign a DateTime.UtcNow
2. save this object to db
3. query db for this object
4. in result I get a object with property of type DateTime, but with Date with kind set to `Local` instead of `UTC`.
I try to specify a DateTimeKind in connectionstring, but it didn't helps.
var connection = new SQLiteConnection("DateTimeKind=Utc;Data Source=:memory:");
When I work with legacy SqLite.x64 ver. 1.0.76 everything works fine.
Short disclaimer I don't want to use System.Data.SqLite because I don't want to get EntityFramework as a dependency to my project.

Thanks in advance,
MichaƂ

mistachkin added on 2018-01-24 16:28:12:
I'm unable to reproduce this issue.  Do you have a short example that demonstrates
the issue?