Get List of Entity Models in DbContext Entity Framework Core 2.1

c# ef-core-2.1 .net-core-2.1 entity-framework-core-2.1
Kevin picture Kevin · Jan 14, 2019 · Viewed 14.5k times · Source

I'm trying to find a way to get a List of all of the entity models in my DbContext. For instance, if I have two models called Customer and Invoice defined in C# which through code-first I created EF entities and a database, how do I now query the DbContext to get a List that has Customer and Invoice in it -- i.e., all of the entities in that context? I want to be able to call a method that returns a List of all the entities -- not the data, just a list of the entities.

It seems to me this should be so easy, but either it is not easy or I am missing something -- probably the latter. ;-).

Could someone please point me in the right direction? Thanks!!

Answer

Ivan Stoev picture Ivan Stoev · Jan 14, 2019

You can use Model property to get the associated IModel, then GetEntityTypes method to enumerate all IEntityTypes. ClrType property of IEntityType will give you the associated class type, e.g.

DbContext db = ...;
var entityTypes = db.Model.GetEntityTypes().Select(t => t.ClrType).ToList();

IEntityType has many useful properties and (extension) methods for getting information about the primary/alternate keys, foreign keys, navigations, properties etc. in case you need them.

Related questions

The specified framework 'Microsoft.NETCore.App', version '2.1' was not found

I am developing an Angular 6 application in dotNet Core 2.1. Everything is working flawlessly, until I got to setting up EFCore. All my models are defined and context created. Running dotnet ef migrations add InitialCreate gives me the "The specified framework …

Read More
Setting the default value of a DateTime Property to DateTime.Now inside the System.ComponentModel Default Value Attrbute

Does any one know how I can specify the Default value for a DateTime property using the System.ComponentModel DefaultValue Attribute? for example I try this: [DefaultValue(typeof(DateTime),DateTime.Now.ToString("yyyy-MM-dd"))] public DateTime DateCreated { get; set; } And it …

Read More
Change the IDENTITY property of a column, the column needs to be dropped and recreated

I am using EF Core 2.1 This was my initial model definition. public class Customer //Parent { public int Id { get; set; } public string Name { get; set; } public string Email { get; set; } public BankAccount BankAccount { get; set; } } public class BankAccount { public int …

Read More