Solved

ASPNETDB - Why the GUID?

Posted on 2008-06-11
10
638 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
Business Impact of IT Communications

What are the business impacts of how well businesses communicate during an IT incident? Targeting, speed, and transparency all matter. Find out more in this infographic.

 
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

Why You Need a DevOps Toolchain

IT needs to deliver services with more agility and velocity. IT must roll out application features and innovations faster to keep up with customer demands, which is where a DevOps toolchain steps in. View the infographic to see why you need a DevOps toolchain.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
how to solve "recursive" database tables 2 55
semaphore timeout period has expired 1 31
Search Text in Views 2 28
Restore a log backup compressed 3 16
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

734 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