Loop/reflect through all properties in all EF Models to set Column Type

by

In EF Core v1.1.0 you can use something like this:

foreach (var pb in modelBuilder.Model
    .GetEntityTypes()
    .SelectMany(t => t.GetProperties())
    .Where(p => p.ClrType == typeof(decimal) || p.ClrType == typeof(decimal?))
    .Select(p => modelBuilder.Entity(p.DeclaringEntityType.ClrType).Property(p.Name)))
{
    pb.ForSqlServerHasColumnType("decimal(13,4)");
}

Update (EF Core 2.x): Starting from EF Core 2.0, the model is built separately for each database provider, so HasAbcXyz methods are replaced with common HasXyz. The updated code (which also skips the explicitly configured properties) looks like this:

foreach (var property in modelBuilder.Model.GetEntityTypes()
    .SelectMany(t => t.GetProperties())
    .Where(p => p.ClrType == typeof(decimal) || p.ClrType == typeof(decimal?)))
{
    if (property.Relational().ColumnType == null)
        property.Relational().ColumnType = "decimal(13,4)";
}

Update (EF Core 3.x): With EF Core 3.0 metadata API changes (Relational() extensions removed, properties replaced with Get / Set method pair), the code is as follows:

foreach (var property in modelBuilder.Model.GetEntityTypes()
    .SelectMany(t => t.GetProperties())
    .Where(p => p.ClrType == typeof(decimal) || p.ClrType == typeof(decimal?)))
{
    if (property.GetColumnType() == null)
        property.SetColumnType("decimal(13,4)");
}

Update (Entity Framework Core 6): EF Core 6 includes convention model configuration that can be used to achieve this to all types.
The advantage over looping through entities manually, is that this conventions already ignore certain types (like Ignore(), or properties that have Converters).

public class SomeDbContext : DbContext
{
    protected override void ConfigureConventions(
        ModelConfigurationBuilder configurationBuilder)
    {
        configurationBuilder
                .Properties<decimal>()
                .HavePrecision(19, 4);
    }
}

More Related Contents:

  1. Equivalent for .HasOptional in Entity Framework Core 1 (EF7)
  2. EntityFramework Core automatic migrations
  3. Using EF Core ThenInclude() on Junction tables
  4. Changes in IDENTITY column after EF core 3
  5. What goes into DbContextOptions when invoking a new DbContext?
  6. EF Core Second level ThenInclude missworks
  7. No executable found matching command “dotnet-ef”
  8. How to select top N rows for each group in a Entity Framework GroupBy with EF 3.1
  9. Entity framework core update many to many
  10. Dynamically changing schema in Entity Framework Core
  11. ef core 2 apply HasQueryFilter for all entity
  12. Unable to edit db entries using EFCore, EntityState.Modified: “Database operation expected to affect 1 row(s) but actually affected 0 row(s).”
  13. Implementing recursive property loading in EF Core
  14. Entity Framework Core 2.0 – Run migrations step by step
  15. EF Core 2: How to apply HasQueryFilter for all entities
  16. ASP.NET MVC 2.0 Implementation of searching in jqgrid
  17. Code First: Independent associations vs. Foreign key associations?
  18. Entity Framework 6 Code first Default value
  19. Dynamically change connection string in Asp.Net Core
  20. EF Code First “Invalid column name ‘Discriminator'” but no inheritance
  21. How to update the model when using database first approach
  22. Querying objects after AddObject before SaveChanges?
  23. Entity Framework 4.1 default eager loading
  24. ASP.NET Core change EF connection string when user logs in
  25. Entity Framework Data Annotations Set StringLength VarChar
  26. EF Code First foreign key without navigation property
  27. LINQ to Entities for subtracting 2 dates
  28. Changing Inherited Types in Entity Framework
  29. Why is my Entity Framework Code First proxy collection null and why can’t I set it?
  30. Why does the entity framework need an ICollection for lazy loading?

Leave a Comment