How to update primary key value in entity framework?

c# entity-framework

Question

I have table(and also entity in Entity Data Model) Person with following fields:

Name              Type
SocialID          String      
FirstName         String
LastName          String

which SocialID is Primary Key. I want to update value of SocialID for each record. However when i try to update this field in Entity Framework I get following error: 

The property 'SocialID' is part of the object's key information and cannot 
be modified.

The code that i get above error is:

foreach (var p in Entity.Persons)
{
   p.SocialID= p.SocialID + "00";
   Entity.SaveChanges();
}

How I can do this??

1
3
2/1/2013 10:46:53 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

As mentioned by the others, you can't do it in code. You will have to make your update in SQL. Either in a migration or directly in SQL Server Management Studio (or the equivalent if you're using a different database).

UPDATE Person -- Or 'Persons' if that's what your table is called
SET SocialID = SocialID + '00'

It will require a lot more work than this if you have other tables use this column as a foreign key (you'll have to drop the constraints first -- on all tables that reference your primary key -- then fix the data and recreate the constraints). Or as Moe said in the comments, you can set your foreign keys to cascade on update.

4
2/1/2013 8:34:00 PM

Popular Answer

As per my knowledge primary key once generated cant be updated programatically,that defies the purpose of primary key. It'll be better if you insert all your data again with new primary keys and delete old data.

Cris

Related Questions

Using entity framework, change the value of the main key.

I'm trying to update one value of a compound primary key from within the entity framework and I'm getting this error: "The property 'CustomerID' is part of the object's key information and cannot be modified. "...Here is my code: ...Dim customer As Customer = (From c In db.Customer Where c.CustomerID = "xxx" AndAlso c.SiteKey = siteKey).FirstOrDefa...
.net entity-framework sql-server vb.net
asked by Paul Lemke

Code Generation : Add primary key / foreign key to Entity Framework

I ran into the same problem. The template file you are looking for appears in the Solution Explorer (in VS2013) as:...YourDataModelName.tt...You can modify it to add the ...[Key]... attributes to the generated code by following:...Finding a property is Primary Key in POCO Template t4 generator
c# code-generation entity-framework-6
asked by srg39

Update Database using Entity Framework having primary key on multiple Columns

For me, the problem was Unique Index on some of the columns in my database. Violating the index was causing this error to be displayed....But when I was searching for the solution I found there can be other reasons for this error also , like make sure key have values and are not null , check concurrence setting for the column .
asp.net-mvc asp.net-mvc-4 c# entity-framework linq
asked by Danish Shaikh

How to update primary key from Entity Framework?

Updating primary key columns is not a good practice with EntityFramework. It confuses EF because it changes the identity of the object, and makes keeping the in-memory copy and the in-database copy of the data in sync very problematic. So it's not allowed....Just don't update primary keys. Instead delete one row and insert a new one....Alternati...
c# entity-framework sql
asked by sarin

primary key constraint updating many-to-many self referential table in entity framework code-first

TL;DR... What is the proper way of rehydrating an entity framework object with a self referential many to many relationship from a DTO and updating it with the new values so that the database updates correctly?...I have the following entity (irrelevant stuff trimmed)... public class Role { [Key] [Required] public String ...
asp.net-mvc asp.net-web-api entity-framework entity-framework-6 sql-server
asked by Jason Coyne

Entity Framework 6.1.3 Mapping Foreign key to non primary key

This is now possible in Entity Framework 7 (that is, EF Core 1.0)....From .Net Entity Framework User Voice ...Unique Constraint (i.e. Candidate Key) Support...:...Support for this feature was added in EF Core 1.0 and we don’t have plans to add it in the EF6 codebase.
c# entity-framework-6
asked by ErikE

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

This answer for your requirement of 2 foreign keys ...public class WdUser : SysDomainModelBase, IWdUser { //This is your primary key of WDUser public int UserID{get;set;} //This is for your 1st foreign key mapping public virtual WDUser WDUser{get;set;} public virtual ICollection<WDUser> WDUserList{get;set;} public int fk1{get;set;} //This is for y...
asp.net c# entity-framework-6
asked by Nithila Shanmugananthan

How does Entity Framework generate a GUID for a primary key value?

When we run the ASP.NET application and register the user, Entity Framework automatically sets the unique id (PK) in AspNetUser table:...The same is true for other AspNetRoles, AspNetUserLogins, AspNetUserRoles except AspNetUserClaims which has identity enabled....Can anybody explain how Entity framework create this unique Id? And if we want to cre...
asp.net asp.net-mvc c# entity-framework sql-server
asked by Shivam Sharma

Entity Framework composite key delete with one primary key

If you are using EF 6, you can use the RemoveRange method....So it could look something like this;...context.Cart.RemoveRange(cartItem => cartItem.CustomerID == CustomerToDelete);
c# entity-framework-6 repository-pattern
asked by feal

How to set starting value for an Identity primary key in Entity Framework code first?

In my project I am creating the ...Appointments... table using Entity Framework code first. When I set my integer primary key, ...AppointmentNo... as ...[Key]... and ...[Required]..., it creates the table with initial primary key starting with 1. ...I want the appointment numbers to start at 1000. My database is SQL Server. Please help me. Thank yo...
.net c# code-first entity-framework-6 sql-server
asked by Charindri Perera

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