connection string to Postgres

Question

I am new to Postgres and I need help with connection string.

My app using Entity Framework. I have this connectionString to MSSQL Server:

<connectionStrings>
    <add name="DBContext" connectionString="Data Source=localhost;Initial Catalog=DB;Integrated Security=True;MultipleActiveResultSets=True" providerName="System.Data.SqlClient" />
</connectionStrings>

to my project i download a npgsql package (http://pgfoundry.org/projects/npgsql/) a need to help with editing connection string to Postgres database.

How to set providerName to npgsql?

Thank for help

Exactly what is the problem you are encountering?

Crono
– Crono

2014-02-24 18:05:49 +00:00
Commented Feb 24, 2014 at 18:05 — Crono
– Crono, Commented Feb 24, 2014 at 18:05
I dont know how to set providerName to npgsql

Davecz
– Davecz

2014-02-24 18:09:21 +00:00
Commented Feb 24, 2014 at 18:09 — Davecz
– Davecz, Commented Feb 24, 2014 at 18:09
I suggest you make this a part of the question. ;)

Crono
– Crono

2014-02-24 18:13:32 +00:00
Commented Feb 24, 2014 at 18:13 — Crono
– Crono, Commented Feb 24, 2014 at 18:13

Craig Ringer · Accepted Answer · 2014-02-25 01:18:58Z

5

"don't hard code your providers" discusses this in detail.

It shows a setting like what you want:

<add name="blah" providerName="Npgsql" 
  connectionString="Server=127.0.0.1;Port=5432;Database=myDataBase;
    User Id=myUsername;Password=myPassword;"/>

but then explains why you should not do this, you should read the settings from your application's configuration file at runtime instead.

answered Feb 25, 2014 at 1:18

Craig Ringer

329k83 gold badges742 silver badges820 bronze badges

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

Collectives™ on Stack Overflow

connection string to Postgres

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related