>>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