I have table with date column which is date type.
date
EfCore scaffolding results in DateOnly type, but LINQPad is DateTime.
DateOnly
DateTime
Why is that? How to change it?
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
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