Does anyone know if mapping a property to a stored procedure should
work?

<id name="MyId"  type=Guid">
    <generator class="assigned"/>
</id>
<property name="MyProperty" access="nosetter.camelcase"
formula="( EXEC MyStoredProc MyId )" />

The generated SQL is something like:

SELECT
this_.MyId as xxxxxxxx
this_.EXEC this_.MyStoredProc this_.MyId as formula_0
FROM MyTable this_

where i am trying to get:

SELECT
this_.MyId as xxxxxxxx
EXEC MyStoredProc this_.MyId as formula_0
FROM MyTable this_

I am trying to create a boolean readonly property that is populated by
a IF EXISTS (SELECT ... ) query to see if there are rows related to
this table in another table.


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"nhusers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to 
[email protected]
For more options, visit this group at 
http://groups.google.com/group/nhusers?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to