SQLServer 2005 View

Iban121 · **Joined:** Wed Nov 21, 2007 1:27 pm **Posts:** 4

NHibernate version: 1.2.0.GA
Database: SQLServer 2005 SP1

Hi everybody. I need to map an SQL View with NHibernate.
I just tried to map it like a table, but my view don't have any Identifier (just readonly data)... apparently NHibernate force my to define an identifier. Is there any way not to define an identifier or is the View mapping different as Table mapping ?

Thanks a lot.

karlchu · **Posted:** Wed Nov 21, 2007 7:12 pm

As far as NHibernate is concerned, mapping to a table and a view are the same. You must define an identifier in the <class> mapping. If your view has a natural key, you can perhaps use <composite-id> to uniquely identify a row.

Iban121 · **Joined:** Wed Nov 21, 2007 1:27 pm **Posts:** 4

karlchu wrote:

As far as NHibernate is concerned, mapping to a table and a view are the same. You must define an identifier in the <class> mapping. If your view has a natural key, you can perhaps use <composite-id> to uniquely identify a row.

In fact I don't have a natural key and no column is unique. My view just represent readonly raw data.

karlchu · **Posted:** Thu Nov 22, 2007 11:42 am

<composite-id> uses two or more columns to uniquely identify a row. If you don't have that, NHibernate cannot map to it. Next best thing you can do is to use a <sql-query>. Come to think of it, it is probably the right thing to recommend in the first place. Have a look and see if it suites your needs.

Iban121 · **Joined:** Wed Nov 21, 2007 1:27 pm **Posts:** 4

karlchu wrote:

<composite-id> uses two or more columns to uniquely identify a row. If you don't have that, NHibernate cannot map to it. Next best thing you can do is to use a <sql-query>. Come to think of it, it is probably the right thing to recommend in the first place. Have a look and see if it suites your needs.

Thanks ! I think than sql-query is a good option because it's realy specifing need.