Sql – PostgreSQL via subsonic

postgresqlsubsonic

I try to work with my postgres DB via SubSonic. I have simple config:

<configuration>
  <connectionStrings>
    <add name="test"
      connectionString="Server=localhost;Port=5432;User Id=iliy;Password=111;Database=test;"
      providerName="Npgsql"/>
  </connectionStrings>
</configuration>

But it does not work. I got "Unable to find the requested .Net Framework Data Provider. It may not be installed." There is Npgsql reference in project.

What's wrong?

Best Answer

I think you need to dig a little deeper into Subsonic for it to work with Postgres, because it does not know about any data provider for the database. It comes with providers for MS Sql Server, MySql, SqlLite etc.

Related Topic