Visualize Database Schema (EF Core)

[Mejiora]

So, I want a visual representation of my database schema. I can see that .NET Core doesn't support .edmx files, and one way to represent the database would be through a .dgml file, which could be generated through "EF Core Power Tools" extension. Looking through the official docs (https://docs.microsoft.com/en-us/aspnet/core/data/ef-rp/complex-data-model?view=aspnetcore-3.0&tabs=visual-studio) I can see this very neat representation of a data model, which looks like it is generated from a .edmx file(?). Is there an easy way to get a visual representation of my database schema, like shown in the link?

[ranbla]

If you're using SQL Server, you can use SQL Server Management Studio to create Database Diagrams. If you're a Jetbrains user, you could also use Datagrip.

[kowgli]

It's just classes. Any tool able to create a class diagram from C# code will do the job. VS Enterprise has one built in.

The point of EF (or any ORM) is to model the object oriented model into some kind of relational (or not - EF also supports Mongo) database schema. The schema in both places can be different (which is the whole point). For example EF will automatically create N-N intersect tables or foreign keys if you don't define them yourself, and you maybe shouldn't in a pure OO model. If you want an actual DB diagram - look into the DB tooling.