Hi,
I'm developing a C# application using Entity Framework database first, since I already have an existing database which I want to analyze.
The table that I'm using has a "Target" column and a "Actual" column and I need to determine the progress, which would be Actual/Target.
Where should this data be? Should I create a new column with this formula in my database (SQL Server btw), or should I do this calculation in my code? If the latter option is the best one, then how would I change my model that was created automatically by entity framework?
What I have tried:
Creating a formula column, but don't know if it's best practice