This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Hi, Is there anyway to turn off IDENTITY generation on LightSpeed? Because the database server generate it for me, and everytime LightSpeed try to save new Entity it always gives this error "Cannot insert explicit value for identity column in table 'xxxxx' when IDENTITY_INSERT is set to OFF." FYI,I'm using GUID as identity |
|
|
|
|
It sounds like you may have a mismatch between your database schema and your model. You are using an identity column in the database which will be of an integer data type but you have specified a Guid as your identity data type in the model. You will need to alter one of these to match the other. If you need to switch your model you will want to switch the identity data type to match your schema and then use Identity as your identity generation method.
|
|
|
|
|
I figured it out, there is actually a 2nd identity (int) in the table. Setting that identity column to Load Only fixed the problem. |
|
|
|
