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