How do I use IDENTITY columns

(Clipped from the mailing list)

For anyone else trying to figure this out:

change your table element in the schema as follows:

<table  ... idMethod="native" ...>

change the column element in the schema as follows:

<column ... autoIncrement="true" .../>

finally, to line 62 of \Neo.SqlGen\Resources\NeoSchemaGen.xslt add :

<if test="@autoIncrement = 'true'"> IDENTITY </if>

(It is the line that begins: <if test="@required = 'true'"> NOT</if> NULL – add it immediately after the NULL).

Thanks,
Jonathan Malek