Simple way to compare Dates in DateTime attribute using Entity Framework 4 and Linq queries

Question

I'm trying to run the following bit of code, but the comparison fails by not handing my the entities I expect it to.

It's comparing 06/09/2011 0:00:00 to 06/09/2011 12:25:00, the latter being my databases record value. So that's why the comparison is failing and I'm not getting the records I need.

I'm just trying to compare if the dates match up, I'm don't care about the time.

DateTime today = DateTime.Now.Date;
var newAuctionsResults = repo.FindAllAuctions()
                        .Where(a => a.IsActive == true || a.StartTime.Value == today)
                        .ToList();

How can I compare only the dates?

If use the .Date property in the .StartTime.Value part, I get an exception:

The specified type member 'Date' is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported.

Maybe this question will help? LINQ | How do I perform Date Comparison in a Linq Query? stackoverflow.com/questions/1088212/… — Kyle
– Kyle, Commented Sep 6, 2011 at 13:31

Craig Stuntz · Accepted Answer · 2011-09-06 13:28:51Z

16

You can use the individual members:

var newAuctionsResults = repo.FindAllAuctions()
                        .Where(a => a.IsActive == true 
                                    || (a.StartTime.Value.Year == todayYear
                                        && a.StartTime.Value.Month == todayMonth
                                        && a.StartTime.Value.Day == todayDay))
                        .ToList();

...or use any of the other methods/properties supported in L2E.

answered Sep 6, 2011 at 13:28

Craig Stuntz

127k12 gold badges257 silver badges275 bronze badges

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

1 Comment

Usman Khalid Over a year ago

It is being used for equal operator. What if I need to check greater than and less than operator.

صفي · Accepted Answer · 2013-12-05 10:18:44Z

11

You can also use EntityFunctions.TruncateTime() under the namespace System.Data.Objects

Ex.

db.Orders.Where(i => EntityFunctions.TruncateTime(i.OrderFinishDate) == EntityFunctions.TruncateTime(dtBillDate) && i.Status == "B")

Works like charm.

answered Dec 5, 2013 at 10:18

صفي

1,0682 gold badges15 silver badges34 bronze badges

2 Comments

Hossein Shahdoost Over a year ago

How do you write UnitTests then?

Daniel Vygolov Over a year ago

EntityFunctions are now obsolete, use DbFunctions instead!

Yahia · Accepted Answer · 2011-09-06 13:27:12Z

-1

try

DateTime todayStart = DateTime.Now.Date;
DateTime todayEnd = DateTime.Now;
var newAuctionsResults = repo.FindAllAuctions()
                        .Where(a => a.IsActive == true || (a.StartTime.Value >= todayStart && a.StartTime.Value <= todayEnd))
                        .ToList();

answered Sep 6, 2011 at 13:27

Yahia

70.5k9 gold badges117 silver badges147 bronze badges

Comments

Mac · Accepted Answer · 2011-09-06 13:27:58Z

-2

You could convert using

DateTime.ToShortDateString()

http://msdn.microsoft.com/en-us/library/system.datetime.toshortdatestring.aspx

This would neglect the Time.

Then compare the two Strings.

if(string1 == string2)
{
 //Do Something
}

answered Sep 6, 2011 at 13:27

Mac

3922 gold badges8 silver badges26 bronze badges

1 Comment

Craig Stuntz Over a year ago

Not supported in L2E, I'm afraid.

Collectives™ on Stack Overflow

Simple way to compare Dates in DateTime attribute using Entity Framework 4 and Linq queries

4 Answers 4

1 Comment

2 Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

2 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related