Search code examples
nhibernateactiverecordcastle-activerecord

How to map a database view using ActiveRecord?

Has anybody tried mapping database views in oracle using ActiveRecord? Please can I get some sample code for that?

Solution

  • No code necessary: just use the view name instead of the table in your [ActiveRecord] attribute:

    [ActiveRecord("MyView")]
public class Document {...}

    Be aware that SchemaExport will treat your view as a table, here's how to fix that.