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 connectionStrin g. 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";