private static void Method09()
{
Member member = new Member { Id = 1, Password = "******" + DateTime.Now.Second };
using (var db = new DataContext())
{
//先查询一次，让上下文中存在相同主键的对象
Member oldMember = db.Members.Single(m => m.Id == 1);
Console.WriteLine("更新前：{0}。", oldMember.AddDate);
db.Update<Member>(m => new { m.Password }, member);
int count = db.SaveChanges(false);
Console.WriteLine("操作结果：{0}", count > 0 ? "更新成功。" : "未更新。");
Member newMember = db.Members.Single(m => m.Id == 1);
Console.WriteLine("更新后：{0}。", newMember.Password);
}
}
//情景一：取出数据更新后直接保存
private static void Method01()
{
using (var db = new DataContext())
{
const string userName = "******";
Member oldMember = db.Members.Single(m => m.UserName == userName);
Console.WriteLine("更新前：{0}。", oldMember.AddDate);
oldMember.AddDate = oldMember.AddDate.AddMinutes(10);
db.Update(oldMember);
int count = db.SaveChanges();
Console.WriteLine("操作结果：{0}", count > 0 ? "更新成功。" : "未更新。");
Member newMember = db.Members.Single(m => m.UserName == userName);
Console.WriteLine("更新后：{0}。", newMember.AddDate);
}
}
private static void Method05()
{
const string userName = "******";
Member updateMember;
using (var db1 = new DataContext())
{
updateMember = db1.Members.Single(m => m.UserName == userName);
}
updateMember.AddDate = DateTime.Now;
using (var db2 = new DataContext())
{
//先查询一次，让上下文中存在相同主键的对象
Member oldMember = db2.Members.Single(m => m.UserName == userName);
Console.WriteLine("更新前：{0}。", oldMember.AddDate);
db2.Update<Member>(updateMember);
int count = db2.SaveChanges();
Console.WriteLine("操作结果：{0}", count > 0 ? "更新成功。" : "未更新。");
Member newMember = db2.Members.Single(m => m.UserName == userName);
Console.WriteLine("更新后：{0}。", newMember.AddDate);
}
}