one to one mapping to a view

yummy · **Joined:** Thu Aug 24, 2006 10:46 pm **Posts:** 2

Can i have an one to one mapping from a table to a view?

main table : AAA
primary key : IP_ID

view : BBB
has a field : IP_ID

I try to do a one to one assosiation.
But i got a exception :
NHibernate.MappingException: An association from the table AAA refers to an unmapped class: BBB

Please tell me the solution.
Thanks.

tenwit · **Joined:** Thu Dec 23, 2004 9:08 pm **Posts:** 2008

If you map an entity onto the view, then yes. If you don't want to map the view, consider using the <join> tag to do this.

Don't forget to mark all properties provided by the view as insert="false" update="false" (unless you're using one of those weird updatable-view DBs).

yummy · **Joined:** Thu Aug 24, 2006 10:46 pm **Posts:** 2

Thanks for your kindly response.
But how can i do to use the <join> tag to do this?
Can you give an example?

tenwit · **Joined:** Thu Dec 23, 2004 9:08 pm **Posts:** 2008

I've looked through the Hibernate 2.1 DTD (I think that's what NHibernate uses), and there's no join tag. You're out of luck on that front, sorry. Looks like you'll have to map the view as a separate entity. You can mark it mutable="false" to avoid having to put all those insert="false" update="false" things on each property in the view.