Entity Framework 6 Recipes 2nd Edition(12-8)译 -> 重新获取一个属性的原始值

时间:2023-03-08 16:47:09

12-8. 重新获取一个属性的原始值

问题

在实体保存到数据库之前,你想重新获取属性的原始值

解决方案

假设你有一个模型 (见 Figure 12-11) 表示一个员工( Employee),包含工资(salary)属性. 你有一个业务规则,规定一个员工的工资增长不能超过10%.在一个实体保存到数据库之前,你想验证这条规则,拿新的工资与原来的工资比较,看是否超过10%.

Entity Framework 6 Recipes 2nd Edition(12-8)译 -> 重新获取一个属性的原始值

Figure 12-11. An Employee entity with the employee’s salary

为核实工资增长不超过10%,我们override SaveChanges 事件. 在该事件里,我们重新取得当前实体的原始值,如果新值超过原始值的10%,我们抛出一个异常,当然这个异常也会导致保存失败.

代码 Listing 12-8 展示了这些细节:

Listing 12-8. Overriding the SaveChanges Event to Enforce the Business Rule

class Program

{

static void Main(string[] args)

{

RunExample();

}

static void RunExample()

{

using (var context = new EFRecipesEntities())

{

var emp1 = new Employee { Name = "Roger Smith", Salary = 108000M };

var emp2 = new Employee { Name = "Jane Hall", Salary = 81500M };

context.Employees.Add(emp1);

context.Employees.Add(emp2);

context.SaveChanges();

emp1.Salary = emp1.Salary * 1.5M;

try

{

context.SaveChanges();

}

catch (Exception)

{

Console.WriteLine("Oops, tried to increase a salary too much!");

}

}

using (var context = new EFRecipesEntities())

{

Console.WriteLine();

Console.WriteLine("Employees");

foreach (var emp in context.Employees)

{

Console.WriteLine("{0} makes {1}/year", emp.Name,

emp.Salary.ToString("C"));

}

}

Console.WriteLine("Press any key to close...");

Console.ReadLine();

}

}

public partial class EFRecipesEntities

{

public override int SaveChanges()

{

var entries = this.ChangeTracker.Entries().Where(e => e.Entity is Employee && e.State ==

System.Data.Entity.EntityState.Modified);

foreach (var entry in entries)

{

var originalSalary = Convert.ToDecimal(

entry.OriginalValues["Salary"]);

var currentSalary = Convert.ToDecimal(

entry.CurrentValues["Salary"]);

if (originalSalary != currentSalary)

{

if (currentSalary > originalSalary * 1.1M)

throw new ApplicationException(

"Can't increase salary more than 10%");

}

}

return base.SaveChanges();

}

}

上述代码Listing 12-8输出结果如下:

Oops, tried to increase a salary too much!

Employees

Roger Smith makes $108,000.00/year

Jane Hall makes $81,500.00/year

原理

在override  SaveChanges里, 我们先获取状态为modified 的Employee 实体,接着挨个查看它们的Salary 属性的原始值与当前值.如果二者不相等且超过10%,我们就抛出一个ApplicationException异常. 否则, 我们就简单地调用DbContext 的  SaveChanges ,让EF把修改保存到数据库.

附:创建示例用到的数据库的脚本文件