How to update only one field using Entity Framework?

by

Ladislav’s answer updated to use DbContext (introduced in EF 4.1):

public void ChangePassword(int userId, string password)
{
    var user = new User() { Id = userId, Password = password };
    using (var db = new MyEfContextName())
    {
        db.Users.Attach(user);
        db.Entry(user).Property(x => x.Password).IsModified = true;
        db.SaveChanges();
    }
}

More Related Contents:

  1. How do I use structural annotations to set SQL type to Date in model first approach
  2. COUNT MANY FIELDS IN ACCESS [closed]
  3. Solution for: Store update, insert, or delete statement affected an unexpected number of rows (0) [closed]
  4. The object ‘DF__*’ is dependent on column ‘*’ – Changing int to double
  5. How to update two tables in one statement in SQL Server 2005?
  6. Any downsides of using data type “text” for storing strings?
  7. Create unique constraint with null columns
  8. Querying data by joining two tables in two database on different servers
  9. Is having an ‘OR’ in an INNER JOIN condition a bad idea?
  10. What happens to an uncommitted transaction when the connection is closed?
  11. Create Trigger to log SQL that affected table?
  12. Are Stored Procedures more efficient, in general, than inline statements on modern RDBMS’s? [duplicate]
  13. SQL grouping by month and year
  14. “IN” clause limitation in Sql Server
  15. Execute Immediate within a stored procedure keeps giving insufficient priviliges error
  16. CASE vs. DECODE
  17. Meaning of square brackets [] in MS-SQL table designer? [duplicate]
  18. Postgres not using index when index scan is much better option
  19. Check if current date is between two dates Oracle SQL
  20. SQL query that gives distinct results that match multiple columns
  21. Count Returning blank instead of 0
  22. Using a database table as a queue
  23. ANSI SQL Manual
  24. Passing dynamic order by in stored procedure
  25. SQL . The SP or function should calculate the next date for friday
  26. is it possible to select EXISTS directly as a bit?
  27. What is the difference between a stored procedure and a view?
  28. Using CASE Statement inside IN Clause
  29. How do I create a decimal field in Access with Alter Table?
  30. ORACLE After update trigger: solving ORA-04091 mutating table error

Leave a Comment