NHIbernate Query

Question

I Had Written a Query iN NHibernate as

var queryResult = CurrentSession.QueryOver().Where(r => r.StatusId == 1).JoinQueryOver(a => a.ActorList).Where(s=>s.IsActor==1).List().Distinct().ToList();

It Is Getting Records Where(s=>s.IsActor==0) also...

How can i get only IsActor==1 records...

Thanks in Advance

Chetan Ranpariya · Answer

Hi Chaitanya It's not clear about the tables and their structures and the datatypes of the columns of those table from your query. I assume that IsActor column is a NOT NULL BOOL column. If IsActor is a BOOL column then you might want to try comparing it to true and false instead of 0 and 1. I would also suggest to run the SQL profiler when NHibernet is running this query and identify the actual SQL query which is being run on the SQL Server from the profiler. Analyzing this query would help you understanding the reason behind this behavior. You might want to check the proper JOINS being applied on proper tables and columns. You can run that query on the local db and try modifying it to get the desired result and then make those change to your NHibernate code. Thanks and regards Chetan Ranpariya