Hey people. I have been using NHibernate now for about a year and have manage to solve all my problems by reading the API and googling. I have come to a point now where I am a bit lost, and I can't seem to find an answer. This might be as much a Hibernate question as an NHIbernate question.

So my problem is this: I have to persist some sdo_geometry records in Oracle. I get new records via wkt_geometry (which is a big string), and i use an Oracle function to convert them into geometry objects. i use another function to covert geomtries back into wkt. The application layer needs to use these objects as wkt (well known text), and the database layer needs them as sdo_geometries. I also need to use Oracle functions to do the conversion.

At first i thought of making a custom type, but after playing around with it, it appeared that it was taking the data from oracle before I could apply the Oracle function to it.

I then started looking at including some SQL to load this to a string, but I also have to use different SQL to update and insert it, and I'm not sure how to do that on a per record basis (with in the XML mapping doc that is).

I would greatly appriecate any help in this matter.