Update query with entityframework

Question

How to write an update query in EntityFramework using LINQ to Entities?

EDIT: And if it is possible how this query can be written in Entity SQL?

Answer 1

There are 2 aternatives:

• Same as Lloyd fetch entity from database, change it's properties and submit changes back into database.
• Write an update statement in a stored procedure, then execute the stored procedure.