Добрый день!
Сообственно где у меня ошибка.
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2"
namespace="StatesIF.Mappings" assembly="StatesIF">
<class name="UsersList" table="ADMIN.ADM_USERS_LIST">
<id name="UserId">
<column name="USER_ID" sql-type="Guid" not-null="true"/>
<generator class="identity"/>
</id>
<property name="UserCode">
<column name="USER_CODE" not-null="true" />
</property>
<property name="Password">
<column name="PASSWORD" not-null="true" />
</property>
<property name="Reason">
<column name="REASON" not-null="true" />
</property>
<property name="DateBegin">
<column name="DATE_BEGIN" not-null="true" />
</property>
<property name="DateEnd">
<column name="DATE_END"/>
</property>
<property name="Description">
<column name="DESCRIPTION"/>
</property>
<bag name="Roles" table="ADMIN.ADM_ROLES_USER" inverse="true" lazy="true">
<key column="UserId"></key>
<one-to-many class="UsersList"/>
</bag>
</class>
</hibernate-mapping>
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2"
namespace="StatesIF.Mappings" assembly="StatesIF">
<class name="RolesUser" table="ADMIN.ADM_ROLES_USER">
<id name="RolesUserId">
<column name="ROLES_USER_ID" sql-type="Guid" not-null="true"/>
<generator class="identity"/>
</id>
<property name="DateBegin">
<column name="DATE_BEGIN"/>
</property>
<property name="DateEnd">
<column name="DATE_END"/>
</property>
<property name="Description">
<column name="DESCRIPTION"/>
</property>
<property name="UserId">
<column name="USER_ID" not-null="true"/>
</property>
<property name="RoleId">
<column name="ROLE_ID" not-null="true"/>
</property>
</class>
</hibernate-mapping>
сами cs
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
public class RolesList {
public virtual Guid RoleId { get; set; }
public virtual string Name { get; set; }
public virtual DateTime DateBegin { get; set; }
public virtual DateTime? DateEnd { get; set; }
public virtual string Description { get; set; }
}
public class UsersList{
public virtual Guid UserId { get; set; }
public virtual string UserCode { get; set; }
public virtual string Password { get; set; }
public virtual string Reason { get; set; }
public virtual DateTime DateBegin { get; set; }
public virtual DateTime? DateEnd { get; set; }
public virtual string Description { get; set; }
private System.Collections.Generic.IList<RolesUser> _roles;
public virtual System.Collections.Generic.IList<RolesUser> Roles
{
get { return _roles; }
set { _roles = value; }
}
}
сессия создается все нормально, но при получении Roles выдается ошибка следующего характера
base {NHibernate.ADOException} = {"could not initialize a collection: [StatesIF.Mappings.UsersList.Roles#5b9857f7-2934-46e4-a598-2dc36ef2d7c5][SQL: SELECT roles0_.UserId as UserId1_, roles0_.USER_ID as USER1_1_, roles0_.USER_ID as USER1_7_0_, roles0_.USER_CODE as USER2_7_0_, roles0_.PASSWO...
Подскажите пожалуйста как исправить такое исправить.
Спасибо
С Уважением,Александр!
