you need to call mapper.Generator(Generators.Identity) or something like
that.
On Saturday, January 4, 2014 12:54:29 PM UTC-7, Richard Jacobs wrote:
>
> I have been pulling my hair out on this for a couple of hours at least now.
>
> So I am using nhibernate to map my db to my code. In the DB I have table
> called "Product" which has a column called "ProductId" which is the primary
> key and also marked as an identity column in sql server 2012.
>
> My class' mapping with the Id columned defined as:
>
> Id(x => x.ProductId, mapper => mapper.UnsavedValue(0));
>
> However after creating a new Product object and trying to save it I get
> the following error and inner exception:
>
> {"could not execute batch command.[SQL: SQL not available]"}
>
> Cannot insert explicit value for identity column in table 'Products' when
> IDENTITY_INSERT is set to OFF.
>
> The exception is pretty clear and the product Id is set to 0. How do I
> tell nHibernate to not supply the Id column when creating a new object in
> the database?
>
> Any help greatly appreciated
>
> thanks
>
--
---
You received this message because you are subscribed to the Google Groups
"nhibernate-development" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
