add postgres to visual studio for mac project

Add Postgres To Visual Studio Project Install The Package

The new repo is ASP.NET Basics Refresh because naming is hard.

If you want to follow along with this post the files before any changes can be found here.

Im going to give the.NET CLI command, but this could also be done using the Visual Studio NuGet Package Manager UI.

Add Postgres To Visual Studio Project Install The Package

This post will also be using SQLite, but Entity Framework Core supports multiple databases you would need to install the package for the database you are interested in using.

This is also assuming your terminal is in the same directory as the project file.

The following is my full appsettings.json with the connection string for SQLite.

If you are using a different database provider your connection string could be drastically different.

The first thing we need to do is to install the Entity Framework Core Tool using the following command which will install the tool globally.

Note that the same command will be used in the future when applying migrations to an existing database.

In the sample case, we are going to use our Contact class for the model, ContactDbContext for the data context to generate a controller named ContactController.

Either option will allow you to try out your API without having to build a client.

If you have any question I recommend checking Microsofts official docs on Getting Started with Entity Framework Core.

How would I depenedncy inject that same DBContext interface using.Net Core for dependency injection.

Add Postgres To Visual Studio For Mac Project