Trying to get items from db but getting System.NotSupportedException, found how to avoid but to me it doesn't help. Any ideas to how I can avoid this exception?
return await DbContext.Members.Where(
x => x.ClientId == criteria.ClientId
DbFunctions.TruncateTime truncates the time from the date, so there is no need to use
.Value.Date, which is what is causing the exception.