>>>>>>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
>
>ROFL. With all those gt signs it looks like I missed it completely and I was defending your idea against you:) Great.
LOL, I did wonder that.
Kev