How to update only one column value in database using Entity Framework?

Question

I have a table with columns username, password. Data can be updated by admin for the table.

Now I want to add a new column named IsAgree (as a flag), it need to set when user logs in for the first time. But while setting data, it should not affect other column data, I will only send usename and Isagree flag as an object.

flgDetail = { usename:"vis" Isallowed:True }

[Route("api/TermsAndCondition/setflag")]
public IHttpActionResult post(FlagDetails FlagDetail)
{
    var user = _context.table.Where(s => s.UserName == flagDetail.UserName);
}

Should I use post or put?

How can I update only one column?

And it should not affect other columns.

Is _context.Configuration.AutoDetectChangesEnabled set to true? — Adil Mammadov
– Adil Mammadov, Commented Aug 29, 2016 at 6:33
If you have not changed it it should be set to true. It is usually managed inside context, for example in the constructor. But you can check it where you want. bool isEanbled = _context.Configuration.AutoDetectChangesEnabled;. If AutoDetectChanges is enabled, EF will update only changed properties — Adil Mammadov
– Adil Mammadov, Commented Aug 29, 2016 at 6:40
Did you try to change the IsAgree of user variable and call SaveChanges? Since you got it from the context with your query, setting the IsAgree will only affect this field. Try this and post if you get any problems — jpgrassi
– jpgrassi, Commented Aug 29, 2016 at 13:47

Sampath · Accepted Answer · 2016-08-29 06:41:56Z

1

you can use either post or put.It's not a problem.You can update it as shown below.

[Route("api/TermsAndCondition/setflag")]
public IHttpActionResult post(FlagDetails flagDetail)
{
    var user = _context.table.Where(s => s.UserName == flagDetail.UserName);
    user.IsAgree =flagDetail.Isallowed;
   _context.SaveChanges()
}

answered Aug 29, 2016 at 6:41

Sampath

66.2k70 gold badges327 silver badges461 bronze badges

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

Collectives™ on Stack Overflow

How to update only one column value in database 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