SqliteParameter.SqliteType throws InvalidOperationException for DateOnly/TimeOnly

[inosik]

The SqliteParameter.SqliteType Property throws an InvalidOperationException when the value is a DateOnly or TimeOnly.

var p = new SqliteParameter { ParameterName = "date", Value = new DateOnly() };
_ = p.SqliteType;

System.InvalidOperationException: No mapping exists from object type System.DateOnly to a known managed provider native type.
   at Microsoft.Data.Sqlite.SqliteValueBinder.GetSqliteType(Object value)
   at Microsoft.Data.Sqlite.SqliteParameter.get_SqliteType()

DateOnly and TimeOnly are missing here:

efcore/src/Microsoft.Data.Sqlite.Core/SqliteValueBinder.cs

Line 240 in f741ba4

private static readonly Dictionary<Type, SqliteType> _sqliteTypeMapping =

Version information

Microsoft.Data.Sqlite version: 6.0.2, 7.0.0-preview.1.22076.6
Target framework: .NET 6.0
Operating system: n/a

[roji]

Duplicate of #27213

[roji]

This is already fixed in PR #27291, which closes #27213.

[inosik]

Thanks for pointing this out. Somehow I overlooked the open PR.