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

.net c# ef-code-first entity-framework sql-server

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; }
}
1
29
11/28/2012 2:36:43 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

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'");
    }
}
58
11/29/2012 10:17:16 AM

Popular Answer

You can use the Key attribute to specify the parts of the primary key. So your Job class might be

public class Job
{
    [Key]
    public Guid uuid{ get; set; }
    public int active{ get; set; }
}

The data annotation attributes are defined in the System.ComponentModel.DataAnnotations namespace

Chris Dunaway

Related Questions

Influencing foreign key column naming in EF code first (CTP5)

I have a POCO class that has two one-way unary relationships with another class, both classes share an ancestor. The names of the foreign keys in the generated schema do not reflect the property names. (Properties MainContact and FinancialContact give PersonId and PersonId1 field names)....How can I influence schema generation to generate databas...
c# code-first entity-framework
asked by Sean Kearon

Entity Framework Code First Using One column as Primary Key and another as Auto Increment Column

You can also do this with Data Annotations:...public class Sale { [DatabaseGenerated(DatabaseGeneratedOption.Identity)] public int Id { get; set; } [Key] public string TrNo { get; set; } public DateTime Date { get; set; } public int CustomerID { get; set; } public ObservableCollection<SaleDetail> SaleDetails { get; se...
c# ef-code-first entity-framework
asked by Corey Adler

Entity Framework Foreign Key as Primary Key Code First

I have two code first models, Foo and FooState where Foo has an optional FooState....public class Foo { [Key] public int FooId { get; set; } public FooState FooState { get; set; } } public class FooState { [Key] public int FooStateId { get; set; } [Required] public int State { get; set; } [Required] public Fo...
c# ef-code-first entity-framework
asked by Neil

EF Code First Fluent API specifying the Foreign Key property

I believe you should be able to do this:...HasRequired(t => t.Agent).WithMany().HasForeignKey(t => t.AgentId)
ef-code-first entity-framework
asked by SOfanatic

EF 6 - Code first invalid one-to-one foreign key relationship

DESIGN BACKGROUND...:...I'm trying to create code-first EF6 mappings for the following database structure:...The database design is as follow: Instead of having "CustomerID" as foreign key on all related entities (Employment, expenses, income, etc...), we have a CustomerRelationship table, which will contain the CustomerID, and then a "RelatedID" c...
c# ef-code-first entity-framework entity-framework-6
asked by FaNIX

Entity Framework code-first set foreign key with primary key in same table

I have this ...WdUser... class inherited from ...SysModelBase...:...[Serializable] public class WdUser : SysDomainModelBase, IWdUser { [Display(Name = "UserName")] [MaxLength(25)] [Required] public string UserName { get; set; } [Required] [Index(IsUnique = true)] [MaxLength(25)] [Display(Name = "LoginName ")] pu...
asp.net c# entity-framework-6
asked by Autyan

EF one to one or zero relationship with custom foreign key column name

How do i make the foreign key column to have a custom name. by default EF will append "_" to the foreign key column...Customer...POCO:...public class Customer { public int Id { get; set; } public string Name { get; set; } public virtual Order Order { get; set; } } ...EF Config:...HasKey(m => m.Id); HasOptional(m => m.Order).WithOpti...
entity-framework-6
asked by bet

Mapping foreign key to non primary surrogate key column in EF code first

public class A { [DatabaseGenerated(DatabaseGeneratedOption.Identity)] public virtual int Aid { get; set; } public virtual ICollection<B> B { get; set; } } public class B { [DatabaseGenerated(DatabaseGeneratedOption.Identity)] public virtual int Bid { get; set; } [Key] [Column(Order = 0)] ...
c# ef-code-first entity-framework entity-framework-6 foreign-keys
asked by user5419119

One to One Relationship with Different Primary Key in EF 6.1 Code First

I am having an issue getting a reference to the employee object from the PayGroup object using Entity Framework 6.1. I have a foreign key in the database on PayGroup.SupervisorId -> Employee.EmployeeId. Note that this is a zero or one-to-one relationship (a pay group can only have one supervisor and an employee can only be the supervisor of one pay...
c# ef-fluent-api entity-framework entity-framework-6 sql-server
asked by Brian Swart

EF 6 Code-First Many to Many relationship with same entity on non-primary key

I have an EF 6 Task entity, which looks like this:...public class Task { public Guid TaskId {get; set;} public TaskTypeEnum TaskType {get; set;} public TaskStatusEnum TaskStatus {get; set;} public virtual ICollection<Task> Dependencies {get; set;} } ...Tasks of a certain type can be dependent on all other tasks of a certain type to...
.net c# database entity-framework entity-framework-6
asked by user3802230

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow