I have no control over the database I am mapping to.

There are a number of columns that I do not care about in my object model and so don't want to map in my class.

But these columns need default values setting on insert (the default values are specific to my application, not set in the DB).


How do I can get NHibernate to populate these unused columns on insert, ignoring them forever after?


I assume I somehow need to use <sql-insert/> but I can't work out exactly how I'd do it.[/list]

I think you still need to map them if there are no defaults in the DB. You could map the fields to private members of your objects which are set with the default values and do the mappings as update = false.

Not sure if this helps, but there you go anyway.

Cheers,

Symon.

Thanks Symon. I was afraid I'd have to do that. Seems messy to pollute my domain model with fields that my app doesn't know about, but it could be worse.

Thanks for the reply.

To reduce the problem, I would advice you to define private field that you init with default values, but obviously without any public getter/setter. Maybe even accessing those fields with access method "field" would be a good idea?

Furthermore, you may be able to clean-up your class declaration by representing these private fields in a component. I suppose this is a matter of preference since both solutions are equivalent.