I have a class that is mapped to a view. I do this because some of the attributes of the class are denormalized from other tables. When I attempt to delete an instance of my class, I get the following SQL Server error:

View or function 'MooView' is not updatable because the modification affects multiple base tables

Question: Is it possible to change my NHibernate mapping so that the delete is executed against the actual table (Moo) rather than the view (MooView)?

Here's what the relevant portion of my mapping file looks like:



Note that the class is mapped to a view that spans two tables: Moo and Baa. "BaaName" is a derived value obtained from the Baa table rather than the Moo table, hence it is marked as insert/update = false.

How can I delete an instance of Moo?

To do that, you'd need to use the sql-delete element under the class element. NHibernate doesn't support that (it was added in hibernate3). So no, you can't use session.delete if you use that view. Either do your denormalization in your mapping file, or use raw SQL.

A bit late, I know, but I'm new here....

You should be able to get around this problem by adding an INSTEAD OF trigger to the view.