Thanks guys, Will look into it more tomorrow, appreciate all the quick help. Maybe it is something completely different as your and mine query seem to generate the same date format.
-Mark On Thu, May 28, 2009 at 9:41 PM, Tuna Toksoz <[email protected]> wrote: > The trunk and very early revisions of linq trunk worked in that way, I > believe. > > Tuna Toksöz > Eternal sunshine of the open source mind. > > http://devlicio.us/blogs/tuna_toksoz > http://tunatoksoz.com > http://twitter.com/tehlike > > > > > On Thu, May 28, 2009 at 10:36 PM, Mark Nijhof <[email protected]> wrote: >> >> What version should we use? >> >> On Thu, May 28, 2009 at 9:29 PM, Tuna Toksoz <[email protected]> wrote: >> > >> > NHibernate: SELECT this_.EmployeeID as EmployeeID17_0_, this_.Address as Address17_0_, this_.BirthDate as BirthDate17_0_, this_.City as City17_0_, this_.Country as Country17_0_, >> > >> > this_.Extension as Extension17_0_, this_.FirstName as FirstName17_0_, this_.HireDate as HireDate17_0_, this_.HomePhone as HomePhone17_0_, this_.LastName as LastName17_0_, >> > >> > this_.Notes as Notes17_0_, this_.Photo as Photo17_0_, this_.PhotoPath as PhotoPath17_0_, this_.PostalCode as PostalCode17_0_, this_.Region as Region17_0_, this_.Title as Title17_0_, >> > >> > this_.TitleOfCourtesy as TitleOf17_17_0_ FROM Employees this_ WHERE this_.HireDate >=...@p0;�...@p0 = '1/1/1994 12:00:00 AM' >> > >> > What I get when I run >> > >> > [Category("WHERE")] >> > [Test(Description = "This sample uses WHERE to filter for >> > Employees >> > hired during or after 1994.")] >> > public void DLinq2() >> > { >> > var q = >> > from e in db.Employees >> > where e.HireDate >= new DateTime(1994, 1, 1) >> > select e; >> > AssertByIds(q, new[] { 7, 8, 9 }, x => x.EmployeeID); >> > } >> > >> > in tests. >> > >> > >> > >> > >> > Tuna Toksöz >> > Eternal sunshine of the open source mind. >> > >> > http://devlicio.us/blogs/tuna_toksoz >> > http://tunatoksoz.com >> > http://twitter.com/tehlike >> > >> > >> > >> > >> > On Thu, May 28, 2009 at 10:27 PM, Tuna Toksoz <[email protected]> wrote: >> >> >> >> Really? hmm, I'll check >> >> >> >> Tuna Toksöz >> >> Eternal sunshine of the open source mind. >> >> >> >> http://devlicio.us/blogs/tuna_toksoz >> >> http://tunatoksoz.com >> >> http://twitter.com/tehlike >> >> >> >> >> >> >> >> >> >> On Thu, May 28, 2009 at 10:20 PM, Mark Nijhof <[email protected]> >> >> wrote: >> >>> >> >>> Hi Fabio, >> >>> >> >>> Looks like it is NH.Linq that does the ToString(): >> >>> >> >>> from >> >>> t in NhibSessionHelper.GetSession().Linq<ExternalSystemStatusInfo>() >> >>> where t.FromDate > req.FromDate && >> >>> (t.ToDate < req.ToDate.Value || t.ToDate == null) && >> >>> (t.ExternalSystem.Code == req.Code) >> >>> orderby t.FromDate >> >>> select t >> >>> >> >>> What would be a sugested way to solve this? >> >>> >> >>> -Mark >> >>> >> >>> On Thu, May 28, 2009 at 9:04 PM, Fabio Maulo <[email protected]> >> >>> wrote: >> >>> > as you can see something/somebody is injecting strings instead use >> >>> > parameters; that is the problem. >> >>> > >> >>> > 2009/5/28 Mark Nijhof <[email protected]> >> >>> >> >> >>> >> Hi Fabio, >> >>> >> >> >>> >> SELECT >> >>> >> this_.Id as Id37_1_, >> >>> >> this_.FromDate as FromDate37_1_, >> >>> >> this_.ToDate as ToDate37_1_, >> >>> >> this_.Comment as Comment37_1_, >> >>> >> this_.CustomerInfo as Customer5_37_1_, >> >>> >> externalsy1_.Id as Id12_0_, >> >>> >> externalsy1_.Code as Code12_0_, >> >>> >> externalsy1_.Description as Descript3_12_0_ >> >>> >> FROM AuditLogDb.dbo.ExternalSystemStatusInfo this_ >> >>> >> left outer join AuditLogDb.dbo.ExternalSystem externalsy1_ >> >>> >> on this_.Id=externalsy1_.Id >> >>> >> WHERE >> >>> >> ((this_.FromDate > '27.04.2009 15:06:21' >> >>> >> and (this_.ToDate < '27.06.2009 15:06:21' or this_.ToDate is >> >>> >> null)) >> >>> >> and externalsy1_.Code = 'TrustIdent') >> >>> >> ORDER BY this_.FromDate asc; >> >>> >> >> >>> >> Both dates comes from properties on the entity. >> >>> >> >> >>> >> Thanks for helping out, >> >>> >> >> >>> >> -Mark >> >>> >> >> >>> >> On Thu, May 28, 2009 at 8:23 PM, Fabio Maulo <[email protected]> >> >>> >> wrote: >> >>> >> > 2009/5/28 Mark Nijhof <[email protected]> >> >>> >> >> >> >>> >> >> Sorry that only applies to the mappings of course. We are using >> >>> >> >> Linq >> >>> >> >> to access the data and regular save for saving. >> >>> >> > >> >>> >> > can you send the SQL log ? >> >>> >> > -- >> >>> >> > Fabio Maulo >> >>> >> > >> >>> >> > > >> >>> >> > >> >>> >> >> >>> >> >> >>> > >> >>> > >> >>> > >> >>> > -- >> >>> > 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 -~----------~----~----~----~------~----~------~--~---
