Mike Yearwood
Toronto, Ontario, Canada
General information
Category:
Coding, syntax and commands
Environment versions
Network:
Windows 2008 Server
>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only