CreteriaExpressions using where and joins

Guest · **Posted:** Fri Dec 09, 2005 4:55 am

Hi,

There are no good samples available on the web related to CreteriaExpressions(similar to where conditions and joins on the multiple table in SQL).

Please suggest me few examples using ExpressionCreteria with where and joins on multiple persistence class.
Eg:
select a.Name, a.Addr , c.Workplace from Emp a, Contractor c
where a.Id=c.Id and a.Name Like 'An%'
order by a.Name

Thanks,
Suman

KPixel · **Posted:** Sat Dec 10, 2005 8:11 am

There are load of examples in NHibernate.Tests :wink:

Here is one (from NHibernate.Test\FooBarTest.cs):

Code:

IList list = s.CreateCriteria( typeof( Foo ) )
   .Add( Expression.Expression.Eq( "Integer", f.Integer ) )
   .Add( Expression.Expression.EqProperty( "Integer", "Integer" ) )
   .Add( Expression.Expression.Like( "String", f.String ) )
   .Add( Expression.Expression.In( "Boolean", new bool[ ] {f.Boolean, f.Boolean} ) )
   .SetFetchMode( "TheFoo", FetchMode.Eager )
   .SetFetchMode( "Baz", FetchMode.Lazy )
   .List();