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

Question

I'm using Entity Framework Codefirst to create my Database. The default Primary key with the schema name dbo.pk_Jobs seems to upset access 2007 when I connect to it over ODBC. If I manually edit the name and remove the schema name and rename this Primary Key to pk_jobs, Access can now read the table.

Can I specify the Primary Key name to not include the name of the schema using Fluent Api, Data Attributes or any other method.

public class ReportsContext : DbContext {     public DbSet<Job> Jobs { get; set; }     protected override void OnModelCreating(DbModelBuilder modelBuilder)     {         modelBuilder.Entity<Job>().ToTable("Jobs");         modelBuilder.Entity<Job>().HasKey(j => j.uuid);          base.OnModelCreating(modelBuilder);     } } public class Job {     public Guid uuid{ get; set; }     public int active{ get; set; } } 

Answer 1

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'");     } }