Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

1.2.0 Beta 1


<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.0"
namespace="BCS.Communications.Data.Tables" assembly="BCS.Communications.Data">
<class name="Customer">
<id name ="CustomerId" column="CustomerId" type="int">
<generator class="native" />
</id>
<property name="CustomerName">
<column name="CustomerName" sql-type="NVARCHAR(MAX)"/>
</property>
<list name="Orders" cascade="all" fetch="join">
<key column="OrderId" foreign-key="fk_customer_order"/>
<index column="idx" type="byte"/>
<one-to-many class="CustomerOrder" />
</list>
</class>
</hibernate-mapping>

<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.0"
namespace="BCS.Communications.Data.Tables" assembly="BCS.Communications.Data">
<class name="CustomerOrder">
<id name ="OrderId" column="OrderId" type="int">
<generator class="native" />
</id>
<property name="OrderName">
<column name="OrderName" sql-type="NVARCHAR(MAX)"/>
</property>
<many-to-one name="CustomerId" class="Customer" column="CustomerId" foreign-key="fk_customer_order" />
</class>
</hibernate-mapping>


I'm having problems with the index created for using lists in the mapping files. I am using an IList in my entity class for customer orders. The problem is when you add a new customer order the idx index field in the database is set to null. The customerId field in CustomerOrder is set correctly but I can't seem to get the index field to initialize. The code I'm using to test this is below.


[/code]

You are adding the "new CutomerOrder" to your own list. The hibernate has no idea how to persist that object. I think you must add it to your Orders list to persist it. What do you do in your AddOrder method?

greetings
markov

Thanks for your reply. My AddOrder method looks like this is is contained in my Customer class

Yoo can try this in your customer mapping:

<bag name="Orders" inverse="true" cascade="all" fetch="join">
<key column="OrderId" foreign-key="fk_customer_order"/>
<one-to-many class="BCS.Communications.Data.Tables.CustomerOrder,BCS.Communications.Data" />
</bag>

At least I have defined it in my code like this. (maybe it is different for 1.2.0 version)

cheers

markov

Thanks that seems to of fixed the problem.

Rob