Compare Dates using LINQ to Entities (Entity Framework)

Question

I need to return a list of items from my database that expire at a pre-specified time on the date supplied by the item. My erroneous code is as follows:

return All().Where(o => new DateTime(o.expiry_date.Year, o.expiry_date.Month, o.expiry_date.Day, 17, 30, 0) >= DateTime.Now)

The error I get is:

Only parameterless constructors and initializers are supported in LINQ to Entities

Does anyone know how I can fix this?

Can you not use expiry_date directly? .Where(o => o.expiry_date >= DateTime.Now). — Oded
– Oded, Commented Dec 6, 2012 at 10:19
It must incorporate the date specified by the item but use the pre-determined time, so unfortunately not. Even making an expiry_date2 property wouldnt work because you'd have to do a ToList() first. — Jimbo
– Jimbo, Commented Dec 6, 2012 at 10:28
Go through link bellow.. [Check Dates Only in LINQ][1] [1]: stackoverflow.com/a/24380028/1833050 — Imran Athar
– Imran Athar, Commented Jun 24, 2014 at 6:50

natenho · Accepted Answer · 2014-07-02 15:03:12Z

31

Use EntityFunctions instead. Maybe CreateDateTime method.

So maybe like this:

return All().Where(o => EntityFunctions.CreateDateTime(o.expiry_date.Year, o.expiry_date.Month, o.expiry_date.Day, 17, 30, 0) >= DateTime.Now)

Update:

When using EF6, use DbFunctions instead.

edited Jul 2, 2014 at 15:03

natenho

5,7015 gold badges35 silver badges57 bronze badges

answered Dec 6, 2012 at 10:19

Euphoric

12.9k1 gold badge35 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

natenho Over a year ago

Just for the record, EntityFunctions is deprecated in EF6, replaced by System.Data.Entity.DbFunctions.

Tasos K. · Accepted Answer · 2015-11-21 17:42:20Z

6

You can use:

var result = await db.Articles
          .Where(TruncateTime(x.DateCreated) >= EntityFunctions.TruncateTime(DateTime.Now))
          .ToListAsync();

edited Nov 21, 2015 at 17:42

Tasos K.

8,1057 gold badges44 silver badges68 bronze badges

answered Mar 24, 2015 at 9:01

Mostafa Marji

2459 silver badges19 bronze badges

Comments

petro.sidlovskyy · Accepted Answer · 2012-12-06 10:25:39Z

2

Please use:

return All().Where(o => EntityFunctions.CreateDateTime(o.expiry_date.Year, o.expiry_date.Month, o.expiry_date.Day, 17, 30, 0) >= DateTime.Now)

answered Dec 6, 2012 at 10:25

petro.sidlovskyy

5,1032 gold badges27 silver badges29 bronze badges

Collectives™ on Stack Overflow

Compare Dates using LINQ to Entities (Entity Framework)

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related