I want to use just one ConnectionString, but...

mdsrlz · **Posted:** Tue May 09, 2006 10:54 am

Hi!

Nowadays I'm using two connection strings, because I use the membership/role providers that also need a connection string defined.

I'd like to use the same connectionString above to NHibernate.

Is it possible?

I've tried this, but I got an error:

Code:

<connectionStrings>
    <add name="MySQLConnectionString" connectionString="..."/>
</connectionStrings>

<nhibernate>
    <add key="hibernate.connection.provider" value="NHibernate.Connection.DriverConnectionProvider"/>
    <add key="hibernate.dialect" value="NHibernate.Dialect.MySQLDialect"/>
    <add key="hibernate.connection.driver_class" value="NHibernate.Driver.MySqlDataDriver"/>
    <add key="hibernate.connection.connection_string" value="MySQLConnectionString"/>
</nhibernate>

The error is:

Quote:

{"cannot open connection"}

Wouldn't be interesting to use the same connString defined into the section <connectionString>?

Thanks

mabraham · **Joined:** Mon Mar 20, 2006 10:49 pm **Posts:** 59

We wrote our own NHibernate-based Membership and Profile providers to achieve that integration. It was more or less simply a matter of taking the MS sample providers and mechanically replacing the persistence logic.

Mike

mdsrlz · **Posted:** Wed May 10, 2006 9:47 am

mabraham wrote:

We wrote our own NHibernate-based Membership and Profile providers to achieve that integration. It was more or less simply a matter of taking the MS sample providers and mechanically replacing the persistence logic.

Mike

Hum, Ok.

I've removed the connection string from providers and that's right!

Thanks ;)

mdsrlz · **Posted:** Wed May 10, 2006 9:51 am

Just another question:

Is it not possible to use the same ConnectionString defined into the <connectionStrings> node to NHibernate?

I'd like to do something like the first post:

Code:

<connectionStrings> 
    <add name="MySQLConnectionString" connectionString="..."/> 
</connectionStrings>

...
<add key="hibernate.connection.connection_string" value="MySQLConnectionString"/>
...

Thanks