Is it possible to connect two different schemas using NHibernate?
I want to query two tables, but in a different schema each one.

Tks

There's a schema attribute on the class tag:

<class name="Foo" table="footable" schema="bar" ... />

or you can put the schema in the tablename:

<class name="Foo" table="bar.footable" ... />

Sorry, I did not get my problem well explained.

For example,

I have TABLE_A in two different schemas. The table has the same name.
I can't put the name of the schema directy on mapping file. It must be dynamic.

I start a session on a schema, and than when it's necessary to execute another query, in a different schema, I start another session on another schema.

[]s

Hmm, I don't think that's possible ... try and search the nhusers group at google:

http://groups.google.com/group/nhusers?hl=en

Ok wolli.
Tks for your help