Thanks, it really helped me alot :)
By the way. There is quite interesting issue with writing simple
queries. When I attach "true" to the property in NHLQ Where clause I
get strange SQL generated:
When there is
this.Session.Query<Product>()
.Where(x => x.Discontinued)
.ToList();
it produces select statement given below:
select ...
from Products product0_
where product0_.Discontinued = 1
, but when I use:
this.Session.Query<Product>()
.Where(x => x.Discontinued == true)
.ToList();
is gives:
select ...
from Products product0_
where case
when product0_.Discontinued = 1 then 'true'
else 'false'
end = case
when 'True' /* @p0 */ = 'true' then 'true'
else 'false'
end
Isn't that quite strange behaviour ?
--
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.
