Sequential GUID in Linq-to-Sql?

by

C# (safe) code (Compliments of the NHibernate Guid Comb Generator)

Guid GenerateComb()
{
    byte[] destinationArray = Guid.NewGuid().ToByteArray();
    DateTime time = new DateTime(0x76c, 1, 1);
    DateTime now = DateTime.Now;
    TimeSpan span = new TimeSpan(now.Ticks - time.Ticks);
    TimeSpan timeOfDay = now.TimeOfDay;
    byte[] bytes = BitConverter.GetBytes(span.Days);
    byte[] array = BitConverter.GetBytes((long) (timeOfDay.TotalMilliseconds / 3.333333));
    Array.Reverse(bytes);
    Array.Reverse(array);
    Array.Copy(bytes, bytes.Length - 2, destinationArray, destinationArray.Length - 6, 2);
    Array.Copy(array, array.Length - 4, destinationArray, destinationArray.Length - 4, 4);
    return new Guid(destinationArray);
}

A link to the source on github: https://github.com/nhibernate/nhibernate-core/blob/master/src/NHibernate/Id/GuidCombGenerator.cs

More Related Contents:

  1. Entity Framework vs LINQ to SQL
  2. LINQ: When to use SingleOrDefault vs. FirstOrDefault() with filtering criteria
  3. LINQ to SQL Left Outer Join
  4. NHibernate ISession Flush: Where and when to use it, and why?
  5. Referencing 2 different versions of log4net in the same solution
  6. How do I get the MAX row with a GROUP BY in LINQ query?
  7. How Random is System.Guid.NewGuid()?
  8. How Random is System.Guid.NewGuid()? (Take two)
  9. How can you do paging with NHibernate?
  10. The repository itself is not usually tested?
  11. How securely unguessable are GUIDs?
  12. Mapping collection of strings with NHibernate
  13. Why use LINQ Join on a simple one-many relationship?
  14. What is the string length of a GUID?
  15. Polymorphism: Is ORM entity a Domain Entity or Data Entity?
  16. How are .NET 4 GUIDs generated?
  17. How to use “contains” or “like” in a dynamic linq query?
  18. What can I do to resolve a “Row not found or changed” Exception in LINQ to SQL on a SQL Server Compact Edition Database?
  19. List, IList, IEnumerable, IQueryable, ICollection, which is most flexible return type?
  20. Guid Byte Order in .NET
  21. LinqToSql declare and instantiate DataContext best practice?
  22. What should be the lifetime of an NHibernate session?
  23. Do you think it’s advantageous to switch to Entity Framework? [closed]
  24. NHibernate: Reasons for overriding Equals and GetHashCode
  25. What is the best algorithm for overriding GetHashCode?
  26. How can I solve a connection pool problem between ASP.NET and SQL Server?
  27. Is string a value type or a reference type?
  28. What alternatives are there to ClickOnce? [closed]
  29. mscorlib.dll & System.dll
  30. .NET Standard vs .NET Core

Leave a Comment