Calculated column in EF Code First

by

You can create computed columns in your database tables. In the EF model you just annotate the corresponding properties with the DatabaseGenerated attribute:

[DatabaseGenerated(DatabaseGeneratedOption.Computed)]
public double Summ { get; private set; }

Or with fluent mapping:

modelBuilder.Entity<Income>().Property(t => t.Summ)
    .HasDatabaseGeneratedOption(DatabaseGeneratedOption.Computed)

As suggested by Matija Grcic and in a comment, it’s a good idea to make the property private set, because you’d probably never want to set it in application code. Entity Framework has no problems with private setters.

Note: For EF .NET Core you should to use ValueGeneratedOnAddOrUpdate because HasDatabaseGeneratedOption doesnt exists, e.g.:

modelBuilder.Entity<Income>().Property(t => t.Summ)
    .ValueGeneratedOnAddOrUpdate()

More Related Contents:

  1. Entity Framework (EF) Code First Cascade Delete for One-to-Zero-or-One relationship
  2. Get return value from stored procedure
  3. Mapping Database Views to EF 5.0 Code First w/Migrations
  4. EF5 Code First – Changing A Column Type With Migrations
  5. Optimistic concurrency: IsConcurrencyToken and RowVersion
  6. How to Specify Primary Key Name in EF-Code-First
  7. Modelling polymorphic associations database-first vs code-first
  8. C#: SQL Server Connection String
  9. SQL Query slow in .NET application but instantaneous in SQL Server Management Studio
  10. What are Independent Associations and Foreign Key Associations? [duplicate]
  11. Entity Framework (.NET Full Framework) Ordering Includes [duplicate]
  12. SqlParameter does not allows Table name – other options without sql injection attack?
  13. Does Entity Framework 4 Code First have support for identity generators like NHibernate?
  14. Any way to SQLBulkCopy “insert or update if exists”?
  15. EF 6 – How to correctly perform parallel queries
  16. EF migration for changing data type of columns
  17. How to keep single SQL Server connection instance open for multiple request in C#?
  18. Delete a single record from Entity Framework?
  19. How to use SqlCommand to CREATE DATABASE with parameterized db name?
  20. ExecuteNonQuery returning -1 when using sql COUNT despite the query string
  21. GO statements blowing up sql execution in .NET
  22. How to Identify the primary key duplication from a SQL Server 2008 error code?
  23. Entity Framework 4.1: Unable to cast from DbQuery to ObjectQuery
  24. Provider named pipes provider error 40 could not open a connection to SQL Server error 2 [duplicate]
  25. Is it possible to use SqlGeography with Linq to Sql?
  26. “The operation is not valid for the state of the transaction” error and transaction scope
  27. How do I safely store database login and password in a C# application?
  28. Passing array to a SQL Server Stored Procedure
  29. Bulk Insert Sql Server millions of record
  30. Loading PictureBox Image From Database

Leave a Comment