Solved

ASPNETDB - Why the GUID?

Posted on 2008-06-11
10
639 Views
Last Modified: 2013-11-07
The ASPNET team chose to use GUIDS as identifiers in the ASPNETDB schema. Can anyone tell me why? All of the other information I can find seems to indicate that they would have been better off using integers.

Thanks,
DAvid
0
Comment
Question by:anyoneis
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
  • 2
10 Comments
 
LVL 53

Accepted Solution

by:
Dhaest earned 500 total points
ID: 21768044
Primary Keys: IDs versus GUIDs
http://www.codinghorror.com/blog/archives/000817.html

Primary Key best practices: INT identity vs. UniqueIdentifier (GUID)
http://blogs.x2line.com/al/archive/2005/09/02/1233.aspx

A GUID (global unique identifier) is a term used by Microsoft for a number that its programming generates to create a unique identity for an entity such as a Word document. GUIDs are widely used in Microsoft products to identify interfaces, replica sets, records, and other objects. Different kinds of objects have different kinds of GUIDs - for instance, a Microsoft Access database uses a 16-byte field to establish a unique identifier for replication.
0
 
LVL 11

Author Comment

by:anyoneis
ID: 21823900
Dhaest;

Those are decent links, I especially appreciated the first. However, they don't shed any light (for me) on the reasons behind the dsign choices made in ASPNETDB.

I would like to leave this question open for a bit to see if anyone can explain the choice the ASPNET team made.

Thanks,
David
0
 
LVL 40

Expert Comment

by:Vadim Rapp
ID: 21824499
anyoneis, this is re. http:q_23499594.html - until someone responded, you should have a button "delete my question". I'm posting here because if I comment there, that button will disappear.
0
[Live Webinar] The Cloud Skills Gap

As Cloud technologies come of age, business leaders grapple with the impact it has on their team's skills and the gap associated with the use of a cloud platform.

Join experts from 451 Research and Concerto Cloud Services on July 27th where we will examine fact and fiction.

 
LVL 11

Author Comment

by:anyoneis
ID: 21828078
Thank you, vadimrapp1. Done.
0
 
LVL 53

Expert Comment

by:Dhaest
ID: 21830073
>> I would like to leave this question open for a bit to see if anyone can explain the choice the ASPNET team made.

What do you mean ? Why your team in the company choose for guid or why the microsoft developers of visual studio choose for the guid ?
0
 
LVL 40

Expert Comment

by:Vadim Rapp
ID: 21830659
> The ASPNET team chose to use GUIDS as identifiers in the ASPNETDB schema. Can anyone tell me why?

I would do this: since now everybody maintains a blog, I would try to find the blog belonging to someone from ASPNET team, and asked there.

If they don't reply, and I _really_, _really_ want to know, then I would fetched someone's relevant name from the said blog, or from some google search, called 1-800-MICROSOFT, told the voice system to connect to the target, and once connected, asked how come that his team chose to use GUIDS as identifiers.
0
 
LVL 11

Author Comment

by:anyoneis
ID: 21862760
Dhaest;

Most if not all of the references you provided, and that I dug up on my own, would seem to indicate that the "correct" choice for the ASPNETDB schema would have been Identity columns rather than GUIDS. Yet, the team chose the latter. I'm trying to figure out why.

vadimrapp1;

That's a reasonable idea. I'll see what I can find.
0
 
LVL 53

Expert Comment

by:Dhaest
ID: 21862936
>> ASPNETDB schema would have been Identity columns rather than GUIDS

We work here always with the GUID, so that we don't need to generate autonumbers on sql-server. We can than pass the objectID's to all the procedures, screens, ....
0
 
LVL 11

Author Comment

by:anyoneis
ID: 21934751
All of the references here are generic, "GUID versus Identity". There's good stuff here, but nobody seems to know why the ASP.net team made the choice they did. I'm closing this one out and awarding partial points to Dhaest.
0
 
LVL 11

Author Closing Comment

by:anyoneis
ID: 31466424
Thanks for the links, Dhaest!
0

Featured Post

[Live Webinar] The Cloud Skills Gap

As Cloud technologies come of age, business leaders grapple with the impact it has on their team's skills and the gap associated with the use of a cloud platform.

Join experts from 451 Research and Concerto Cloud Services on July 27th where we will examine fact and fiction.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question