PostgreSQL DSN Connection string in C#

Question

I am trying to connect PostgreSQL database to C# application. For that I have created ODBC data source, now I need the connection string to include in C#.

Question: How to write DSN connection string for PostgreSQL in C#?

connectionstrings.com/postgresql

kostas ch.
– kostas ch.

2014-06-11 13:19:07 +00:00
Commented Jun 11, 2014 at 13:19 — kostas ch.
– kostas ch., Commented Jun 11, 2014 at 13:19

MRebai · Accepted Answer · 2014-06-11 13:24:28Z

2

Try this

 // PostgeSQL-style connection string
   string connstring = String.Format("Server={0};Port={1};" + 
                    "User Id={2};Password={3};Database={4};",
                    tbHost.Text, tbPort.Text, tbUser.Text, 
                    tbPass.Text, tbDataBaseName.Text );
                // Making connection with Npgsql provider
   NpgsqlConnection conn = new NpgsqlConnection(connstring);
   conn.Open();
   // quite complex sql statement
   string sql = "SELECT * FROM simple_table";
   // data adapter making request from our connection
   NpgsqlDataAdapter da = new NpgsqlDataAdapter(sql, conn);

More details here http://www.codeproject.com/Articles/30989/Using-PostgreSQL-in-your-C-NET-application-An-intr

answered Jun 11, 2014 at 13:24

MRebai

5,4823 gold badges35 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Aamir Hussain · Accepted Answer · 2022-10-10 16:46:55Z

0

this worked for me

 "DefaultConnection": "User ID=postgres;Password=aamir7882;Server=localhost;Port=5432;Database=kingsurplus;Integrated Security=true;Pooling=true;

get server details and database details from pgAdmin 4

answered Oct 10, 2022 at 16:46

Aamir Hussain

1971 silver badge4 bronze badges

Collectives™ on Stack Overflow

PostgreSQL DSN Connection string in C#

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related