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?
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