I'm using SQL-CE driver and LINQ to NHibernate3.0 translates this
extension method:
                        .Where(v => v.DateCreatedEng.Year ==
DateTime.Now.Year &&
                                    v.DateCreatedEng.Month ==
DateTime.Now.Month &&
                                    v.DateCreatedEng.Day ==
DateTime.Now.Day)

to:
where  extract(year from visitor0_.DateCreatedEng) = 2011 /* @p0 */
       and extract(month from visitor0_.DateCreatedEng) = 1 /* @p1 */
       and extract(day from visitor0_.DateCreatedEng) = 12 /* @p2 */

Which is wrong and it should use the standard DATEPART function.

-- 
You received this message because you are subscribed to the Google Groups 
"nhusers" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/nhusers?hl=en.

Reply via email to