I have multi-company PostgreSQL database.

Common files are in public schema.
Company specific files are in separate schema for every company.

nhibernate cannot find company specific tables in this database.
It does not allow to pass

SET SEARCH_PATH TO companyx,public

command to postgres.

How to force nhibernate to pass

SET SEARCH_PATH TO companyx,public

command to Postgres ?

Starting with Npgsql 2.0beta3 (the ADO.NET data provider for PostgreSQL), it's possible to define the search path in the connection string.

According to Npgsql User's Manual ('Working with search paths' section):

Npgsql allows you to modify the search path when connecting to a database. In order to do that, just specify it in your connection string with the syntax:

Note that by specifying a search path in connection string, you may want to add the public schema as it will not be added automatically.


see: http://www.npgsql.org/docs/manual/UserManual.html