DevForce Community Forum : Guid vs Integer IDs http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : Community Forum : Guid vs Integer IDs Sat, 11 Apr 2026 11:54:46 -700 Fri, 11 Jan 2013 13:38:15 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=3882 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Guid vs Integer IDs : OK, thanks very much for your... http://www.ideablade.com/forum/forum_posts.asp?TID=3882&PID=15562#15562 Author: gregweb
Subject: 3882
Posted: 11-Jan-2013 at 1:38pm

OK, thanks very much for your insight!

Greg]]> Fri, 11 Jan 2013 13:38:15 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3882&PID=15562#15562 Guid vs Integer IDs : Yes, I have had issues with entity... http://www.ideablade.com/forum/forum_posts.asp?TID=3882&PID=15560#15560 Author: smi-mark
Subject: 3882
Posted: 11-Jan-2013 at 1:02pm

Yes, I have had issues with entity sandboxing and merging entities back that have been saved and such. The keyservice eliminated these issues.]]> Fri, 11 Jan 2013 13:02:43 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3882&PID=15560#15560 Guid vs Integer IDs : Yes, but have you actually had... http://www.ideablade.com/forum/forum_posts.asp?TID=3882&PID=15556#15556 Author: gregweb
Subject: 3882
Posted: 11-Jan-2013 at 9:55am

Yes, but have you actually had any issues with using an Identity column? I have used them in the past with db's that didn't have an identity column, but it seems the present incarnation of DevForce handles the id fixups just fine. I have never had any issues with it so am reluctant to change :)]]> Fri, 11 Jan 2013 09:55:34 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3882&PID=15556#15556 Guid vs Integer IDs : Greg,I've built a key service... http://www.ideablade.com/forum/forum_posts.asp?TID=3882&PID=15554#15554 Author: smi-mark
Subject: 3882
Posted: 11-Jan-2013 at 8:56am

Greg,

I've built a key service in my project that my factories use when creating an entity. It will call a method on the server and allocate an integer key, rather than using identity columns it will use a key table. SQL Server 2012 also offers sequences which would do something similar.  If I think I am going to be creating many entities in succession I can request a range of keys to use.

Something like that might help you if you don't want to use GUIDs.
]]> Fri, 11 Jan 2013 08:56:53 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3882&PID=15554#15554 Guid vs Integer IDs : OK, good points. Once thing I... http://www.ideablade.com/forum/forum_posts.asp?TID=3882&PID=15552#15552 Author: gregweb
Subject: 3882
Posted: 10-Jan-2013 at 4:40pm

OK, good points. Once thing I have seen to mitigate the second point is a field called RowGuid which is just a guid, but it doesn't get sent over the wire. I am already too deep in the project to change at this point, but at least I know the choices better.

Greg]]> Thu, 10 Jan 2013 16:40:55 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3882&PID=15552#15552 Guid vs Integer IDs : Database generated Ids violate... http://www.ideablade.com/forum/forum_posts.asp?TID=3882&PID=15551#15551 Author: mgood
Subject: 3882
Posted: 10-Jan-2013 at 4:28pm

Database generated Ids violate a fundamental principal of an entity, which says the identity of an entity should never change over its lifecycle. With store generated Ids, the entity gets a temporary id on the client until it is saved and it's identity changes at that point. You will find that to be a headache when building more complex applications. You can't uniquely identify an entity across contexts while it has a temporary id unless you define some sort of an additional business key.
 
In larger systems, Guids also allow for uniquely identityfing things across multiple data stores. That's a very common challenge in larger enterprise systems with multiple datasources.
 
]]> Thu, 10 Jan 2013 16:28:49 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3882&PID=15551#15551 Guid vs Integer IDs : One thing I notice that TempHire... http://www.ideablade.com/forum/forum_posts.asp?TID=3882&PID=15550#15550 Author: gregweb
Subject: 3882
Posted: 10-Jan-2013 at 3:53pm

One thing I notice that TempHire uses regularly is a Guid for the ID of an Entity as opposed to an int generated by SqlServer.

I have used both, but I tend to favor the int mainly due to the much smaller size, and thus, it's a lot faster to send over the wire.

For example, if you have a Contact with 10 phone numbers, the guids alone are the large part of sending the data over the wire. Multiply that by 100 contacts and the metadata is far larger then the actual data.

I do like the fact that a guid is generated on the client and so you don't have to requery after an initial save. But in my mine, the advantages of the integer key outweigh the advantages of the Guid.

Buy I am wondering if I am missing something as I see so many examples which stick to the Guid despite the larger size.

Greg

]]> Thu, 10 Jan 2013 15:53:02 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3882&PID=15550#15550