Dynamic LINQ Compare Dates in Entity Framework

Question

I am using the dynamic linq library with entity framework and want to compare dates. I have succesfully extended the library based on the following SO article here However what I can not seem to do is to get the library to compare just the date portion of the DateTime property of my entity object as I would do with a normal linq expression.

What I am trying to do is have the dynamic linq create a lambda like this:

// Compare just dates
p => p.CreatedDate.Value.Date == '2012/08/01'

Rather than:

// Compares date + time
p => p.CreatedDate == '2012/08/01'

Any ideas on this would be much appreciated.

I had same issue & i was solving it almost 9 hrs. This post resolved my issue. Thanks. — Nikhil Chavan
– Nikhil Chavan, Commented Sep 23, 2013 at 13:59

luksan · Accepted Answer · 2013-07-11 14:44:02Z

4

The Dynamic Linq parser supports all public members of the System.DateTime type, including the Date property. So you could do something like

DateTime comparisonDate = new DateTime(2012, 8, 1);
var query = items.Where("CreatedDate.Value.Date == @0", comparisonDate);

UPDATE: If you are using Entity Framework this example will not work, since it does not support translating the DateTime.Date property into SQL. Normally you could use the EntityFunctions.TruncateTime() function to achieve the same effect, but this function is not accessible to the Dynamic Linq parser without modifications. However, you should be able to to do something similar to the following (haven't tested):

var query = items.Where("CreatedDate.Value.Year == @0.Year && CreatedDate.Value.Month == @0.Month && CreatedDate.Value.Day== @0.Day", comparisonDate);

edited Jul 11, 2013 at 14:44

answered Aug 28, 2012 at 21:26

luksan

7,8173 gold badges40 silver badges38 bronze badges

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

5 Comments

Cragly Over a year ago

I am actually passing in a filter expression (created higher up the app tier) to an IQuerable extension method which creates the Where clause ie 'CreatedDate == 2012/08/01'. Its possible that I could alter the expression in my MVC Controller to include the additional properties as you have highlighted in your example and see if that works. Apologies I should have explained in more detail but was trying to keep as much to the point as possible.

Cragly Over a year ago

Created the query expression further up the stack and worked like a charm. Thanks for the help.

CoderDennis Over a year ago

That gives me the error "The specified type member 'Date' is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported."

luksan Over a year ago

@CoderDennis, that is because Entity Framework for some reason does not support the Date property. I updated my answer with an explanation.

Nikhil Chavan Over a year ago

@luksan - Awesome, I was looking for this answer from 9 hrs. thanks

Collectives™ on Stack Overflow

Dynamic LINQ Compare Dates in Entity Framework

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related