In our order entry application, when an order is created, the next available order number is taken from a field in a table. Then, the field is incremented by 1 for the next time this routine is called.

We want to use a SQL Server table within our .Net application to manage the next number field. However, how can we lock the table in our routine, while it's getting and incrementing the field, so that no other user can access the table. Then unlock the table when done.

We want to avoid two or more users getting the same next number order number from the table's field.

How can this be done?

Thanks,

Jerry