I found the answer:
Id(x => x.ProductId
, mapper =>
{
mapper.UnsavedValue(0)
mapper.Generator(Generators.Native)
..
});
So very happy now ! :-)
On Saturday, January 4, 2014 10:09:13 PM UTC, Darren Kopp wrote:
>
> 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.
