How to correctly query to Entity with nHibernate Component

Question

I have schema, with such mapping.

Next code don't work:

IList<User> userList = session.CreateCriteria<User>()
                              .Add(Restrictions.Eq("Login", login))
                              .List<User>();

Exception: System.InvalidCastException: Specified cast is not valid

Full stacktrace: link

Answer 1

Try this :

IList<User> userList = session.CreateCriteria(typeof(User))
         .Add(Restrictions.Eq("Login", login))
         .List<User>();

Answer 2

Bug in mapping:

<component name="UserRole">
  <property name="Role" column="role" not-null="true" type="System.String" />
</component>

should:

<component name="UserRole">
  <property name="Role" column="role" not-null="true" />
</component>