forum

Home / DeveloperSection / Forums / Entity Framework Core: Get a List of All the Tables

Ask Question
Gautam Ramesh

Gautam Ramesh

Follow
I am Gautam Ramesh from Uttar Pradesh. Have completed my B. Tech. course from MNNIT campus Prayagraj in 2022. I have good knowledge of computer networking.

Can you answer this question?

Answer

1 Answers

Aryan Kumar

Aryan Kumar

06-Sep-2023

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.

Liked By