>>>>Don't auto-generate the keys, I don't know if someone's already mentioned this but use Guids in .Net.
>>>>
>>>>ie: (c#)
>>>>
>>>>
>>>>Guid id = Guid.NewGuid();
>>>>
>>>>
>>>>Auto-incrementing keys is a bad idea, your guids will be unique and you'll have the primary key to hand at all times.
>>>
>>>I don't have any problem with that at all. Everything is done at the framework level so there is no code to manage that at the client's applicatioan.
>>
>>I'm not sure what you mean, didn't you have a requirement to know the primary key of the record you just created?
>>
>>Kev
>
>No because with a Guid key you already know it before committing to backend (and might never commit if you wish)
The subject says "getting primary key after insert", all I was saying is that if the PK is generated by the caller you wouldn't need to get the PK back from the command.
Now I'm totally confused lol - I haven't had enough coffee today, clearly ;-)
Kev