Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Sequence GUID
Message
De
07/05/2009 13:16:06
Mike Yearwood
Toronto, Ontario, Canada
 
 
À
07/05/2009 12:24:10
Information générale
Forum:
ASP.NET
Catégorie:
Code, syntaxe and commandes
Titre:
Versions des environnements
Environment:
C# 3.0
OS:
Windows Server 2008
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01398391
Message ID:
01398409
Vues:
77
>GUID is random by nature. You can't "sequence" it. Use a identity field (int) if you need a sequencing PK.

A GUID is assumed to be random by many. Randomness is not required by the definition.

>
>>I am looking for SQL Server 2005 NewSequentialID() equivalent function in C#. I want it because I am using GUID as PK. I am planning to set my PK as clustered index, however, Guid.NewGuid() is generated randomly which is not good for clustered index, Therefore, would like to know if any C# function can do the same thing with NewSequentialID().
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform