Entity Framework 8 with SQL Server provider will support DateOnly and TimeOnly types

Version 5.1 of Microsoft.Data.SqlClient was released last week (19th Jan 2023) and included support for DateOnly and TimeOnly types which were released in .NET 6.

Since Entity Framework uses Microsoft.Data.SqlClient it couldn’t previously support these types ‘out of the box’, although some workarounds were available.

Now that the underlying provider supports these types EF can support them too and in fact @shayrojansky is working on the implementation right now

Pipelines – Run 20230122.3 (azure.com) 👇🏻 …

Expect this functionality to be available in the Entity Framework daily builds soon, like possibly today 💪🏻 …

Leave a Reply

Your email address will not be published. Required fields are marked *