Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
GuidCOMB
Message
From
25/05/2011 02:15:01
 
 
To
23/05/2011 16:38:52
General information
Forum:
ASP.NET
Category:
Other
Title:
Environment versions
Environment:
C# 4.0
OS:
Windows Server 2008
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01510431
Message ID:
01511703
Views:
61
Hi
Found solutions as below
            byte[] ticksAsBytes = BitConverter.GetBytes(DateTime.Now.Ticks);
            Array.Reverse(ticksAsBytes);
            int increment = Interlocked.Increment(ref guidCounter);
            byte[] currentAsBytes = BitConverter.GetBytes(increment);
            Array.Reverse(currentAsBytes);
            byte[] bytes = new byte[16];
            Array.Copy(ticksAsBytes, 0, bytes, 0, ticksAsBytes.Length);
            Array.Copy(currentAsBytes, 0, bytes, 12, currentAsBytes.Length);
            Array.Copy(GuidUtil.machineId, 0, bytes, 8, machineId.Length);

            //return bytes.TransfromToGuidWithProperSorting();

            return new Guid(bytes);
Source: http://ayende.com/blog/4643/createsequetialuuid-answer

But I didn't transform it using TransfromToGuidWithProperSorting() because found that it doesn't sorted actually by dump the generated guid to SQL table and added clustered index to the field.
I am not the most powerful man in this world.
I am not the worst man in this world either.
I just as same as all of you.
I still need to learn from my mistakes...
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform