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