Decimal precision and scale in EF Code First

by

The answer from Dave Van den Eynde is now out of date. There are 2 important changes, from EF 4.1 onwards the ModelBuilder class is now DbModelBuilder and there is now a DecimalPropertyConfiguration.HasPrecision Method which has a signature of:

public DecimalPropertyConfiguration HasPrecision(
byte precision,
byte scale )

where precision is the total number of digits the db will store, regardless of where the decimal point falls and scale is the number of decimal places it will store.

Therefore there is no need to iterate through properties as shown but the can just be called from 

public class EFDbContext : DbContext
{
   protected override void OnModelCreating(System.Data.Entity.DbModelBuilder modelBuilder)
   {
       modelBuilder.Entity<Class>().Property(object => object.property).HasPrecision(12, 10);

       base.OnModelCreating(modelBuilder);
   }
}

More Related Contents:

  1. Ignoring a class property in Entity Framework 4.1 Code First
  2. How can I automatically filter out soft deleted entities with Entity Framework?
  3. How to disable cascade delete for link tables in EF code-first?
  4. How to Specify Primary Key Name in EF-Code-First
  5. Entity Framework: Duplicate Records in Many-to-Many relationship
  6. How can set a default value constraint with Entity Framework 6 Code First?
  7. Linq: help me to make this work
  8. Create code first, many to many, with additional fields in association table
  9. EntityFramework – contains query of composite key
  10. EF codefirst : Should I initialize navigation properties?
  11. Remove trailing zeros
  12. MetadataException: Unable to load the specified metadata resource
  13. How do I apply OrderBy on an IQueryable using a string column name within a generic extension method?
  14. Entity Framework (EF) Code First Cascade Delete for One-to-Zero-or-One relationship
  15. The cast to value type ‘Int32’ failed because the materialized value is null
  16. How to declare one to one relationship using Entity Framework 4 Code First (POCO)
  17. Entity Framework with XML Files [closed]
  18. EF 6 – How to correctly perform parallel queries
  19. Mapping Database Views to EF 5.0 Code First w/Migrations
  20. Place to put Database.SetInitializer
  21. Entity framework raw SQL Query
  22. Finding the reason for DBUpdateException
  23. Parallel doesnt work with Entity Framework
  24. Entity Framework and multiple schemas
  25. Entity Framework 4.1: Unable to cast from DbQuery to ObjectQuery
  26. Unable to find the requested .Net Framework Data Provider. It may not be installed
  27. Entity Framework Multiple Object Contexts
  28. Entity Framework Code First naming conventions – back to plural table names?
  29. The relationship could not be changed because one or more of the foreign-key properties is non nullable
  30. Repository Pattern, POCO, and Business Entities

Leave a Comment