Support the new BCL DateOnly and TimeOnly structs

[roji]

New DateOnly and TimeOnly structs are being introduced to .NET 6 as alternatives to DateTime (dotnet/runtime#49036). MySqlConnector issue: mysql-net/MySqlConnector#963.

[mattjohnsonpint]

Please note that the final names for these types are DateOnly and TimeOnly and that they are now merged into the main branch for the next version of .NET 6 (preview 4 likely). Please rename the title of this issue accordingly. Thanks.

[lauxjpn]

They are coming in .NET 6 Preview 4.

[roji]

@lauxjpn yes.

Note that it may be a good idea to hold off here (and in Npgsql) until support is added in EF Core itself (dotnet/efcore#24506, dotnet/efcore#24507), this way the specification tests will already be added upstream. I hope to make that happen pretty quickly after the preview4 release.

[uzairali001]

Any news?
When I'm trying to create migrations it shows this error
The property 'MyEntity.LastCalled' could not be mapped because it is of type 'DateOnly?', which is not a supported primitive type or a valid entity type. Either explicitly map this property, or ignore it using the '[NotMapped]' attribute or by using 'EntityTypeBuilder.Ignore' in 'OnModelCreating'.

Dotnet version: 6.0.100-preview.7.21379.14
Pomelo Version: 6.0.0-preview.5

[roji]

FYI support in EF Core has been added for Sqlite, including functional tests.

[lauxjpn]

Any news?

We will implement it in the near future.

[BrokenShoeLace]

Using EF 6.05 and the same error as @uzairali001 on VS2022 for Microsoft SQL 2019

[mguinness]

@BrokenShoeLace If you're using MS SQL then please look at dotnet/efcore#24507.

[BrokenShoeLace]

Thanks for the link but ut doesnt address my issue:

TimeOnly is not DateOnly

[lauxjpn]

@BrokenShoeLace Please clarify: Are you using Pomelo.EntityFrameworkCore.MySql or Microsoft.EntityFrameworkCore.SqlServer?

[BrokenShoeLace]

Microsoft.EntityFrameworkCore.SqlServer

[roji]

Microsoft.EntityFrameworkCore.SqlServer doesn't support DateOnly/TimeOnly, because the underlying SqlClient doesn't - the issue tracking that is dotnet/SqlClient#1009. Once that's done, support in EF Core can be enabled in dotnet/efcore#24507.

This is the respository for the Pomelo MySQL provider, so not related to SQL Server.