Keeping nhibernate fluent mapping in sync with the database

Question

We are currently using Fluent NHibernate and SQL Server 2008 in our c# development, however, the database schema has become too complex for Fluent to re-create the database when necessary so we are making changes to the database using scripts.

This also means that the entity and mapping classes also need to be changed to remain in sync with the DB schema.

Is there a tool or some clever way of doing this "automatically"?

If we were to use DevForce from IdeaBlade, for example, their framework has tools to check the mapping against the schema and to update the mappings if required and we were wondering if something similar existed for Fluent.

So, ladies and gentlemen, over to you...

Answer 1

Not really. Just update your mappings as you write your script. Chances are you'll be changing your entities as-well anyway.