hmmm....Im trying to narrow it down, because, I'm running the build from the trunk, and I'm using Jet driver (NHContrib) and Linq (also on contrib). My first insight is that it might be a Jet driver issue. I'll update once I find exactly where this happens.
On May 20, 5:49 pm, Fabio Maulo <[email protected]> wrote: > Where you having the problem ?Using NHibernate.Linq (on contrib), > CriteriaAPI direct, FNH ? > > 2009/5/20 Hadi Eskandari <[email protected]> > > > > > > > Hello, > > > I'm using NHibernate with Fluent API on a WPF application. Now I've > > localized my application, and set the UICulture and Culture of the > > running thread to my specific culture (fa-ir) to get the underlying > > functionalities know about the application's culture. Now when > > querying data with NHibernate, there is a problem when DateTime > > instances are being converted to string (by nhibernate criteria). It > > seems to me that, ToString representation of the date objects are > > irrelevant, and invariant culture should be used to convert dates to > > strings before passing the criteria to the execution engine: > > > this is wrong (Current) : var value = dateCriteria.ToString(); > > should be this : var value = dateCriteria.ToString > > (CultureInfo.Invariant); > > > anyone has this problem? How can I fix this, is this a bug, or there's > > something I'm missing here? Here's my query: > > > var todayStart = new DateTime(DateTime.Today.Year, > > DateTime.Today.Month, DateTime.Today.Day, 0, 0, 0, > > CultureHelper.DefaultCalendar); // Invariant Culture's calendar > > (gregorian) > > var todayEnd = new DateTime(DateTime.Today.Year, > > DateTime.Today.Month, DateTime.Today.Day, 23, 59, 59, > > CultureHelper.DefaultCalendar); // Invariant Culture's calendar > > (gregorian) > > > var queryable = UnitOfWork.CurrentSession.Linq<Purchase>(); > > var query = from sales in queryable > > where sales.PurchaseDate >= todayStart && > > sales.PurchaseDate <= todayEnd > > select sales; > > > queryable.Expand("Purchaser"); > > queryable.Expand("Product"); > > > return query.ToList(); > > -- > Fabio Maulo --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
