Can anybody tell me does NHibernet supports views

yes

yes, but be careful if you're using 2nd level cache on the objects

you can use it because i did it. You just have to create your view and use it as a table. However, there is a problem you shouldn't forget : a view is readonly... So you can just display results.

Thanks , for quick response.

also you should use the mutable="false" attribute on the class tag. This avoids that NHibernate takes care of changes in the object.

Regards
Klaus

I view doesn't necessarily have to be read only - this limitation only applies if the view spans multiple tables and an update statement would update fields from more than one table. So, if only properties mapped to a single table are updatable you can update the data in a view.

Note that this is based on SQL Server - YMMV.

Cheers,

Symon.

You must be able to define a unique key on the view too. If the key ends up being a surrogate make sure the surrogate will stay they same across all queries that access the view, ie. don't use a rownumber() function as a surrogate.