I'm working on an existing system that has generated code that is no longer wanted. It's a matter of migrating from the generated code that uses ADO.NET to NHibernate.

The generated code allows the developer to select a connection string by name at run-time depending on the system that makes the call to the Data Access Layer.

I want some recommendations on methods of implementing the same choice for our developers with NHibernate easily. Currently I can see some information on pointing NHibernate to use an App.Config connection string, but if I want to give the developers a choice from the available connection strings within the App.Config how would I go about doing this?

Any help is generally appreciated.

Hibernate version: 2.0.0

1/ If it's different schemas, the mapping file supports a schema attribute on the hibernate-mapping bit.

2/ If it's different databases, I'd use Spring.Net and the MultiDelegatingDbProvider for that functionality. You will need a session factory for each database.

3/ If it's different configurations, manage this with system.configuration (write your own config section handler for it).

I'm using Spring with Java so it makes sense to try and replicate what works well into the .NET projects.

All three suggestions make sense. Appreciated.