Multiple projects in Visual Studio 2012

I have a solution in .NET that has multiple projects.

Project 1 - Database Project

Project 2 - ASP MVC Project

Project 3 - C# Project - NHibernate models, desginer model and nHibernateSessionHelper class.

Here are my questions:

1. Where would I add the hibernate configuration? All of my nhibernate references and libraries are in Project 3. When I add the configuration in the web.config of Project 2, it complains of missing NHibernate libraries, that is fixed after I add the missing libraries, but now I have NHibernate libraries in two projects. I am tring to keep them isolated.

2. Is it possible to access multiple databases using the designer? Some example configurations/sample code would really help.

Regards,

Sameer Jaffer

You can either add the configuration in your web.config and reference the NHibernate libraries to support loading that configuration as you have found or you can include the configuration as an embedded resource (e.g. in your Project 3 assembly) and then load the configuration from the resource instead.

I believe you would specify it like this in code for loading the configuration:

Configuration configuration = new Configuration().Configure(typeof(MyEntityType).Assembly, "MyApp.hibernate.cfg.xml");

In terms of multiple databases, this is possible but not on the same model, you will need to create one model per database.

Jeremy