Error when filtering Date in Datagrid

Werther · February 6, 2023, 1:08pm

Werther · February 6, 2023, 1:56pm

It was a column type issue. Changed the column to datetime2 and now it's ok. Found this in the post below:

github.com/dotnet/efcore

error converting datetime in ef core

opened 10:02AM - 17 Feb 22 UTC

closed 08:26PM - 16 Oct 22 UTC

brux88

closed-no-further-action customer-reported

Hi, with ef core (net 6) I have a problem in converting dates, before everything… worked with the old .net framework. this is my code for reply the error: `var query = ((SednaContext)Context).Set<TestataDocumento>().Where(x => x.DataDocumento == new DateTime(2021, 2, 17)); var result = query.Take(1);` and this is result of error: ![Clipboard-File-1](https://user-images.githubusercontent.com/3495339/154451845-3f5a8332-baad-4f48-9f30-1ad2c59072cb.png) this is a workaround: `public class SednaContext : DbContext { ... protected override void OnModelCreating(ModelBuilder modelBuilder) { ... modelBuilder.Entity<TestataDocumento>().Property(p => p.DataDocumento).HasColumnType("datetime"); } }` but I have a context with more than 400 tables and each table has different dates, I can't manually set one by one on the OnModelCreating