12
I had a method to get the date part of a date in my linq to entity.
DateTime plusDateTime = DateTime.Now.Date.AddDays(1);
DateTime date = DateTime.Now.Date;
query = query.Where(q => (q.Item2 >= date && q.Item2 < plusDateTime.Date));
A bit of a hack. I found that there are EntityFunctions that are available.
query = query.Where(q => EntityFunctions.TruncateTime(q.Item2) >= date);
This gets the date part only.