How to Specify Primary Key Name in EF-Code-First

by

If you want to specify the column name and override the property name, you can try the following:

Using Annotations

public class Job
{
    [Key, DatabaseGenerated(DatabaseGeneratedOption.Identity)]
    [Column("CustomIdName")]
    public Guid uuid { get; set; }
    public int active { get; set; }
}

Using Code First

    protected override void OnModelCreating(DbModelBuilder mb)
    {
        base.OnModelCreating(mb);

        mb.Entity<Job>()
            .HasKey(i => i.uuid);
        mb.Entity<Job>()
          .Property(i => i.uuid)
          .HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity)
          .HasColumnName("CustomIdName");
    }

Inside Migration Configuration

public partial class ChangePrimaryKey : DbMigration
{
    public override void Up()
    {
        Sql(@"exec sp_rename 'SchemaName.TableName.IndexName', 'New_IndexName', 'INDEX'");
    }

    public override void Down()
    {
        Sql(@"exec sp_rename 'SchemaName.TableName.New_IndexName', 'Old_IndexName', 'INDEX'");
    }
}

More Related Contents:

  1. Decimal precision and scale in EF Code First
  2. Ignoring a class property in Entity Framework 4.1 Code First
  3. How can I automatically filter out soft deleted entities with Entity Framework?
  4. How to disable cascade delete for link tables in EF code-first?
  5. EF 6 – How to correctly perform parallel queries
  6. Optimistic concurrency: IsConcurrencyToken and RowVersion
  7. Entity Framework: Duplicate Records in Many-to-Many relationship
  8. Should the order of LINQ query clauses affect Entity Framework performance?
  9. How can set a default value constraint with Entity Framework 6 Code First?
  10. What difference does .AsNoTracking() make?
  11. What is the purpose of self tracking entities?
  12. LINQ to Entities does not recognize the method ‘Double Parse(System.String)’ method, and this method cannot be translated into a store expression
  13. Why is .Contains slow? Most efficient way to get multiple entities by primary key?
  14. Entity framework very slow to load for first time after every compilation
  15. How can I lock a table on read, using Entity Framework?
  16. Entity Framework/Linq EXpression converting from string to int
  17. linq to entities doesn’t recognize a method
  18. Code to validate SQL Scripts
  19. How to convert an expression tree to a partial SQL query?
  20. Calculated column in EF Code First
  21. How can I disable model compatibility checking in Entity Framework 4.3?
  22. Could not load file or assembly Microsoft.Extensions.DependencyInjection.Abstractions, Version=1.1.0.0
  23. Set database timeout in Entity Framework
  24. .Include() vs .Load() performance in EntityFramework
  25. Dynamic query with OR conditions in Entity Framework
  26. Is there a .NET equivalent to SQL Server’s newsequentialid()
  27. Upload CSV file to SQL server
  28. “The operation is not valid for the state of the transaction” error and transaction scope
  29. The relationship could not be changed because one or more of the foreign-key properties is non nullable
  30. Repository Pattern, POCO, and Business Entities

Leave a Comment