VIEWS and Fluent NHibernate?

Question

It's possible to map a VIEW using Fluent NHibernate? If so, how?

score 19 · Accepted Answer · edited Feb 25 '11 at 02:09

19

I would think you could just replace your the table name with your view name using the WithTable method:

WithTable("myview");

Edit: Just to update this answer, Fluent NHibernate now uses:

Table("myview");

edited Feb 25 '11 at 02:09

Phill

18,398
7
62
102

answered May 07 '09 at 15:50

mxmissile

11,464
3
53
79

2

What if this view doesn't have any primary key? – Johnny_D Apr 26 '12 at 10:33

score 3 · Answer 2 · answered May 07 '09 at 15:54

3

mxmissile's answer is correct but I wanted to add that the view will have to be updateable (SQL Server term.) if you want to do inserts or updates against it. I have several tables mapped against views that filter out inactive records because these tables allow soft deletes.

answered May 07 '09 at 15:54

Jamie Ide

48,427
16
81
117

1

If I recall, these "updateable" views are title Indexed Views? It's been awhile since I had to deal with this stuff. – mxmissile May 12 '09 at 22:04

VIEWS and Fluent NHibernate?

2 Answers2