The property 'BookId' on entity type 'Library' has a temporary value. Either set a permanent value explicitly or ensure that the database is

.net-core ef-migrations entity-framework entity-framework-core

Question

When I use Entity Framework Core and seed data with migration, I have this error:

The property 'BookId' on entity type 'Library' has a temporary value. Either set a permanent value explicitly or ensure that the database is configured to generate values for this property.

1
2
2/18/2019 5:05:25 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

The message means that you have given a value for your key that did not exist if you have dependencies with ForeignKey.

1
2/18/2019 5:05:25 PM

Popular Answer

I got the same exception when I had unique index, AddRange failed on unique index and then inside catch exception block was try to remove whole inserted collection. (Not my code, but I had to fix it :-) )

Code sample (simplified):

try {
    context.AddRange(users); // List<User>, has property List<Contact>
    context.SaveChanges(); // throws exception on unique index
} catch (Exception ex) {
    context.RemoveRange(users); // this throws exception "The property 'UserID' on entity type 'Contact' has a temporary value"
    throw;
}
Tomino

Related Questions

What is the best way to set navigation property having only id in Entity Framework?

Use a mutator method to modify a protected property for the ID:...public class MyEntity { public virtual int Id { get; set; } public virtual MySecondEntity SecondEntity { get; set; } [ForeignKey( "SecondEntity" )] protected virtual int? MySecondEntityId { get; set; } public void SetSecondEntityId( int? id ) { MySec...
c# entity-framework entity-framework-6 navigation-properties
asked by Moho

How to set another value on a boolean with defaut value with Entity Framework Core?

Finally I can have data annotations generated in my EF model using ...--data-annotations... option in the EF command. So I put ...[DatabaseGenerated(DatabaseGeneratedOption.None)]... on the property and don't use the default contraint of the database.
boolean c# default-constraint entity-framework-core sql-server
asked by Korgoth

I am having trouble creating DB in SQL Server Express with Entity Framework Core 2.0

I am going through the MvcMusicStore tutorial on the www.asp.net website....I am able to use Entity Framework Core 2.0 and migrations to create a DB in localDb. Here is the connection string from that in appsettings.json:..."MvcMovieContext": "Server=(localdb)\\mssqllocaldb;Database=MvcMovieContext-19840e0a-5fb4-409c-9f38-7f2946cd3937;Trusted_Conne...
entity-framework-core sql-server-express
asked by Sam

.NET - Set all Entity current values to new values without specifying separate properties

I have two entities, one is the one in the database the other is the new value i received from the controller. ...Now i want to update the entity in the Database without specifying all the different properties;...Instead of: ...public async Task UpdateFoo(Foo fooNew){ Foo fooDb = await context.Foo .Include(f => f.Child) .Where(f...
.net-core asp.net-core-2.0 c# entity-framework entity-framework-core
asked by phicon

How to specify default property values for owned entity types in Entity Framework Core 2.0?

I have a simple POCO type, say something like...public class OwnedEntity { public string stringProperty { get; set; } public decimal decimalProperty { get; set; } public bool boolProperty { get; set; } public int intProperty { get; set; } } ...and an actual entity with an ...OwnedEntity... reference...public class SomeEntity { ...
asp.net entity-framework-core
asked by qCring

How to get all saved Entity values in DbContext either via Events or override SaveChangesAsync()

Need a centralized solution to get the resulting ...Entity... as persisted to the Db, potentially inside the ...SaveChangesAsync()... and ...SaveChanges()... methods of my ...DbContext... or via an event listener....Need resulting entity value to contain all new ....ValueGeneratedOnAdd[Updated/etc]()... properties. i.e....RowVersion..., ...Updated...
c# entity-framework-core entity-framework-core-2.1
asked by ttugates

DateTime.Now default value in entity configuration always sets the same DateTime in the database

I'm having a strange issue when configuring my entities in Fluent API using EF Core....All my entities have an ...EntityCreated... field which is a DateTime object that is set to the current DateTime upon being added to the database as a new record....The following is my configuration code to set this default value:...builder.Property(x => x.Entity...
ef-fluent-api entity-framework-core
asked by Azhari

Temporary Value Error During Entity Framework Core Modify

Try ... public UserData Update(UserData updatedUser) { var entity = db.Users.Attach(updatedUser); entity.Entry(updatedUser).State = EntityState.Modified; entity.SaveChanges(); return updatedUser; } ...If not worked for you then kindly share your Page.cshtml....You might be changing the primary key...
asp.net-core c# entity-framework-core sql-server
asked by Muhammad Moid Shams

How to set class property's value to be set to generated id value of another class on insertion to database?

After getting more information, one way to implement this is something like...class A { public int ID; public string data; ... } class HistoryA { public int ID; public int AID; public string data; public DateTime updated; ... } ...So I hade one class (class A) holding the current information and another historyA referencing...
c# entity-framework entity-framework-core sql-server
asked by Jonny

The property 'myFk' on entity type 'Order' has a temporary value

it seems like the entity framework doesn't recognize the one-to-many relationship you can try to add this code on your OnModelCreating()... modelBuilder.Entity<OrderlineDto>() .HasOne(ol => ol.OrderDto) .WithMany() .HasForeignKey(p => p.OrderId); ...then add migration and check if there is any updates on database
c# entity-framework-core
asked by Besher Tobeh

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