Hibernate version:
1.0.20 Beta
Mapping documents:
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.0" namespace="Devtoo.Data" assembly="Devtoo.Data">
<class name="Devtoo.Data.Article, Devtoo.Data" table="tblArticle" lazy="false">
<id name="ArticleId" column="ArticleId" unsaved-value="0">
<generator class="identity"></generator>
</id>
<property name="Title"></property>
<property name="SubmitDate"></property>
<property name="Body"></property>
<property name="AuthorId"></property>
<property name="Diggs"></property>
<many-to-one name="Author" class="Devtoo.Data.User" column="AuthorId" insert="false" update="false"></many-to-one>
<one-to-one name="ApprovedDate" foreign-key="ArticleId" class="Devtoo.Data.ArticleQueue"></one-to-one>
<list name="Comments" cascade="all-delete-orphan" generic="true" lazy="true">
<key column="ArticleId"></key>
<index column="CommentId"></index>
<one-to-many class="Devtoo.Data.ArticleComment, Devtoo.Data"></one-to-many>
</list>
</class>
</hibernate-mapping>
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.0" namespace="Devtoo.Data" assembly="Devtoo.Data">
<class name="Devtoo.Data.ArticleComment, Devtoo.Data" table="tblArticleComment" lazy="false">
<id name="CommentId" column="CommentId" unsaved-value="0" >
<generator class="identity" />
</id>
<property name="ArticleId"></property>
<property name="AuthorId"></property>
<property name="SubmitDate"></property>
<property name="Body"></property>
</class>
</hibernate-mapping>
Code between sessionFactory.openSession() and session.close():
Article article1 = (Article)session.Load(typeof(Article), 1);
Name and version of the database you are using:
MSSQL 2005
When I load the object article1.Comments it actually has 2 items in the IList<ArticleComment> property rather than just 1 ( I only have 1 row in the database) and the first index Comments[0] is null... How can I resolve this?
|