tags:

views:

56

answers:

0
Q: 

Dynamic Linq to Entities...querying date fields

I am trying to use Linq to Entities with the Linq.Dynamic library (via Scott Guthrie) and I'm having some strange issues with querying dates.

var _date1 = DateTime.Now.AddDays(30).Date;
var _date2 = DateTime.Now.AddDays(31).Date;
var dateField = "DUEDATE";

docs = db.DOCUMENT.Where("@0 >= @1", dateField, _date1).Where("@0 <= @1", dateField, _date2);

This return no results, when it definitely should... it's simply a between statement to grab records for the specified day, but LinqToEntities doesn't like the combo. Any ideas??

related questions

Linq to Entities and concatenated properties
Entity framework: One big model or a set of smaller models?
LinqToEntities not retrieving child objects of an entity
Entity Framework & LINQ To SQL - Conflict of interest?
How do I put business logic in my ADO.NET Entity Framework classes?
How do I extend ADO.NET Entity Framework objects with partial classes?
How do I use LINQ to Entities in Visual Basic?
How to check for the presence of an OrderBy in a ObjectQuery<T> expression tree
Linq to Entities with WCF
Filter EntityDataSource on Association value
Persistence framework?
Entity framework and queries' SQL logging
Best Practices for Entity Framework and ASP.NET
Using Linq with WCF
Has anyone used lucene.net with Linq-to-Entities?
Is there a DataContext in LINQ-to-Entities (NOT Linq-to-SQL)?
SQL tracing LINQ to Entities
How to do a "where in values" in LINQ-to-Entities
Linq to Entity with multiple left outer joins
How to Implement Database Independence with Entity Framework
Why all the Linq To Entities Hate?
How to implement Repository pattern withe LinqToEntities?
Linq to Entities vs ESQL
Learning about LINQ
Expression.Invoke in Entity Framework?