Creating classes from Postgres database for Entity Framework Core

Question

Looking for a method to automatically create entity classes from existing Postgres 13 database. in

According to

http://www.npgsql.org/efcore/index.html

In Visual Studio 2019 command prompt

dotnet ef dbcontext scaffold "Host=my_host;Database=my_db;Username=my_user;Password=my_pw" Npgsql.EntityFrameworkCore.PostgreSQL

Command should do this but it throws error

Could not execute because the specified command or file was not found.
Possible reasons for this include:
  * You misspelled a built-in dotnet command.
  * You intended to execute a .NET program, but dotnet-ef does not exist.
  * You intended to run a global tool, but a dotnet-prefixed executable with this name could not be found on the PATH.

NpgSql.EntityFrameworkCore.PostgreSQL v5.0.1 package is installed from Nuget.

AVTUNEY · Accepted Answer · 2020-12-28 07:54:23Z

4

You should install Dotnet EF tool.

try this in your package manager console

dotnet tool install --global dotnet-ef

After that it is recommended to install design tool aswell so you can use tools on specific project

dotnet add package Microsoft.EntityFrameworkCore.Design

answered Dec 28, 2020 at 7:54

AVTUNEY

1,35310 silver badges14 bronze badges

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

Collectives™ on Stack Overflow

Creating classes from Postgres database for Entity Framework Core

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related