How to Connect to PostgreSQL with EF Core: A Step-by-Step Guide

How to connect to a PostgreSQL using Entity Framework Core.

Have you ever wanted to connect your ASP.NET MVC website to a relational database like PostgreSQL? This tutorial will guide you step-by-step through the process of getting your site set up so it can talk to a PostgreSQL database!

🕑Timestamps :
00:00 Introduction
01:14 Creating the web project
01:59 Adding the connection string to PostgreSQL
02:54 Creating the Data Access Layer
04:05 Creating a Model
07:24 Creating the database with Migrations
08:48 Querying data
11:26 Data seeding
13:51 Conclusion

Where you can find me:

#entityframeworkcore #postgresql

[hyegol]

Oh my god, this has to be the most hands-on and easy to understand tutorial I have ever saw about this! Great job!

[CarlosInFlorida]

Very excellent! Good job explaining and going through the process. Thank you!

[neerajtripathi]

this was excellent...can't find any tutorial better than this.

[voytek]

That’s exactly what I was looking for! Thanks.

[arwahsapi]

The instruction is very clear! Thank you!

[alexgobe]

Splendid, clear and fluid explanation ✅

[Suecia]

I can only say, thank you for sharing your knowledge. 😎

[AlThePal]

Wow this made it so easy everywhere else people had other stuff happening and you made it so simple to understand. I am use to doing it with sqlserver and had to do this with post but couldn't find the string. and you was like yo do this and this and this and watch it work
thanks

[msbaggins]

thank you so much for this awesome tutorial

[bobby]

Thank you so much Sir. I was stuck in doing this for 2 days. god bless.

[nerina]

Tremendo tutorial, excelentemente explicado. Gracias!

[spstc]

sir thank you so much you just saved my life

[_HuynhDuyKhang]

A really useful video, thank you so much for making videos like this

[germanyandgerman]

It is a very good tutorial, please keep going

[badatcomputer]

Good walkthrough to get me up and running. I'm applying this to a Blazor Server app with Postgres. Would love some resources to get a better understanding of the second half of the video (everything after we created the models)

[asliakar]

Hello, thanks for this great tutorial. I am trying to do it exactly like you, but I get the error "Couldn't set post (Parameter 'post')" after i run the "Update-Database" command. Couldn't fix it no matter what I did. Maybe you have a clue on what's wrong?

[harryPannuHere]

Is DataBase first approach will also use the same migration command ? Please help me create context class in .net core api from existing postgresql.

[eduardotorrenteracolin]

Hi man! Thanks for this video, is to easy understand :D But I have a big question :/ How configurate for get the Package Manager Console? I can't write anything... Thanks!!

[toknowlife]

I'm stuck type interval date save data .
Do you have any way to help?

[RiseFate]

if i already have a database, can i just follow the tutorial and leave out the migration part?