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;
	}
}

[michaelb]

You probably want to look at the Postgres` Client Interfaces, especially libpq - C library and this Example Program

[knowledgeseeker]

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;
	}
}

use odbc connection class.
you r using sqlconnection class.

[agasca]

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;
	}
}

Do you consider to use npgsql ?

with that you can connect to the database simply making this (example from the user manual):

using System;
using System.Data;
using Npgsql;

public class NpgsqlUserManual
{
  public static void Main(String[] args)
  {
    NpgsqlConnection conn = new NpgsqlConnection("Server=127.0.0.1;Port=5432;User Id=joe;Password=secret;Database=joedata;");
    conn.Open();
    conn.Close();
  }
}

[nmadct]

There's also an OLEDB interface to PostgreSQL:

http://pgfoundry.org/projects/oledb/

I'd think Npgsql should be more efficient if you care a lot about performance, though.