Mohamed, try to complete the answer with more context instead say what Diego
should explain ;)
btw I'm having some doubts about Diego's answer basically because this test
should fail
[Test]
public void ScalarStoredProcedure()
{
ISession s = OpenSession();
IQuery namedQuery = s.GetNamedQuery("simpleScalar");
namedQuery.SetInt64("number", 43L);
IList list = namedQuery.List();
object[] o = (object[])list[0];
Assert.AreEqual(o[0], "getAll");
Assert.AreEqual(o[1], 43L);
s.Close();
}
but with this mapping
<sql-query name="simpleScalar">
<return-scalar column="name" type="string"/>
<return-scalar column="value" type="long"/>
exec simpleScalar :number
</sql-query>
it is working2010/1/30 Mohamed Meligy <[email protected]> > No offense, but, specifically in the ALT.NET world, and more specifically > in NHibernate, isn't it too frequent to hear "this is not supported" / "this > is not the way it works" / ... followed by the other sentence "FOR GOOD > REASONS" or something equivalent? > > Was just thinking ... > > Regards, > > -- > Mohamed Meligy > Senior Developer, Team Lead Backup (.Net Technologies - TDG - Applications) > Injazat Data Systems > P.O. Box: 8230 Abu Dhabi, UAE. > > Phone: +971 2 6992700 > Direct: +971 2 4045385 > Mobile: +971 50 2623624, +971 55 2017 621 > > E-mail: [email protected] > Weblog: http://weblogs.asp.net/meligy > > > > On Sat, Jan 30, 2010 at 8:12 PM, Diego Mijelshon > <[email protected]>wrote: > >> Yes. And for good reasons. >> >> Diego >> >> >> >> On Thu, Jan 28, 2010 at 06:46, Asier <[email protected]> wrote: >> >>> Hello >>> >>> Is true that Nhibernate doesn’t support stored procedures output >>> parameters? >>> Thanks. >>> >>> -- >>> 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]<nhusers%[email protected]> >>> . >>> For more options, visit this group at >>> http://groups.google.com/group/nhusers?hl=en. >>> >>> >> -- >> 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]<nhusers%[email protected]> >> . >> For more options, visit this group at >> http://groups.google.com/group/nhusers?hl=en. >> > > -- > 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]<nhusers%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/nhusers?hl=en. > -- Fabio Maulo -- 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.
