How can I use entity framework to get a count of database tables?

Question

I've seen posts about MetadataWorkspace but no examples for this task. I want my code to detect if the database has had a new table added so I'm comparing the number of tables in the DB with 2 lists of known tables. A table can be either user data or system data and I want to delete all the data in the user tables.

If a new table is discovered, the code will ask the user to define whether it contains system or user data.

RossG · Accepted Answer · 2014-02-26 18:21:39Z

3

This should help you. Here is the relevant part of it for you:

var metadata = ((IObjectContextAdapter)db).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");

answered Feb 26, 2014 at 18:21

RossG

4343 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Brian Leeming Over a year ago

Awesome! Interestingly, it did not return __MigrationHistory but that's ok.

RossG Over a year ago

@BrianLeeming I believe that is because that part of the code queries against the EF model. Take a look at the section of that article called "What about the database?". That part might get you the migrationhistory

Collectives™ on Stack Overflow

How can I use entity framework to get a count of database tables?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related