As you can see the Product was retrieved from Northwind and the Supplier from Northwind2. This is usually not a problem, but on update triggers in the database might be executed even when no changes have been made to detached instances. VS will then generate the source code of your domain model classes based on the database tables you added. Is it extra overhead to use Fluent Nhibernate if we are writing mapping file to connect to both databases given that we have alternatives? The foo object still knows which ISession it was loaded it.
nest...