Dynamically change user info in connection string

John Davidson — Thu, 08 Sep 2011 00:09:08 GMT

Current revision posted to How to by John Davidson on 07/09/2011 09:09:08 p.m.

Dynamically change user info in connection string

Filed under: Mapping, QuickStart

In some cases our clients has to use the same database user id in each connection, so they can use audit and security features of their database system (and their DBAs will be happy [:)]).Hill University AND Woodfield University

To do that in Nh We can use the ConnectionProvider facility. Just derive a class from the Corllins University standard DriverConnectionProvider class:Ashwood University Accreditation AND Rochville University Accreditation

public class DynamicConnectionProvider : DriverConnectionProvider
{
    private string _connectionString;
    public override void Configure(IDictionary<string, string> settings)
    {

        // Connection string in the configuration overrides named connection string
        if (!settings.TryGetValue(NHibernate.Cfg.Environment.ConnectionString,out _connectionString))
    _connectionString = GetNamedConnectionString(settings);

        if (_connectionString == null)
        {
            throw new HibernateException("Could not find connection string setting (set " 
                + NHibernate.Cfg.Environment.ConnectionString + " or " 
                + NHibernate.Cfg.Environment.ConnectionStringName + " property)");
        }
        ConfigureDriver(settings);
    }

This is necessary because the original connection string is private, but just copy the code from base method.

The real magic is in "ConnectionString" property, it is called when nh has to connect in a Session. You have to override it so you can make the changes you need.

protected override string ConnectionString
{
    get { return FixConnectionString(_connectionString); }
}

In this case FixConnectionString read the user info from some environment variable and inject it in the connection string.

Finally configure NH to use the ConnectionProvider:

            <property name="connection.provider">
                MyAssembly.DynamicConnectionProvider, MyAssembly
            </property>

Some useful articles here and here

Dynamically change user info in connection string

markweee — Wed, 30 Mar 2011 11:34:18 GMT

Revision 5 posted to How to by markweee on 30/03/2011 08:34:18 a.m.

Dynamically change user info in connection string

Filed under: Mapping, QuickStart

To do that in Nh We can use the ConnectionProvider facility. Just derive a class from the Corllins Universitystandard DriverConnectionProvider class: Ashwood University Accreditation AND Rochville University Accreditation

public class DynamicConnectionProvider : DriverConnectionProvider
{
    private string _connectionString;
    public override void Configure(IDictionary<string, string> settings)
    {

        // Connection string in the configuration overrides named connection string
        if (!settings.TryGetValue(NHibernate.Cfg.Environment.ConnectionString,out _connectionString))
    _connectionString = GetNamedConnectionString(settings);

        if (_connectionString == null)
        {
            throw new HibernateException("Could not find connection string setting (set " 
                + NHibernate.Cfg.Environment.ConnectionString + " or " 
                + NHibernate.Cfg.Environment.ConnectionStringName + " property)");
        }
        ConfigureDriver(settings);
    }

This is necessary because the original connection string is private, but just copy the code from base method.

The real magic is in "ConnectionString" property, it is called when nh has to connect in a Session. You have to override it so you can make the changes you need.

protected override string ConnectionString
{
    get { return FixConnectionString(_connectionString); }
}

In this case FixConnectionString read the user info from some environment variable and inject it in the connection string.

Finally configure NH to use the ConnectionProvider:

            <property name="connection.provider">
                MyAssembly.DynamicConnectionProvider, MyAssembly
            </property>

Some useful articles here and here

Dynamically change user info in connection string

Fabio Maulo — Sat, 29 Nov 2008 05:16:58 GMT

Revision 4 posted to How to by Fabio Maulo on 29/11/2008 02:16:58 a.m.

Dynamically change user info in connection string

Filed under: Mapping, QuickStart

In some cases our clients has to use the same database user id in each connection, so they can use audit and security features of their database system (and their DBAs will be happy [:)]).

To do that in Nh We can use the ConnectionProvider facility. Just derive a class from the standard DriverConnectionProvider class:

public class DynamicConnectionProvider : DriverConnectionProvider
{
    private string _connectionString;
    public override void Configure(IDictionary<string, string> settings)
    {

        // Connection string in the configuration overrides named connection string
        if (!settings.TryGetValue(NHibernate.Cfg.Environment.ConnectionString,out _connectionString))
    _connectionString = GetNamedConnectionString(settings);

        if (_connectionString == null)
        {
            throw new HibernateException("Could not find connection string setting (set " 
                + NHibernate.Cfg.Environment.ConnectionString + " or " 
                + NHibernate.Cfg.Environment.ConnectionStringName + " property)");
        }
        ConfigureDriver(settings);
    }

This is necessary because the original connection string is private, but just copy the code from base method.

The real magic is in "ConnectionString" property, it is called when nh has to connect in a Session. You have to override it so you can make the changes you need.

protected override string ConnectionString
{
    get { return FixConnectionString(_connectionString); }
}

In this case FixConnectionString read the user info from some environment variable and inject it in the connection string.

Finally configure NH to use the ConnectionProvider:

            <property name="connection.provider">
                MyAssembly.DynamicConnectionProvider, MyAssembly
            </property>

Some useful articles here and [[howtonh:howtonh:/blogs/nhibernate/archive/2008/09/18/extending-nhibernate-s-driverconnectionprovider.aspx|here]] here

Dynamically change user info in connection string

Fabio Maulo — Sat, 29 Nov 2008 05:14:55 GMT

Revision 3 posted to How to by Fabio Maulo on 29/11/2008 02:14:55 a.m.

Dynamically change user info in connection string

In some cases our clients has to use the same database user id in each connection, so they can use audit and security features of their database system (and their DBAs will be happy [:)]).

To do that in Nh We can use the ConnectionProvider facility. Just derive a class from the standard DriverConnectionProvider class:

public class DynamicConnectionProvider : DriverConnectionProvider
{
    private string _connectionString;
    
 
Override the Configure method:public override void Configure(IDictionary<string, Configure(IDictionary<string, string> settings)
    {

        // Connection string in the configuration overrides named connection string
        if (!settings.TryGetValue(NHibernate.Cfg.Environment.ConnectionString, !settings.TryGetValue(NHibernate.Cfg.Environment.ConnectionString,out _connectionString))
    _connectionString = GetNamedConnectionString(settings);

        if (_connectionString == null)
        {
            throw new HibernateException("Could not find connection string setting (set " 
                +                                  NHibernate.Cfg.Environment.ConnectionString NHibernate.Cfg.Environment.ConnectionString + " or " 
                +                                  NHibernate.Cfg.Environment.ConnectionStringName NHibernate.Cfg.Environment.ConnectionStringName + " property)");");
        }
        ConfigureDriver(settings);
    }

This is necessary because the original connection string is private, but just copy the code from base method.

The real magic is in "ConnectionString" property, it is called when nh has to connect in a Session. You have to override it so you can make the changes you need.

protected override string ConnectionString
{
    get { return FixConnectionString(_connectionString); }
}

In this case "FixConnectionString" FixConnectionString read the user info from some environment variable and inject it in the connection string.

Finally configure Nh NH to use the ConnectionProvider:

<property name="connection.provider">MyAssembly.DynamicConnectionProvider,

            <property name="connection.provider">
                MyAssembly.DynamicConnectionProvider, MyAssembly
            </property></property>

Some useful articles:

http://japikse.blogspot.com/2008/06/custom-connection-provider-with.html here and

http://nhforge.org/blogs/nhibernate/archive/2008/09/18/extending-nhibernate-s-driverconnectionprovider.aspx [[howtonh:howtonh:/blogs/nhibernate/archive/2008/09/18/extending-nhibernate-s-driverconnectionprovider.aspx|here]]

Dynamically change user info in connection string

oorduz — Sat, 29 Nov 2008 00:41:57 GMT

Revision 2 posted to How to by oorduz on 28/11/2008 09:41:57 p.m.

Dynamically change user info in connection string

In some cases our clients has to use the same database user id in each connection, so they can use audit and security features of their database system (and their DBAs will be happy [:)]).

To do that in Nh We can use the ConnectionProvider facility. Just derive a class from the standard DriverConnectionProvider class:

public class DynamicConnectionProvider : DriverConnectionProvider

{

private string _connectionString;

Override the Configure method:

public override void Configure(IDictionary<string, string> settings)

{

// Connection string in the configuration overrides named connection string

if (!settings.TryGetValue(NHibernate.Cfg.Environment.ConnectionString,

out _connectionString))

_connectionString = GetNamedConnectionString(settings);

if (_connectionString == null)

{

throw new HibernateException("Could not find connection string setting (set " + NHibernate.Cfg.Environment.ConnectionString + " or " + NHibernate.Cfg.Environment.ConnectionStringName + " property)");

}

ConfigureDriver(settings);

}

This is necessary because the original connection string is private, but just copy the code from base method.

The real magic is in "ConnectionString" property, it is called when nh has to connect in a Session. You have to override it so you can make the changes you need.

protected override string ConnectionString

{

get

{

return FixConnectionString(_connectionString);

}

In this case "FixConnectionString" read the user info from some environment variable and inject it in the connection string.

Finally configure Nh to use the ConnectionProvider:

<property name="connection.provider">MyAssembly.PsDynamicConnectionProvider, "connection.provider">MyAssembly.DynamicConnectionProvider, MyAssembly </property>

Some useful articles:

http://japikse.blogspot.com/2008/06/custom-connection-provider-with.html

and

http://nhforge.org/blogs/nhibernate/archive/2008/09/18/extending-nhibernate-s-driverconnectionprovider.aspx

Dynamically change user info in connection string

oorduz — Sat, 29 Nov 2008 00:29:02 GMT

Revision 1 posted to How to by oorduz on 28/11/2008 09:29:02 p.m.

In some cases our clients has to use the same database user id in each connection, so they can use audit and security features of their database system (and their DBAs will be happy [:)]).

To do that in Nh We can use the ConnectionProvider facility. Just derive a class from the standard DriverConnectionProvider class:

public class DynamicConnectionProvider : DriverConnectionProvider

{

private string _connectionString;

Override the Configure method:

public override void Configure(IDictionary<string, string> settings)

{

// Connection string in the configuration overrides named connection string

if (!settings.TryGetValue(NHibernate.Cfg.Environment.ConnectionString,

out _connectionString))

_connectionString = GetNamedConnectionString(settings);

if (_connectionString == null)

{

throw new HibernateException("Could not find connection string setting (set " + NHibernate.Cfg.Environment.ConnectionString + " or " + NHibernate.Cfg.Environment.ConnectionStringName + " property)");

}

ConfigureDriver(settings);

}

This necessary because the original connection string is private, but just copy the code from base method.

The real magic is in "ConnectionString" property, it is called when nh has to connect in a Session. You have to override it so you can make the changes you need.

protected override string ConnectionString

{

get

{

return FixConnectionString(_connectionString);

}

In this case "FixConnectionString" read the user info from some environment variable and inject it in the connection string.

Finally configure Nh to use the ConnectionProvider:

<property name="connection.provider">MyAssembly.PsDynamicConnectionProvider, MyAssembly </property>

Some useful articles:

http://japikse.blogspot.com/2008/06/custom-connection-provider-with.html

and

http://nhforge.org/blogs/nhibernate/archive/2008/09/18/extending-nhibernate-s-driverconnectionprovider.aspx