Hi Guy’s , here is the article to connect PostgreSQL database with visual studio 2019. Let’s see all steps.
1.Download and Install ODBC Driver from devart site.Follow Below Picture.
2.Create new Data Source by selecting “Devart ODBC Driver for PostgreSQL.Follow Below Picture.
3.Give correct Data Source Name,Server,User ID,Port ,Database etc.Follow Below Picture.
4.After clicking OK button ,you can see new Data Source created.Follow Below Picture.
5.now lets go to visual studio,select tools tab, click “connect to Database”.Follow Below Picture.
6.select Microsoft ODBC Data Source and press OK.Follow Below Picture.
7.Add new connection, select data source name,login information and press Test Connection.Follow Below Picture.
8.now you can see all the tables,views,procedures of PostgreSQL database comes inside visual studio.