Does NHibernate support mapping from SQL Views?

Question

Does NHibernate support mapping of SQL VIEWS? Any examples would be helpful.

Answer 1

Yes, just use your view name instead of the table name in your mapping config. Of course it will throw an exception if you try to update though.

e.g.:

<class name="someclass" table="vw_someview">
...
</class>

Answer 2

The simple answer is: Yes.

Just put your view's name in the places where normally in all the examples is written a table name. That's it. Views and tables are interchangeable - as long as the view is writeable without constraints...

Thomas

Answer 3

Yes. You can update or insert to views in SQL Server if certain conditions are met, see the Updateable Views section in the documentation. I know this applies to SQL Server 2005+, I don't know about earlier versions.

If the view is not updateable, you can declare the mapping as read-only.