I am trying to make a LINQ to get results among 2 dates but I cannot execute it and I am having an exception. I have tried to use DbFunctions.TruncateTime but it still does not working.
DbFunctions.TruncateTime
How do I to fix this?
Trying
model.dtIni = dtIni; //dtIni datetime param model.dtFim = dtFim; //dtFim datetime param model.numeros = context.numerosSorteio.Where(n => ( n.dataCompra.Value.Date == model.dtIni.Value.Date && n.dataCompra.Value.Date == model.dtFim.Value.Date) ))
Exception
Exception thrown: 'System.NotSupportedException' in EntityFramework.dll Erro: The specified type member 'Date' is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported.
Exception thrown: 'System.NotSupportedException' in EntityFramework.dll
Erro: The specified type member 'Date' is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported.
Change your request to this:
model.numeros = context.numerosSorteio.Where(n => ( n.dataCompra >= model.dtIni && n.dataCompra <= model.dtFim) )).ToArray();
1.4m articles
1.4m replys
5 comments
56.9k users