如何使用实体在 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,总余额,已验证
我不想更新。如何解决此问题?
提前谢谢你
代码应该是
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;