Entity Framework – Get List of Tables

by

This sample code from post What Tables Are In My EF Model? And My Database?

using (var dbContext = new YourDbContext())
{
    var metadata = ((IObjectContextAdapter)dbContext).ObjectContext.MetadataWorkspace;

    var tables = metadata.GetItemCollection(DataSpace.SSpace)
        .GetItems<EntityContainer>()
        .Single()
        .BaseEntitySets
        .OfType<EntitySet>()
        .Where(s => !s.MetadataProperties.Contains("Type")
        || s.MetadataProperties["Type"].ToString() == "Tables");

    foreach (var table in tables)
    {
        var tableName = table.MetadataProperties.Contains("Table")
            && table.MetadataProperties["Table"].Value != null
            ? table.MetadataProperties["Table"].Value.ToString()
            : table.Name;

        var tableSchema = table.MetadataProperties["Schema"].Value.ToString();

        Console.WriteLine(tableSchema + "." + tableName);
    }
}

More Related Contents:

  1. Code-first vs Model/Database-first [closed]
  2. Entity Framework: “Store update, insert, or delete statement affected an unexpected number of rows (0).” [closed]
  3. EF Core Second level ThenInclude missworks
  4. What’s the difference(s) between .ToList(), .AsEnumerable(), AsQueryable()?
  5. The relationship could not be changed because one or more of the foreign-key properties is non-nullable
  6. Best way to check if object exists in Entity Framework? [closed]
  7. Improve navigation property names when reverse engineering a database
  8. Create a Dropdown List for MVC3 using Entity Framework (.edmx Model) & Razor Views && Insert A Database Record to Multiple Tables
  9. Entity Framework 4.1 DbContext Override SaveChanges to Audit Property Change
  10. How to configure ProviderManifestToken for EF Code First
  11. Can I specify global mapping rules in Entity Framework Code First?
  12. The specified named connection is either not found in the configuration, not intended to be used with the EntityClient provider, or not valid
  13. Entity Framework loading child collection with sort order
  14. How can I delete 1,000 rows with EF6?
  15. Equivalent for .HasOptional in Entity Framework Core 1 (EF7)
  16. How to exclude one table from automatic code first migrations in the Entity Framework?
  17. Ramifications of DbSet.Create versus new Entity()
  18. How to pass parameters to the DbContext.Database.ExecuteSqlCommand method?
  19. Entity Framework : How do you refresh the model when the db changes?
  20. Entity framework code first creates “discriminator” column
  21. EF Migrations: Rollback last applied migration?
  22. Using EF Core ThenInclude() on Junction tables
  23. How to update not every fields of an object using Entity Framework and EntityState.Modified
  24. Keyword not supported: “data source” initializing Entity Framework Context
  25. Entity Framework Data Annotations Set StringLength VarChar
  26. What is the best practice in EF Core for using parallel async calls with an Injected DbContext?
  27. EF 4.1 loading filtered child collections not working for many-to-many
  28. How to map Table per Type (TPT) inheritance in Entity designer?
  29. Entity Framework: Inheritance and Include
  30. EF Core 2: How to apply HasQueryFilter for all entities

Leave a Comment