Auto Incrementing Int ID ( primary key )?

[Seabus]

Hi,

I'm trying to build a table using the SCHEMA EXPLORER / ADD TABLE function ... This table should have a primary key that is an
INT  and it should be auto incrementing :-)
How do I do this ?!
There's  no clear way of doing this :-)
See the attached image.

Sebastian

[IT-Als]

Hi Sebastian,

As per my understanding, this table design becomes a class (you map a class to the table)... in doing so, you can tell (on the class level) that this property is the identity of the class and that it is backend calculated.
After that, when you update your database (from the class model) your table meta data will be changes to be autoinc int

Regards

Henrik

[Ivailo]

Hi,

First let me thank Henrik for the input - it is correct. The details for the resolution are the following:
1) Make the property an Identity as you have already done
2) Set the Identity Mechanism property of the Domain Class to DatabaseServerCalculated, as shown in this article.
3) After updating it to the database, it should be created as auto-incrementing primary key. 

Let us know if you need any clarifications or you have other questions.

All the best,
Ivailo
the Telerik team