entity framework - How to search and update records with EF -

entity framework - How to search and update records with EF -

i trying find records contain text string in field/property , replace text string new text string , save update record.

i not sure way code belowis not working. have set break points , name variable have replaced text when @ record in database, field still have original value.

var vendors = db.vendor.where(c=> c.name.contains("corp.")); foreach( var vendor in vendors) { var name = vendor.name.replace("corp.", "corporation"); vendor.name = name; } db.savechanges();

update ended using hack now.

var vendors = db.vendor.where(c=> c.name.contains("corp.")); foreach( var vendor in vendors) { var v = db.vendor.find(vendor.id); var name = vendor.name.replace("corp.", "corporation"); v.name = name; } db.savechanges();

i think forgot mark entity's state modified, seek next code

var vendors = db.vendor.where(c=> c.name.contains("corp.")); foreach(var vendor in vendors) { var name = vendor.name.replace("corp.", "corporation"); vendor.name = name; db.entry(vendor).state = entitystate.modified; } db.savechanges();

entity-framework