Hello.

I was wondering if anyone can help me with a specific scenario. In this case, I have a situation where I have a view that returns all the records of a specific type. this view will get its records from "remote tables" (that is, tables that are stored on a different sql instance) which are joined with a local table.

this local table is used to store users that aren't registered on those "remote tables". So, generally, the user will exist on the remote table (or has already been inserted on the local table) and he will be returned by the view. My problem is knowing if there's any way to configure nhibernate to that it will automatically insert a record on that table.

Resuming, is there any way for me to tell nhibernate that loading the objects should be done by using the view and that inserting them should be done on a table?

thanks.

You can specify a custom sql statement for loading objects:

http://www.hibernate.org/hib_docs/nhibernate/1.2/reference/en/html/querysql.html#querysql-load

There you can use the view. Insert, update and delete will operate on the local table. You can also use custom sql for these operatons:

http://www.hibernate.org/hib_docs/nhibernate/1.2/reference/en/html/querysql.html#querysql-cud

If you want a create local entry for each loaded remote user, you have to do a little work. Add a property to your class which indicates the origin of the record. After loading check the property and do a session.SaveCopy if the origin is remote or set the "identity" property to "unsaved-value". Then flush the session and you should have the entries in the local table.

Hello Wolli.

yeah, that might do it! It's just a matter of putting the columns in the correct order and it should work without any problems...thanks!

Another technique I've used quite well on SQL Server, is the use of INSTEAD OF triggers.

You read/write to the view, but the view has a trigger on it to redirect the insert/update to the correct underlying table.