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.
Filtering on Datepart
Re: Filtering on Datepart
Are you working with Entity Framework?
We have reproduced the problem with LINQ to Entities. We will post here when the issue is fixed.
We have reproduced the problem with LINQ to Entities. We will post here when the issue is fixed.
Re: Filtering on Datepart
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
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.
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.