如何使用实体在 MVC 4 剃须刀 C# 中更新选定的用户详细信息数据

本文关键字:更新 用户 数据 详细信息 实体 何使用 MVC 剃须刀 | 更新日期: 2023-09-27 18:37:19

我已经编写了代码来更新用户表中的值。

var after = new USERDETAIL
            {
                ID = before.ID,               
                FullName = FullName, 
                CountryCode = Country,
                Contact = Phone,
                Email = Email,
                Address = Address,
                City = City,
                State = State,
                Postal = PostalCode,                               
            };
using (var db = new SMSEntities())
{
    try
    {
        db.USERDETAILS.Attach(after);
        db.Entry(after).Property(x => after.FullName).IsModified = true;
        db.Entry(after).Property(x => after.CountryCode).IsModified = true;
        db.Entry(after).Property(x => after.Contact).IsModified = true;
        db.Entry(after).Property(x => after.Email).IsModified = true;
        db.Entry(after).Property(x => after.Address).IsModified = true;
        db.Entry(after).Property(x => after.City).IsModified = true;
        db.Entry(after).Property(x => after.State).IsModified = true;
        db.Entry(after).Property(x => after.Postal).IsModified = true;
        db.Entry(after).Property(x => after.Password).IsModified = false;
        db.Entry(after).Property(x => after.UrlIPath).IsModified = false;
        db.Entry(after).Property(x => after.TimeDate).IsModified = false;
        db.Entry(after).Property(x => after.TotalBalance).IsModified = false;
        db.Entry(after).Property(x => after.Verified).IsModified = false;
        //db.Entry<USERDETAIL>(before).State = System.Data.EntityState.Detached;
        //db.Entry<USERDETAIL>(after).State = System.Data.EntityState.Modified;
       db.SaveChanges();
    }

这是更新表中的值,但我已设置.IsModified = false;以便表中的值不会更新,但代码仍在更新值。当我检查表中的数据时,更新了 NULL 值

密码,网址IPath,总余额,已验证

我不想更新。如何解决此问题?

提前谢谢你

如何使用实体在 MVC 4 剃须刀 C# 中更新选定的用户详细信息数据

代码应该是

db.Entry(after).Property(x => x.Password).IsModified = false;
db.Entry(after).Property(x => x.UrlIPath).IsModified = false;
db.Entry(after).Property(x => x.TimeDate).IsModified = false;
db.Entry(after).Property(x => x.TotalBalance).IsModified = false;
db.Entry(after).Property(x => x.Verified).IsModified = false;