How to use Sequence to generate primary key

[Nieuwsma]

I'm using dotConnect's LINQ. Our postgres db uses sequences to generate unique primary integer keys. How do I get the nextval from a sequence? I cannot use ExecuteCommand since it doesn't return the new value. Please provide an example.
Thanks for your help.

[AndreyR]

Here is a simple way:
1. Create a trigger in DB that will be populating the autoincrement field.
2. Set Auto Generated Value to true for the autoincrement PK column.
3. Set the AutoSync property to the OnInsert.
This will do the trick - the PK values will be populated after inserting.

[Nieuwsma]

Thanks for the response, AndreyR.

We have other code that uses ODBC to work with the database. It would all need to be changed to use the trigger. Is there a way to use sequences without changing the database?

[AndreyR]

Try defining the column in the following way:

Code: Select all

id integer DEFAULT nextval('autoinc_seq'::regclass)

Set the properties like I have described in the previous post, this should help.
Please let me know if anything goes wrong.