>>>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). It looks like this:
-(Disconnected)
Create a new record with a Guid.NewGuid() as key.
-(If you) commit
Backend has the same Guid key you created. There is nothing to query back.
Cetin