This should be a no brainer, but man oh man this thing is beating me up it makes no sense at all to me....

I have a count query to count how many records have a particular typeid there are 6 records I know are int there...

The query generated is select COUNT(*) as x0_0_ from Entities entitybase0_ where ((typeID=@p0 )); @p0 = '14'

if i run this exact query in SQL as select COUNT(*) as x0_0_ from Entities entitybase0_ where ((typeID=14 )); I get a result of 6 or that would be typeID=14 or typeID ='14' either gives me a result of 6, however NHibernate returns 0...what am i missing here? every other count query i've done works fine but they are all with strings so this has to be something I'm not accounting for with Integers.

Please any help would be fabulous.