Does this support DateOnly/TimeOnly?

[VictorioBerra]

A recent PR to Dapper added support for DateOnly/TimeOnly. Is creating a date field in Microsoft SQL Server + DateOnly in C# supported by zzzprojects Dapper-Plus?

[JonathanMagnan]

Hello @VictorioBerra ,

That's a good question; I know we already support it for our Entity Framework Extensions library, but I'm not sure for Dapper Plus. I will ask my developer to look at it.

Best Regards,

Jon

[JonathanMagnan]

Hello @VictorioBerra ,

Just to let you know that DateOnly and TimeOnly will be supported the next time we release Dapper Plus (normally on Tuesday 26)

Best Regards,

Jon

[VictorioBerra]

That is exciting, thank you! So we can create a MSSQL date col and a DateOnly C# prop and it will all magically work?

[JonathanMagnan]

Yup, as soon as the new version is released.

I didn't test it but my employee told me it could already work with the current version by adding both type this way:

DapperPlusManager.AddCustomSupportedType(typeof(DateOnly));
DapperPlusManager.AddCustomSupportedType(typeof(TimeOnly));

Best Regards,

Jon

[JonathanMagnan]

Hello @VictorioBerra ,

The support to DateOnly and TimeOnly has been added in the version 7.4.0.

Could you test it and let us know if everything is working as expected?

Best Regards,

Jon

[VictorioBerra]

Thank you @JonathanMagnan sorry for the delay, it worked great!