Linq date and datetime comparer

Question

I need to get the query of the day, the problem is that I'm getting an error when I try to compare the value that comes from the DB (which is a DateTime), against the DateTime.Today.Date value.

What I'm trying to achieve is to get the registers of the day.

List<Client> _cliente = from c in db.Cliente
                        join v in db.Vendedor
                        on c.IDVendedor equals v.IDVendedor
                        where v.Fecha.Date.Equals(DateTime.Today.Date)

This is what I'm getting: 'The specified type member 'Date' is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported.'

score 9 · Accepted Answer · answered Jan 10 '12 at 17:14

9

Maybe you can do something like this:

var today = DateTime.Today;
var tomorrow = today.AddDays(1);

List<Client> _cliente = from c in db.Cliente
                    join v in db.Vendedor
                    on c.IDVendedor equals v.IDVendedor
                    where v.Fecha >= today && v.Fecha < tomorrow

answered Jan 10 '12 at 17:14

Ivo

8,172
5
27
42

1

This is based on the fact that DateTime.Today will return the date with the time set to 00:00:00. – Ivo Jan 10 '12 at 17:15

Hogan · Answer 2 · 2012-01-10T18:43:08.597

0

You can use the C# standard library -- There is a time interval type (subtract one time from another, then get the absolute value of the number of days, like so:

List<Client> _cliente = from c in db.Cliente
                    join v in db.Vendedor
                    on c.IDVendedor equals v.IDVendedor
                    where Math.Abs((v.Fecha.Date - DateTime.Today).Days) <= 1

edited Jan 10 '12 at 18:43

answered Jan 10 '12 at 17:20

Hogan

69,564
10
76
117

I believe it should be `DateTime.Today` as above. – Hogan Jan 10 '12 at 18:43

Linq date and datetime comparer

2 Answers2