Nullable DateTime issue with SQLite

[SamuelLioult]

I have an issue with a nullable DateTime. I create an instance of a model which contains a nullable DateTime. When I want to update the datetime value in te database, the saved value is always 01/01/0001 in the SQLite database. This issue only appears in RELEASE mode but not in DEBUG mode.

If you are seeing an exception, include the full exceptions details (message and stack trace).

I describe my issue here with a sample code to reproduce the issue.

Further technical details

EF Core version: Microsoft.EntityFrameworkCore.SQLite 1.1.2
Database Provider: Microsoft.EntityFrameworkCore.SQLite
Operating system: Windows 10 15063.608
IDE: Visual Studio 2017

[ajcvickers]

@SamuelLioult Is this a UWP app?

[ajcvickers]

@SamuelLioult Never mind--I see that it is from the link. It could be an issue with .NET Native, and may already be fixed in 2.0. We will investigate.

[SamuelLioult]

@ajcvickers Yes it is a UWP app

[AndriySvyryd]

This is fixed in 2.0.3/2.0.1 with UWP 6

To try out the pre-release patch, please refer to the following guide:

• ASP.NET/EF Core 2.0.3 patch pre-release test feed aspnet/Announcements#274 (info)
• ASP.NET/EF Core 2.0.3 patch pre-release test feed - discussion aspnetcore#2254 (discussions and questions)

[dahovey]

Are there any possible workarounds for this issue, with using version 1.1.4 of EF Core?

Since using version 2.x of EF Core with UWP requires the Windows Fall update this isn't possible with the project I'm working on.

The only possible workaround I can think is to use Raw Sql to insert or update entity that has any nullable DateTime/DateTimeOffset values. Is there anything that can be overridden by a consumer to fix the issue?