Sorry for the bad name, I can't think of a good name for it.

I've the following scenario:

create table users(id int, name varchar, typeId int)
create table usersTypes(id int, desc varchar)

I want my User object to have:

public string Type { get; set; }

I know how to do it in SQL, but how do I setup the mapping so NH would do it for me?

<many-to-one>