NHibernate Linq

This Linq release support just about anything that you can do with the criteria API. It does not support group joins or subqueries in select clauses, since they aren’t supported by the criteria API.

Go to http://ayende.com/Blog/archive/2009/07/26/nhibernate-linq-1.0-released.aspx

See also these related projects.