Skip to content

Blogs

Resolved: The specified type member ‘Date’ is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported.

I come across the following error while comparing Date in Linq lambda in the .NET C# project. The exact error is The specified type member ‘Date’ is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported. My code… Read More »Resolved: The specified type member ‘Date’ is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported.

Compare dates in SQL

A lot of times we come across issues comparing dates in SQL. There are a few scenarios below Compare dates in the DateTime Column Select * from EMP WHERE datetime_column >= ‘20221220 00:00:00.000’ AND datetime_column < ‘20221221 00:00:00.000’ Compare Day Year Month separately in DateTime… Read More »Compare dates in SQL