Entity Framework 6 GUID as primary key: Cannot insert the value NULL into column ‘Id’, table ‘FileStore’; column does not allow nulls

by

In addition to adding these attributes to your Id column:

[Key]
[DatabaseGenerated(DatabaseGeneratedOption.Identity)]
public Guid Id { get; set; }

in your migration you should change your CreateTable to add the defaultValueSQL property to your column i.e.:

Id = c.Guid(nullable: false, identity: true, defaultValueSql: "newsequentialid()"),

This will prevent you from having to manually touch your database which, as you pointed out in the comments, is something you want to avoid with Code First.

More Related Contents:

  1. Entity Framework Provider type could not be loaded?
  2. How to update record using Entity Framework 6?
  3. How to filter “Include” entities in entity framework?
  4. EF Code-First One-to-one relationship: Multiplicity is not valid in Role * in relationship
  5. Mapping composite keys using EF code first
  6. Setting unique Constraint with fluent API?
  7. Lazy Loading vs Eager Loading
  8. Entity Framework 6: audit/track changes
  9. Dynamic MySQL database connection for Entity Framework 6
  10. Entity Framework 6 Code First Custom Functions
  11. DbSet.Attach(entity) vs DbContext.Entry(entity).State = EntityState.Modified
  12. Problems using Entity Framework 6 and SQLite
  13. ‘datetime2’ error when using entity framework in VS 2010 .net 4.0
  14. Database.BeginTransaction vs Transactions.TransactionScope [duplicate]
  15. Save detached entity in Entity Framework 6
  16. Eager , Lazy and explicit loading in EF6
  17. Configure multiple database Entity Framework 6
  18. get date part only from datetime value using entity framework
  19. Entity Framework 6 transaction rollback
  20. Log Queries executed by Entity Framework DbContext
  21. How are people unit testing with Entity Framework 6, should you bother?
  22. Async PartialView causes “HttpServerUtility.Execute blocked…” exception
  23. How to group by DateTime.Date in EntityFramework
  24. How to use String property as primary key in Entity Framework
  25. How does the SQLite Entity Framework 6 provider handle Guids?
  26. How can set a default value constraint with Entity Framework 6 Code First?
  27. Why is .Contains slow? Most efficient way to get multiple entities by primary key?
  28. What is the right way to populate a DropDownList from a database?
  29. update-database: “A network-related or instance-specific error occurred while establishing a connection to SQL Server”
  30. How to set Identity Seed value in code-first?

Leave a Comment