Update only certain columns in DB using Entity Framework

Question

I have an entity that I know already exists in the database but which is not currently being tracked by the context. I force the context to track the entity using the Attach method on DbSet. Then set 'IsModified' = true for necessary properties. But EF tries to update every property in db table and SaveChanges() method throws exception that some properties is required and can't be empty. Though I mark only one property as modified. I'm using EF v.6.0.

Here is my code:

public bool ChangeState(int id, bool state)
    {
        try
        {
            var obj = new T {ID = id, Hidden = state};

            _context.Set<T>().Attach(obj);

            _context.Entry(obj).Property(x => x.Hidden).IsModified = true;
            return _context.SaveChanges() == 1;
        }
        catch (DbEntityValidationException dbEx)
        {
            ...
        }            
    }
}

Have you any idea?

You could try _context.Configuration.ValidateOnSaveEnabled = false;. (before Attach) — user3559349
– user3559349, Commented Aug 27, 2014 at 10:34
great.. it works fine. thank you. Unfortunately I don't have reputation enough to vote. — mykhailovskyi
– mykhailovskyi, Commented Aug 27, 2014 at 10:39

Ehsan Zargar Ershadi · Accepted Answer · 2015-03-12 13:37:14Z

2

Ok, to have an answer for this question , I'll repeat @Stephen Muecke answer here :

You could try _context.Configuration.ValidateOnSaveEnabled = false; Please do not vote me, the credit is for @Stephen Muecke

answered Mar 12, 2015 at 13:37

Ehsan Zargar Ershadi

25k18 gold badges68 silver badges95 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Update only certain columns in DB using Entity Framework

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related