I use LINQ to NHibernate in my project and create test project with Sqlite in memory database file. However, I found for group and project with select (project) the SQL statement is translated to for example : cast(Min(OrderTime) as DateTime) as minDate from Orders group by UserId I find that cast function get date data stores in Sqlite data base ony Year Portion. for eample 3/24/2011 to 2011. Then make my test crash. I try to figure it out by checkout NHibernate svn and find if I can remove cast. Unfortunately, this project is so difficult for me to understand how it work.
Please could you help me to solve this problem or another way without remove cast. Lastly if it is convenient for you please explain me why NHibernate team put cast for select by grouping. I think without cast it should work. Thank you very much. -- 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.
