Postgresql date field is translated as C# DateTime, not DateOnly
I have table with date column which is date type.
EfCore scaffolding results in DateOnly type, but LINQPad is DateTime.
Why is that? How to change it?
Comments
-
Are you using LINQPad's built-in dynamic EF Core driver?
If so, what EFCore version have you selected in the dropdown? You will need to select version 6 or 7 in order to use the DateOnly type.
-
@JoeAlbahari How do I check if I'm using builtin EF Core driver? I didn't do anything extra so I think it's builtin
Do you mean here where I have .NET version 7
Or here in connection settings:
How do I change EF Core version?
-
In the connection settings. Change from version 5 to version 7.
-
@JoeAlbahari Oh my ok, I was confused because it says Latest recommende 5.0.10 and thought that was the latest available. Numbers are not in order.
Ok it's fine now, thanks
