Solved

ASPNETDB - Why the GUID?

Posted on 2008-06-11
10
631 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
  • 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
 
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
How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

 
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

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
MS SQL Backup 24 70
Access recordset not updateable 8 38
SQL Server 2012 Row Selection 2 29
BULK INSERT most recent CSV 19 17
Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
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.

708 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now