Geek Answers Handbook

NHibernate - generate a domain from a database

I know that it can generate database tables from a domain model. But is there a way to do things differently. I have an absolutely terrible database (the worst I've ever seen). Its shard (16 Shards !!), divided into several postgres databases (all on one server) with external key relationships such as urn: dbtable: guid.

It proves a big pain in the ass for migrating using SSIS, so I want to use NHibernate, read data in objects, and copy to SQL Server database in a blissful harmony of data and architectures.

Is there a way to scan the current database using NH or another and build a domain model and mappings?

Thanks!

+4
source share
2 answers

NHibernate Mapping Generator
- a simple utility for creating NHibernate mapping files and corresponding domain classes from existing DB tables

It's free.

+11
source

There are commercial tools that can generate everything from a database model.

Check out http://nhibernate.info/doc/commercial-product-ecosystem.html

0
source

More articles:


All Articles