>Hi Borislav
>
>You realize you're hitting the backend/table 3 times? Once to grab the record, once to send the update and once to grab the new ID?
>
>That's the kind of thing DBAs complain about.
>
>By using GUID there are no extra round trips required to get new ids.
No, only two times, send insert command and grab newly created id for that record. I am not sure is DBAs will be most happy when I create a 36 bites GUID instead of 4 bites Integer. I will have 4 bites transfer when I ask about new Id, and 4 bites for every single records when I want some recordset, but if I use GUID I will have 32 more bites to transfer for every record in the same recordset, isn't it?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.