Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sequence GUID
Message
From
07/05/2009 13:16:06
Mike Yearwood
Toronto, Ontario, Canada
 
 
To
07/05/2009 12:24:10
General information
Forum:
ASP.NET
Category:
Coding, syntax and commands
Title:
Environment versions
Environment:
C# 3.0
OS:
Windows Server 2008
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01398391
Message ID:
01398409
Views:
74
>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().
Previous
Reply
Map
View

Click here to load this message in the networking platform