Calculated properties in Entity Framework

Question

Suppose I have an employee object with the following properties:

Name - string Hours - single Wage - single

I want to add a property, Salary, which equals Hours * Wage. In an ordinary business object, I would simply code that up in the property, but this would presumably wiped out if the class needed to be regenerated.

Is there an EF standard way to implement this without going through the trouble of mapping it to a database entity?

Answer 1

Indeed. Create a separate file, for instance, EmployeeExtension.cs.

In this file, place the following code:

public partial class Employee
{
    public decimal Salary
    { get { return Hours*Wage; } }
}

Linq To SQL and Entity Framework classes are generated with the partial keyword to allow you to split the definition over many files, because the designers knew that you will want to add members to the class that aren't overwritten by continually autogenerating the base source file.

Answer 2

If i remember correctly the classes created by the EF are partial. So you could possibly add another file containing another partial class (same namespace, same classname of course) which than implements the property

public single Salary
{
   get
   {
       return this.Hours * this.Wage;
   }
}

Should do the trick (if those singles are not nullable, mind you!)

Answer 3

You can implement the property in the entity class. The entity framework will generate partial classes allowing you to add members to the class. Add a class like this to your code:

public partial class Employee {
  public Single Salary {
    return Hours*Wage;
  }
}