C# .NET ===> postgreSQL

[smurphy811]

I am creating a C# .NET application that uses a postgreSQL database that is on my machine locally. My problem is that I cannot figure out how to write the connectionString. I have searched the internet for the past 30 minutes trying everything I could find.

Help? anyone?

public class Connection
{
    protected static SqlConnection conn;
    private const string connStr = "???";
 
    public static SqlConnection getConnection()
    {
        if(conn == null)
        {
            conn = new SqlConnection(connStr);
            conn.Open();
        }
        return conn;
    }
}

[kenobewan]

You can use odbc or npgsql. Here is an example using Npgsql:

String connstring = "Server=xx.xx.xx.xx;Port=5432;User
id=user;Password=password;Database=dbname";