Entity Framework Core: Get a List of All the Tables

Question

Aryan Kumar · Answer

You can get a list of all the tables in your Entity Framework Core database using the Model property of your DbContext class. The Model property is the collection of all the entities that are associated with the database.

The following code gets a list of all the tables in the database:

C#

var tables = context.Model.GetEntityTypes();

This code returns a collection of EntityType objects. Each EntityType object represents a table in the database.

Then you can traverse through the collection of EntityType object to get the names of the tables. For example, the following code prints the names of all the tables in the database:

C#

foreach (var table in tables)
{
    Console.WriteLine(table.Name);
}

Here are the few other things to keep in mind when getting a list of all the tables in an Entity Framework Core database:

You can use the Where operator to filter the query results.
You can use the OrderBy operator sort the query results.
You can use the Take and Skip operators to paginate the query results.

forum

Entity Framework Core: Get a List of All the Tables

Can you answer this question?

1 Answers