When i want don't modified one Attributes,It's not work,question for ef core

Question

I don't Want Modified UserPassword when it's null or empty ,
I search for long time but it's doesn't work
Would you give me some advice ?

public async Task<IActionResult> Edit(int ID, [Bind("UserId,UserPassword,Username,Fullname,Nickname,Sex,Status,Email,Tel,Mobile,Address,Province,City,PostCode,UserType")] User user)
    {
        if (ID != user.UserId)
        {
            return NotFound();
        }
        if (ModelState.IsValid)
        {
            
                if (string.IsNullOrEmpty(user.UserPassword))
                {
                    context.Attach(user);
                    context.Entry(user).Property("UserPassword").IsModified = false;
                }
                else
                {
                user.UserPassword = main.Md5(user.UserPassword);
                }
                context.Update(user);
                await context.SaveChangesAsync();
            
            return RedirectToAction(nameof(Index));
        }
        return View(user);
    }

Here is cshtml enter image description here

score 0 · Answer 1 · answered Jul 05 '20 at 16:28

0

Instead of receiving user in your action , create a viewmodel and use that for update your user info.

Example:

public class UserViewModel {

 public string UserId { get; set; }

 public string UserPassword { get; set;}

 ... // other properties
}

public async Task <IActionResult> Edit(int ID, UserViewModel viewModel) {
 if (ID != viewModel.UserId) {
  return NotFound();
 }
 if (ModelState.IsValid) {
  var user = context.Users.FindAsync(viewModel.UserId);
  user.Password = !string.IsNullOrEmpty(viewModel.Password) ? main.Md5(viewModel.Password) : user.Password;
  // update other properties here

  await context.SaveChangesAsync();

  return RedirectToAction(nameof(Index));
 }
 return View(user);
}

answered Jul 05 '20 at 16:28

Arsalan Valoojerdi

961
6
16

if password is null it isn't update null into the database?and i use the form post – Sparkli Jul 05 '20 at 16:49
This code ignore null or empty passwords and not update your password in database . Yes you should use form post. It's just like before except you use ViewModel instead of your model. – Arsalan Valoojerdi Jul 05 '20 at 16:58
also check this : https://stackoverflow.com/questions/11064316/what-is-viewmodel-in-mvc – Arsalan Valoojerdi Jul 05 '20 at 16:58
I update a picture for cshtml,can i use it? and i also inject[@model MVCMovie.Models.User] – Sparkli Jul 05 '20 at 17:18
Is there any function that i can not submit one of fieid in EF Core ?I try your function but it's not work. – Sparkli Jul 05 '20 at 17:22
Try this : db.Entry(model).Property(x => x.SomeProperty).IsModified = false; – Arsalan Valoojerdi Jul 05 '20 at 17:30
I use that in the code ,could you please help check the code where is something wrong? – Sparkli Jul 05 '20 at 19:07

score 0 · Accepted Answer · answered Jul 06 '20 at 09:05

Try the below code:

context.Update(user);
context.Entry<User>(user).Property(x => x.UserPassword).IsModified = false;
context.SaveChanges();

The Update method marks all the properties as modified, you should change the state of IsModified after it.

You can refer to https://github.com/dotnet/efcore/issues/6849

When i want don't modified one Attributes,It's not work,question for ef core

2 Answers2