I changed .hbm.xml to the following even that it not working
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" auto-import="true"
assembly="MockTest" namespace="MockTest.Models" >
<sql-query name="GetMeasures" callable ="true">
<return class="MockTest.Models.Measures, MockTest">
<return-property column="MemberID" name="MemberID" />
<return-property column="Appointmentid" name="Appointmentid" />
<return-property column="LastName" name="LastName" />
<return-property column="FirstName" name="FirstName" />
<return-property column="MiddleName" name="MiddleName" />
<return-property column="ApptDateTime" name="ApptDateTime" />
<return-property column="Service" name="Service" />
<return-property column="ApptProviderID" name="ApptProviderID" />
<return-property column="ApptProviderName" name="ApptProviderName" />
<return-property column="ApptFacilityID" name="ApptFacilityID" />
<return-property column="ApptFacilityName" name="ApptFacilityName" />
<return-property column="PrimaryProviderID" name="PrimaryProviderID"
/>
<return-property column="PrimaryProviderName"
name="PrimaryProviderName" />
<return-property column="PrimaryFacilityID" name="PrimaryFacilityID"
/>
<return-property column="PrimaryFacilityName"
name="PrimaryFacilityName" />
<return-property column="MeasureData" name="MeasureData" />
</return>
exec dbo.spGetMeasureValues :DiseaseStateName,
:Location,:Physicians,:StartDate,:EndDate, :RiskList
</sql-query>
</hibernate-mapping>
On Tuesday, May 21, 2013 12:25:06 PM UTC+5:30, Ricardo Peres wrote:
>
> Yes, in NHibernate you always use : as the parameter prefix, regardless of
> the actual database server.
--
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/nhusers?hl=en-US.
For more options, visit https://groups.google.com/groups/opt_out.
