Entity framework: StoreGeneratedPattern=”Computed” property

by

Setting this property to Computed is telling EF that you cannot set the value directly. How could you? This property exists for the sake of computed columns, which by definition are not saved back to the database.

Unfortunately, EF’s “Default Value” property can only be set to values known at compile-time, and so not DateTime.Now

This link provides a decent workaround:

Setting the default value of a DateTime Property to DateTime.Now inside the System.ComponentModel Default Value Attrbute

You can also handle the SavingChanges event on your context, and add default values there, but that only happens when you actually call SaveChanges(), not when the object is created.

    partial void OnContextCreated() {
        this.SavingChanges += new EventHandler(AccrualTrackingEntities_SavingChanges);
    }

    void AccrualTrackingEntities_SavingChanges(object sender, EventArgs e) {
        List<Invoice> Invoices = this.ObjectStateManager
            .GetObjectStateEntries(System.Data.EntityState.Added | System.Data.EntityState.Modified)
            .Select(entry => entry.Entity)
            .OfType<Invoice>().ToList();

        foreach(Invoice I in Invoices)
            if (I.EntityState == System.Data.EntityState.Added) {
                //set default values
            } else {
                //??  whatever
            }
    }

More Related Contents:

  1. How do parameterized queries help against SQL injection?
  2. How do I apply OrderBy on an IQueryable using a string column name within a generic extension method?
  3. Entity Framework Core: A second operation started on this context before a previous operation completed
  4. LINQ To Entities does not recognize the method Last. Really?
  5. Bulk-deleting in LINQ to Entities
  6. Entity Framework And Business Objects
  7. Entity Framework 6: audit/track changes
  8. Self referencing loop detected – Getting back data from WebApi to the browser
  9. “The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities” – stumped!
  10. ‘datetime2’ error when using entity framework in VS 2010 .net 4.0
  11. LINQ, Unable to create a constant value of type XXX. Only primitive types or enumeration types are supported in this context
  12. Entity vs Model vs View Model
  13. Received an invalid column length from the bcp client for colid 6
  14. Eager , Lazy and explicit loading in EF6
  15. Using Simple Injector with Unit Of Work & Repository Pattern in Windows Form
  16. Place to put Database.SetInitializer
  17. Entity Framework: How to disable lazy loading for specific query?
  18. Finding the reason for DBUpdateException
  19. The entity type ApplicationUser is not part of the model for the current context
  20. GUID COMB strategy in EF
  21. entity framework update many to many relationship: virtual or not
  22. Entity Framework and multiple schemas
  23. Entity Framework: Duplicate Records in Many-to-Many relationship
  24. Mixing Fluent API and DataAnnotations in EF code first
  25. Keep Getting ‘The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities’ Exception
  26. Register AspNetCore 2.1 Identity system with DbContext interface
  27. How to include() nested child entity in linq
  28. Oracle Entity Framework – Generate Entity From Tables in Different Schema
  29. Entity framework – get entity by name
  30. LINQ Query to Convert string to datetime

Leave a Comment