And can you run the query (calling the stored procedure) by using CreateSQLQuery?
On Tuesday, May 21, 2013 8:22:34 AM UTC+1, Shravan Yadav wrote: > > 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.
