We are using NH Linq for the following query:

return ScreensRepo.Find(x => x.Screen.IsVisible == true).Select(x => x.Screen);

Because we are using a legacy DB, the IsVisible field is a T/F value, which 
has been mapped as a TrueFalseType as mapping level.

Rather than the above query generating sql to compare to a T or an F, it is 
generating a Case statement to check things.

Case section of SQL statement

case when screenenti2_.s_visible='T' then t else f end=case when ?=t then t 
else f end

Any ideas where I'm going wrong?

-- 
You received this message because you are subscribed to the Google Groups 
"nhusers" group.
To view this discussion on the web visit 
https://groups.google.com/d/msg/nhusers/-/vAoexWNBNTUJ.
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.

Reply via email to