Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Manual assignment of Primary Key
Message
General information
Forum:
ASP.NET
Category:
The Mere Mortals .NET Framework
Miscellaneous
Thread ID:
00811534
Message ID:
00811598
Views:
9
How you get at the next primary key is a separate issue from MMF. Some developers us an ID table that contains the next id to use for each table. The table is locked while the next key is extracted to avoid any concurrency issues. If you find the next id from the actual table, you will need to manually deal with concurrency issues.

>If I use HookPreSave, does that mean I have to make a separate SQL call to retrieve the current highest primary key? Will I also have concurrency issue since someone else might be adding at the same time?
-----------------------------------------

Cathi Gero, CPA
Prenia Software & Consulting Services
Microsoft C# / .NET MVP
Mere Mortals for .NET MVP
cgero@prenia.com
www.prenia.com
Weblog: blogs.prenia.com/cathi
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform