Getting metadata in EF Core: table and column mappings

by

Is this metadata available anywhere in EF Core?

Yes it is. Just additionally to the properties examine the methods (GetXXX, FindXXX etc.). And pay special attention to Relational() extension methods.

For instance:

foreach (var entityType in dbContext.Model.GetEntityTypes())
{
    var tableName = entityType.Relational().TableName;
    foreach (var propertyType in entityType.GetProperties())
    {
        var columnName = propertyType.Relational().ColumnName;
    }
}

You need to have Microsoft.EntityFrameworkCore.Relational Nuget package installed.

Update (EF Core 3.0+): Relational() provider extensions have been removed and properties have been replaced with direct Get / Set extension methods, so the code for column/table names now is simply

var tableName = entityType.GetTableName();
// ..
var columnName = propertyType.GetColumnName();

Update (EF Core 5.0+): Since now EF Core supports separate column name mappings for table, view, sql etc., you have to pass the desired StoreObjectIdentifier to GetColumnName method, e.g.

var tableName = entityType.GetTableName();
var tableIdentifier = StoreObjectIdentifier.Table(tableName, entityType.GetSchema());
// ...
var tableColumnName = propertyType.GetColumnName(tableIdentifier);

More Related Contents:

  1. How to create a many to many relationship with latest nightly builds of EF Core?
  2. Query with `groupjoin` cannot be translated although it’s documened as being supported
  3. Dynamically change connection string in Asp.Net Core
  4. Many-to-many self referencing relationship
  5. navigation property should be virtual – not required in ef core?
  6. auto create database in Entity Framework Core
  7. How to add the same column to all entities in EF Core?
  8. Unable to create migrations after upgrading to ASP.NET Core 2.0
  9. Dynamically changing schema in Entity Framework Core
  10. How to store JSON in an entity field with EF Core?
  11. EF CORE 2.1 HasConversion on all properties of type datetime
  12. How can I call a SQL Stored Procedure using EntityFramework 7 and Asp.Net 5
  13. Equivalent for .HasOptional in Entity Framework Core 1 (EF7)
  14. How to update the model when using database first approach
  15. AddDbContext or AddDbContextPool
  16. Azure Function, EF Core, Can’t load ComponentModel.Annotations 4.2.0.0
  17. Could not load file or assembly Microsoft.Extensions.DependencyInjection.Abstractions, Version=1.1.0.0
  18. Entity Framework Core 2.0: How to configure abstract base class once
  19. Loop/reflect through all properties in all EF Models to set Column Type
  20. Entity framework EF.Functions.Like vs string.Contains
  21. ASP.NET Core change EF connection string when user logs in
  22. Avoid or control circular references in Entity Framework Core
  23. Unable to create an object of type ‘[DBContext’s Name]’. For the different patterns supported at design time [closed]
  24. Add migration with different assembly
  25. Entity Framework Core: `SqlNullValueException: Data is Null.` How to troubleshoot?
  26. How to get user information in DbContext using Net Core
  27. How to set Identity Seed value in code-first?
  28. EF Core takes a lot of time, sometimes, to perform SELECT query
  29. Entity Framework Core 2.0 – Run migrations step by step
  30. How to access DbContext in .NET 6 minimal API Program.cs

Leave a Comment