Unable to compare DateTime in Dynamic Linq

Question

I'm using dynamic linq to build a query in runtime. I'm preparing the following command

var temp = list
    .AsQueryable()
    .Where("Date<DateTime(2014,10,22,21,05,56)")
    .Select("it");
return temp.Cast<T>().ToList();

The condition is not executing properly and i'm getting a wrong set of results. My filter condition is dynamic and i'll generate it only in run time. Can you help me in resolving this issue. Is there a Hour minute second comparison possible in dynamic linq?

`Date < new DateTime...` ? – Renatas M. Nov 21 '14 at 13:29 — Renatas M., Nov 21 '14 at 13:29
@krillgar the `<` here stands for "less than" – dcastro Nov 21 '14 at 13:37 — dcastro, Nov 21 '14 at 13:37

score 2 · Answer 1 · edited May 23 '17 at 12:16

2

Please refer this link

As per the information from that link

Note that constructor invocations are not prefixed by new. The following example creates a DateTime instance for a specfic year, month, and day using a constructor invocation:

orders.Where("OrderDate >= DateTime(2007, 1, 1)");

Only difference I can see there is it is taking only 3 arguments. The author may not have implemented the overloaded version. Try with three parameters, instead.

Credits

edited May 23 '17 at 12:16

Community

1
1

answered Nov 21 '14 at 13:58

Rama Kathare

920
9
29

My question is I cannot pass a parameter. I need to construct the datetime on my own. When downloaded the source I can't find their method which takes 3 parameters – arun thatham Nov 21 '14 at 19:35

score 1 · Answer 2 · answered Nov 21 '14 at 14:20

1

When I use the NuGet package I can execute your predicate alright. But I would use a parameter anyway:

var temp = list
    .AsQueryable()
    .Where("Date < @0", new DateTime(2014,10,22,21,05,56))
    .Select("it");
return temp.Cast<T>().ToList();

answered Nov 21 '14 at 14:20

Gert Arnold

105,341
31
202
291

Unable to compare DateTime in Dynamic Linq

2 Answers2