GUID COMB strategy in EF

by

Why worry about defaults for Guid columns in the database at all? Why not just generate the Guid on the client like any other value. That requires you have a method in your client code that will generate COMB-like guids:

public static Guid NewGuid()
{
    var guidBinary = new byte[16];
    Array.Copy( Guid.NewGuid().ToByteArray(), 0, guidBinary, 0, 8 );
    Array.Copy( BitConverter.GetBytes( DateTime.Now.Ticks ), 0, guidBinary, 8, 8 );
    return new Guid( guidBinary );
}

One of the advantages of the Guid is specifically that you can generate them on the client without a round trip to the database.

More Related Contents:

  1. Mapping Database Views to EF 5.0 Code First w/Migrations
  2. Enable Migrations with Context in Separate Assembly?
  3. EF migration for changing data type of columns
  4. Seed Entities AND Users, Roles?
  5. Migrations in Entity Framework in a collaborative environment
  6. Entity Framework change connection at runtime
  7. Entity Framework Provider type could not be loaded?
  8. Entity Framework Refresh context? [closed]
  9. EntityType has no key defined error
  10. Validation failed for one or more entities while saving changes to SQL Server Database using Entity Framework
  11. LEFT JOIN in LINQ to entities?
  12. Entity Framework 6 GUID as primary key: Cannot insert the value NULL into column ‘Id’, table ‘FileStore’; column does not allow nulls
  13. Insert data using Entity Framework model
  14. Entity Framework (.NET Full Framework) Ordering Includes [duplicate]
  15. How to compare only date components from DateTime in EF?
  16. Entity Framework 6 Code First Custom Functions
  17. Entity Framework Filter “Expression”
  18. How to get property change notifications with EF 4.x DbContext generator
  19. Can you create sql views / stored procedure using Entity Framework 4.1 Code first approach
  20. Entity Framework – stored procedure return value
  21. Order by dynamic parameter
  22. Self-referencing many-to-many recursive relationship code first Entity Framework
  23. Setting the default value of a DateTime Property to DateTime.Now inside the System.ComponentModel Default Value Attrbute
  24. How to Identify the primary key duplication from a SQL Server 2008 error code?
  25. Unable to find the requested .Net Framework Data Provider. It may not be installed
  26. How to create custom additional fields in UserProfile in MVC4
  27. Entity Framework Code First naming conventions – back to plural table names?
  28. Should the order of LINQ query clauses affect Entity Framework performance?
  29. How can set a default value constraint with Entity Framework 6 Code First?
  30. Why Entity Framework performs faster than Dapper in direct select statement [closed]

Leave a Comment