Hello.

I have two tables: Requests and Users.

Table Request:
- Id
- Text
- UserId

Table User
- Id
- Name


So the map-file of Request contains the string


Now I need to get all Requests where Usert = null or User.Name = ''

How can I do this by using the Criteria?

If I write this:

I send so exception: could not resolve property: User.Name of: Request

If I add the Alias:

This code generate INNER JOIN with Users table, and Request with null-user is absent in selection.

Please, help.

You need to create another criteria in the chain:

session.CreateCriteria.(typeof(Request)).CreateCriteria("User").Add(Expression.Eq(...)))

Thank you for your answer, but it is not the solution.
The code like geterate INNER JOIN with User table, so Requests with NULL user have not a place in selection.

There is a CreateCriteria/CreateAlias overload which takes JoinType as a parameter, use that. I'm not sure if it's present in Beta2, it was added recently.

Thanks for good news! It's a pity that it isn't present Beta 2. We'll expect Beta 3 ;)

For now, maybe you can use a union in HQL?