I have a field of type DateTime?
(null allowed) that is in the complete date / time format (dd / mm / yyyy hh: mm: ss).
I need to display the date and time in separate columns in a datagridview. I tried to use DbFunctions.TruncateTime(x.Data.Value.Date)
as I saw in suggestions here, but it gives the following error:
System.NotSupportedException: 'The specified type member' Date 'is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported. '