C#•3y ago

❔ Difficulty to find PostgreSQL data source to connect with database by EFCore.

I'm trying to use EFCore to connect my database to my code, but i cant find the data source of my PostgreSQL

First image is a guy on SQLServer

Second Image is me trying the same on PostgreSQL

There is a way to get the data source?

Pobiega•10/5/23, 8:28 PM

oh boi

Pobiega•10/5/23, 8:28 PM

connectionstrings are not interchangable per database

Pobiega•10/5/23, 8:29 PM

in that screenshot on the left, he is using SQL Express which has a wildly different connstr than postgres

Pobiega•10/5/23, 8:29 PM

are you running postgres on the same computer as you are running visual studio on?

Pobiega•10/5/23, 8:30 PM

generally, npgsql uses this format:

Pobiega•10/5/23, 8:31 PM

thats the localhost IP and default port, change database/username/password as required

jcotton42•10/5/23, 9:24 PM

also, do you have to use database-first?
I see you're trying to scaffold

PPobiega in that screenshot on the left, he is using SQL Express which has a wildly diffe...

caiqueOP•10/6/23, 4:50 PM

got it, but the procedure would be the same, right? to scaffold

PPobiega are you running postgres on the same computer as you are running visual studio o...

caiqueOP•10/6/23, 4:51 PM

yes

PPobiega thats the localhost IP and default port, change database/username/password as re...

caiqueOP•10/6/23, 4:51 PM

oh i see now, i'll try that

Jjcotton42 also, do you _have_ to use database-first? I see you're trying to scaffold

caiqueOP•10/6/23, 4:52 PM

well, i would like to since it's already created

caiqueOP•10/6/23, 4:52 PM

it is a bad thing?

caiqueOP•10/6/23, 4:52 PM

at least the tutorial i was checking on was by database-first

Pobiega•10/6/23, 4:54 PM

DB first is very rare

PPobiega DB first is very rare

caiqueOP•10/6/23, 5:56 PM

i noticed that, i couldn't find much contents about DB first

caiqueOP•10/6/23, 5:56 PM

is it a bad practice?

Pobiega•10/6/23, 5:57 PM

you only really use it if you already have a DB with data

Pobiega•10/6/23, 5:57 PM

you do NOT use db first for a new project

PPobiega you only really use it if you already have a DB with data

caiqueOP•10/6/23, 6:31 PM

i already have a db with data, but is only for studying, do you recommend in this case that i dont use db first?

caiqueOP•10/6/23, 6:31 PM

because i could just delete the DB

caiqueOP•10/6/23, 6:31 PM

and recreate it

caiqueOP•10/6/23, 6:31 PM

by EFCORE

Pobiega•10/6/23, 6:37 PM

its up to you

Pobiega•10/6/23, 6:37 PM

code first is good to learn

Pobiega•10/6/23, 6:37 PM

as its what you'll likely be doing if you ever do this for real

PPobiega as its what you'll likely be doing if you ever do this for real

caiqueOP•10/6/23, 7:30 PM

right, i'll take your advice but surely im gonna try DB first this time, thx for your help

Accord•10/7/23, 7:58 PM

Was this issue resolved? If so, run

/close

/close

otherwise I will mark this as stale and this post will be archived until there is new activity.