TableAdapter creates a conflict.

[Richard Coltrane]

Hello.

I have a table in a db with autoincrement on for the PK field. The table is
empty.

I have used the wizard to create a tableadapter from that table. I create a
bunch of records and put them into the dataset and call Update on the
tableadapter and i get a constraint error. Column xyz (PK) is constrained to
be unique.

The only way this problem can occur is if the tableadapter is trying to
write over the dataset PK with that from the DB.
Ive yet to see any documentation that i have to enforceConstraints = false;
etc before updating.

Any ideas why its breaking would be appreciated.

Thanks
Richard

 

[Miha Markic]

Set PK column as AutoIncrementSeed = -1 and Step = -1 (both negative
values).