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 -~----------~----~----~----~------~----~------~--~---
