Even if there is no NULL value, Entity Framework CTP 4 says "Cannot enter the value NULL into column."

c# ctp4 entity-framework


Im using EF CTP 4. I have a simple console app (for testing purposes) that is using EF to insert some data into a SQL database.

I have come to a problem where by upon inserting the item

using(var context = GetContext())
   BOB b = new BOB();
   b.Id = 1;


It throws the error: {"Cannot insert the value NULL into column 'Id', table 'TestDB.dbo.BOB'; column does not allow nulls. INSERT fails.\r\nThe statement has been terminated."}

The Table just has 1 field of Id int NOT NULL which is the primary key and is not an auto incremented Id.

On the creation of the DataContext I have this configuration, which yes does get fired.

protected override void OnModelCreating(ModelBuilder builder)
    builder.Entity<BOB>().HasKey(b => b.Id);

I have also pre-populated this table and then through the debugger been able to via watch load up this BOB object... so I am really stumped, as for being able to load up my BOB shows that all is right... however upon inserting a new one it crashes...

1/12/2014 3:54:29 PM

Accepted Answer

Have you tried explicitly specifying the StoreGeneratedPattern?

    .HasKey(p => p.Id)
        .Property(p => p.Id)
            .StoreGeneratedPattern = StoreGeneratedPattern.None;

12/15/2010 9:48:52 AM

Popular Answer

i have the same issue here and it's really an ugly solution.

public Int64 PolicyID { get; set; }

this is NOT an auto generated number

then i hit the same error.

EF Code First CTP5

after apply this:

 public Int64 PolicyID { get; set; }

then it will work.

Related Questions


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