Mapping classes to multiple databases

Question

How do I make NHibernate.Tool.hbm2ddl.SchemaExport to export certain classes in one database, and certain in another one? E.g. Person class should be mapped to a database with one connection string, and Product should be saved to a different database, so SchemaExport should create a Person table in one DB, and a Product table in the second one.

I defined NHibernate mappings for my classes, but I don't know where to specify the database/connection string for each class separately.

Firo · Accepted Answer · 2012-10-16 15:08:46Z

1

Mappings are Database independent, there is no way to define a connectionstring in them. Build up two configuration objects, one for each database and add all classes to appropriate configuration. Then use Schemaexport for each config.

var config1 = new Configuration()
    .AddClass(typeof(Person))
    .AddClass(typeof(Customer))
...

new SchemaExport(config1).Create(false, true);

var config2 = new Configuration()
    .AddClass(typeof(Product));

new SchemaExport(config2).Create(false, true);

edited Oct 16, 2012 at 15:08

answered Oct 16, 2012 at 12:45

Firo

30.8k4 gold badges57 silver badges97 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Lou Over a year ago

all classes to appropriate configuration - that's the part I am not sure how to do.

Lou Over a year ago

Many thanks! The AddClass method seems to be what I was looking for. I was using AddAssembly simply by inertia, from all the web examples, didn't even think I could have finer granulation using AddClass.

Collectives™ on Stack Overflow

Mapping classes to multiple databases

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related