Nhibernate linq where clause with boolean value

Question

If I try to add a where clause, containing a lambda filter on a boolean field, to a nhibernate linq query, the filter seems to be ignored:

var result = Session.Linq().Where(x=> x.Approved);

Session is an iSession and Newspaper is a simple object with the fields NewspaperId int, Name - varchar(50) and Approved - bit.

When I run this the following sql is generated:

SELECT this_.NewspaperId as Newspape1_33_0_, this_.Name as Name33_0_, this_.Approved as Approved33_0_, FROM Newspapers this_

it seems to ignore the lambda if it is for a boolean field. It works fine for the name field, ie:

var result = Session.Linq().Where(x=> x.Name == "The Times");

results in: exec sp_executesql N'SELECT this_.NewspaperId as Newspape1_33_0_, this_.Name as Name33_0_, this_.Approved as Approved33_0_ FROM Newspapers this_ WHERE this_.Name = @p0',N'@p0 nvarchar(9)',@p0=N'The Times'

Anybody know why I can't query on a boolean value?

Any help is greatly appreciated I am using NHibernate 2.1 with linq

YuriW · Accepted Answer · 2010-12-29 15:44:41Z

1

It's been a while so you've probably got your answer somewhere else a long time ago. But to answer your question: I can't see a reason why this wouldn't work. Actually I've tried it out in both NH2.1.2 and NH3.0.0. It works in both (verified by looking at the query with SQL Profiler). So it would be interesting to see the mapping you used, perhapse there's something wrong there.

answered Dec 29, 2010 at 15:44

YuriW

4295 silver badges6 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Nhibernate linq where clause with boolean value

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related