Hi,
I must be missing something very important in the concept to get this
error so any help appreciated.
I get
----> System.Data.SqlClient.SqlException : Cannot update identity
column 'ProductID'.
when i run this
var tblEvent = session.Load<TblEvent>(17);
tblEvent.Code+= " - test update";
using (var tran = session.BeginTransaction())
{
session.SaveOrUpdate(tblEvent);
tran.Commit();
}
Heres the mapping file
<?xml version="1.0" encoding="utf-8"?>
<hibernate-mapping namespace="Amblique.Booking.BLL"
assembly="Amblique.Booking.BLL" xmlns="urn:nhibernate-mapping-2.2" >
<class name="TblProduct" table="tblProduct" schema="dbo">
<id name="_productID" access="field" column="ProductID"
type="Int32" >
<generator class="native" />
</id>
<property name="Active" type="Boolean" not-null="true" />
<property name="AllowBackOrder" type="Boolean" not-null="true" />
<property name="BuyY" type="Int32" precision="10" />
<property name="BuyYQty" type="Int32" precision="10" />
<property name="CategoryID" type="Int32" precision="10" />
<property name="Code" type="String" length="50" />
<property name="ColourID" type="Int32" precision="10" />
<property name="ColourNameOverride" type="String" length="250" />
<property name="Cost" type="Decimal" precision="10" not-
null="true" />
<property name="CreatedBy" type="Int32" precision="10" />
<property name="CreatedDate" type="DateTime" />
<property name="CustomSort1" type="Int32" precision="10" />
<property name="CustomSort2" type="Int32" precision="10" />
<property name="CustomSort3" type="Int32" precision="10" />
<property name="DefaultImageID" type="Int32" precision="10" />
<property name="Depth" type="Decimal" precision="10" not-
null="true" />
<property name="DispatchCategoryID" type="Int32" precision="10" />
<property name="DisplayIfNoStock" type="Boolean" not-null="true" /
>
<property name="GetXFree" type="Int32" precision="10" />
<property name="GetXPercentDiscount" type="Decimal" precision="6" /
>
<property name="Height" type="Decimal" precision="10" not-
null="true" />
<property name="IsFavourite" type="Boolean" not-null="true" />
<property name="IsFeatured" type="Boolean" not-null="true" />
<property name="IsInSite" type="Int32" precision="10" />
<property name="IsSpecial" type="Boolean" not-null="true" />
<property name="Keywords" type="String" length="250" />
<property name="LongDescription" length="2147483647" />
<property name="LongDescription2" length="2147483647" />
<property name="LongDescription3" length="2147483647" />
<property name="ManufacturerID" type="Int32" precision="10" />
<property name="Name" type="String" length="250" not-null="true" /
>
<property name="NoStockMessage" type="String" length="250" />
<property name="OrderRanking" type="Int32" precision="10" />
<property name="ParentID" type="Int32" precision="10" />
<property name="Price" type="Decimal" precision="10" not-
null="true" />
<property name="PriceMember" type="Decimal" precision="10" />
<property name="PriceRRP" type="Decimal" precision="10" />
<property name="PriceSpecial" type="Decimal" precision="10" />
<property name="PromotionID" type="Int32" precision="10" />
<property name="RefExt" type="String" length="250" />
<property name="SellBundledOnly" type="Boolean" />
<property name="Sex" type="Int32" precision="10" />
<property name="ShortDescription" type="String" length="500" not-
null="true" />
<property name="Size" type="String" length="50" />
<property name="SizeID" type="Int32" precision="10" />
<property name="SizeNameOverride" type="String" length="250" />
<property name="SizeUnit" type="String" length="10" />
<property name="SpecialEnd" type="DateTime" />
<property name="SpecialStart" type="DateTime" />
<property name="Status" type="Boolean" not-null="true" />
<property name="Stock" type="Int32" precision="10" not-
null="true" />
<property name="SupplierID" type="Int32" precision="10" />
<property name="TaxExempt" type="Boolean" not-null="true" />
<property name="UpdateBy" type="Int32" precision="10" />
<property name="UpdateDate" type="DateTime" />
<property name="WeightKG" type="Decimal" precision="10" not-
null="true" />
<property name="Width" type="Decimal" precision="10" not-
null="true" />
<many-to-one name="Parent" class="TblProduct" column="ProductID"
not-null="true" />
<bag name="TblProducts" table="tblProduct" inverse="true">
<key column="ProductID" />
<one-to-many class="TblProduct" />
</bag>
<joined-subclass name="TblEvent" table="tblEvent">
<key column="EventID" />
<property name="AttachmentFileURL" type="String" length="200" />
<property name="GLAccountNo" type="String" length="20" />
<property name="MultiDayEvent" type="Boolean" not-null="true" />
<property name="PromotionActive" type="Boolean" not-null="true"
/>
<property name="RequiresLogin" type="Boolean" not-null="true" />
<property name="TopLevelCategoryID" type="Int32" precision="10"
not-
null="true" />
<property name="TotalAllocation" type="Int32" precision="10"
not-
null="true" />
<bag name="TblSessionTemplates" table="tblSessionTemplate"
inverse="true">
<key column="EventID" />
<one-to-many class="TblSessionTemplate" />
</bag>
<bag name="TblSessions" table="tblSession" inverse="true">
<key column="EventID" />
<one-to-many class="TblSession" />
</bag>
</joined-subclass>
</class>
</hibernate-mapping>
--
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/nhusers?hl=en.
