ASP.NET Entity Framework API Update single column

Question

I am using ASP.NET MVC Entity Framework and I created an API controller, now I want to add a method that is basically a copy of the put method, however I want to adjust this method so it updates a single column

[ResponseType(typeof(void))]
        [Authorize]
        public IHttpActionResult PutUser(int id, Users user)
        {
            if (!ModelState.IsValid)
            {
                return BadRequest(ModelState);
            }

            if (id != user.id)
            {
                return BadRequest();
            }

            db.Entry(user).State = EntityState.Modified;

            try
            {
                db.SaveChanges();
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!UsersExists(id))
                {
                    return NotFound();
                }
                else
                {
                    throw;
                }
            }

            return StatusCode(HttpStatusCode.NoContent);
        }

each user in my User class has an email and column called isOnline, for this method I want to update the isOnline to true based on the email.

The examples I have seen online are for non API controllers. Please Help!

The code for EF is the same whether it is an api controller or an MVC controller. — nurdyguy
– nurdyguy, Commented Aug 22, 2017 at 21:17

Mohammad Akbari · Accepted Answer · 2017-08-23 06:20:46Z

1

Your subject is partial update in Entity Framework, following is an example:

var user= new User() {Id = id, TargetColumn = "test"};
context.Users.Attach(user);
var entry = context.Entry(user);
entry.Property(e => e.TargetColumn ).IsModified = true;;

answered Aug 23, 2017 at 6:20

Mohammad Akbari

4,8146 gold badges52 silver badges80 bronze badges

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

Collectives™ on Stack Overflow

ASP.NET Entity Framework API Update single column

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