Page 1 of 1
Filtering on Datepart
Posted: Fri 08 Jun 2012 17:12
by rashid.vu
Hi everybody, I'm unable to filter data on part of the date like month or year.
var students = from s in db.Students
where s.BirthDate.Value.Month == 8
select s;
is not working...
How to get it working? Thanks.
Re: Filtering on Datepart
Posted: Mon 11 Jun 2012 11:45
by Shalex
Are you working with Entity Framework?
We have reproduced the problem with LINQ to Entities. We will post here when the issue is fixed.
Re: Filtering on Datepart
Posted: Wed 20 Jun 2012 10:15
by Shalex
The bug with filtering on the DateTime column in LINQ to Entities is fixed. We will post here when the corresponding build of dotConnect for SQLite is available for download.
Re: Filtering on Datepart
Posted: Thu 21 Jun 2012 16:40
by Shalex
New build of dotConnect for SQLite 4.0.25 is available for download!
It can be downloaded from
http://www.devart.com/dotconnect/sqlite/download.html (trial version) or from Registered Users' Area (for users with active subscription only).
For more information, please refer to
http://forums.devart.com/viewtopic.php?f=29&t=24362.