Table without Idenity in SQLServer

I need to generate a table in SQL Server without identity, but Aurelius always generates the table with Identity(1,1).
What am I doing wrong ?
Thank you.
Walo

This is my entity definition

[Entity]
[Automapping]
[Model('TESTWALO')]
TEL_TestNoIdentity = class
[ID('FID', TNoneGenerator)]
[Table('EL_TestNoIdentity')]
private
FId : integer;
FKind: string;
FUsername: string;
public
property Id:integer read FId write FId;
property Kind:string read FKind write FKind;
property Username:string read FUsername write FUsername;
end;

This is then SQLServer script
CREATE TABLE [dbo].[EL_TEST_NO_IDENTITY](
[ID] [int] IDENTITY(1,1) NOT NULL,
[KIND] varchar NOT NULL,
[USERNAME] varchar NOT NULL,
CONSTRAINT [PK_EL_TEST_NO_IDENTITY] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

The Id and Table attributes are class attributes. You should put them before class declaration:

[Entity]
[Automapping]
[Model('TESTWALO')]
[ID('FID', TNoneGenerator)]
[Table('EL_TestNoIdentity')]
TEL_TestNoIdentity = class

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.