Intersoft Community - Crosslight - Crosslight SQLite PrimaryKey AutoIncrement

Crosslight SQLite PrimaryKey AutoIncrement

yudi — Tue, 03 May 2016 04:35:35 GMT

... why do I have to set it to -100 (as in the data sqlite sample) in order to work properly? Is this by design or any other reason?
Setting it to -1 works as well. ...

Yes, you are correct. Setting it to -1 will works as well. To work with auto increment primary keys, we can use any negative number (less than 0). It is recommended to use -1.

We'll have the sample updated by applying default ItemId to -1.

Thank you very much for the feedback.

Crosslight SQLite PrimaryKey AutoIncrement

thomas.albert@tea-net.ch — Fri, 29 Apr 2016 10:31:21 GMT

Hello Crosslight Support,

I have a question about Crosslihgt SQLite and primary keys with auto increment.

If the primary key as an integer, why do I have to set it to -100 (as in the data sqlite sample) in order to work properly? Is this by design or any other reason?

Setting it to -1 works as well. But leaving it to 0 just saves the first entity and throws an exception when saving the second entity. Other ORMs like Entity Framework handle a 0 value without any problem.

Thanks for clarifying.

Thomas