Table 1(Object 1)

ID Foreign_Key
---------------
1 1
2 NULL



Table 2(Object 2)

ID somefield
-------------
1 somevalue



ICriteria object1Criteria = session.CreateCriteria(typeof(Object1));
ICriteria object2Criteria = object1Criteria.CreateCriteria(Typeof(Object2));

object1Criteria.Add(Expression ID to be 1);

IList result = object1Criteria.List();

WORKS OK


ICriteria object1Criteria = session.CreateCriteria(typeof(Object1));
ICriteria object2Criteria = object1Criteria.CreateCriteria(Typeof(Object2));

object1Criteria.Add(Expression ID to be 2);

IList result = object1Criteria.List();

DOES NO WORK BECAUSE foreign key field is null and I have created criteria on that property.


I need to create criteria on every Object1 property (that is Object type).
How to tell object2Criteria that although Object2 is NULL the query should return Object1 with ID1.

What is the solution?

Thanks!

Or else, my problem will solve if you tell me, how to check if Disjunction or Conjunction is empty (no expressions added).

I am not an expert in the Criteria API but I think you can define the fetching strategy on the createCriteria method for object2. You will have to tell hibernate that you want to do a left outer join.

See here http://www.hibernate.org/hib_docs/v3/ap ... ing,%20int) for more explanations (use left_join in your case)

Can anyone tell me, how to set jointype in nhibernate 1.0.2.0 ?

There are several examples but there is no overload on CreateCriteria method that takes jointype as parameter in my nhibernate version.