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