Npgsql connection strings

• Standard

  Server=127.0.0.1;Port=5432;Database=myDataBase;User Id=myUsername;
Password=myPassword;

  PostgreSQL

• Using windows security

  Server=127.0.0.1;Port=5432;Database=myDataBase;Integrated Security=true;

  PostgreSQL

• Setting command timeout

  Server=127.0.0.1;Port=5432;Database=myDataBase;User Id=myUsername;
Password=myPassword;CommandTimeout=20;

  The CommandTimeout parameter is measured in seconds and controls for how long to wait for a command to finish before throwing an error.

  PostgreSQL

• Setting connection timeout

  Server=127.0.0.1;Port=5432;Database=myDataBase;User Id=myUsername;
Password=myPassword;Timeout=15;

  The Timeout parameter is measured in seconds and controls for how long to wait for a connection to open before throwing an error.

  PostgreSQL

• Specifying protocol version

  Server=127.0.0.1;Port=5432;Database=myDataBase;User Id=myUsername;
Password=myPassword;Protocol=3;

  Valid values for the key Protocol is 2 or 3.

  PostgreSQL

• SSL activated

  Server=127.0.0.1;Port=5432;Database=myDataBase;Userid=myUsername;
Password=myPassword;Protocol=3;SSL=true;SslMode=Require;

  PostgreSQL

• Without SSL

  Server=127.0.0.1;Port=5432;Database=myDataBase;Userid=myUsername;
Password=myPassword;Protocol=3;SSL=false;SslMode=Disable;

  PostgreSQL

• Controlling pooling mechanisms

  Server=127.0.0.1;Port=5432;Database=myDataBase;Userid=myUsername;
Password=myPassword;Protocol=3;Pooling=true;MinPoolSize=1;MaxPoolSize=20;
ConnectionLifeTime=15;