title: Connecting to postgresql on Visual Studio
body: <p>I have an issue connecting to my local postgresql database. It seems like I retrieve all the tables and other information in my Server Explorer, but sadly everytime I compile I get an exception that says</p>
  
  <pre><code>An unhandled exception of type 'System.ArgumentException' occurred in System.Data.dll
   Additional information: Keyword not supported: 'host'.
  </code></pre>
  
  <p>Here's my code </p>
  
  <pre><code>using System;
  using System.Collections.Generic;
  using System.Data.SqlClient;
  using System.Linq;
  using System.Text;
  using System.Threading.Tasks;
  
  namespace DBVSHotel
  {
      class Program
      {
          static void Main(string[] args)
          {
              var con = new SqlConnection("User Id = postgres; Host = localhost; Database = Hotels; Initial Schema =public");
          }
      }
  }
  </code></pre>