Comments on Imagination over Knowledge: Where Do You Generate Primary Keys?

tag:blogger.com,1999:blog-8576997301211354999.post8638651617522334555..comments2008-10-29T22:07:08.331-04:00Comments on Imagination over Knowledge: Where Do You Generate Primary Keys?Jim Cookhttp://www.blogger.com/profile/18436478569516788060noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-8576997301211354999.post-59930563002374152252008-10-29T22:07:00.000-04:002008-10-29T22:07:00.000-04:00Typically, I leave primary key generate up to the ...Typically, I leave primary key generate up to the database - regardless of whether I'm using a GUID/UUID or an IDENTITY column. As far as I'm concerned, the only time to generate your PK before getting to the database is when you're doing some heavy duty distributed data storage and you're sending records to different servers based on some magic involving a checksum of the PK.Jeremiah Peschkahttp://facility9.comnoreply@blogger.com