Using NHibernate with output parameters

Question

Does anyone know if NHibernate supports returning output parameters from stored procedures? I've had a search in the documentation but can't really find anything that confirms either way.

Rohit Agarwal · Accepted Answer · 2009-06-18 19:52:39Z

7

I was facing the same problem. NHibernate does not let you use stored procedures in this manner. But it does allow a way to make calls using the plain old ADO.NET API. Here's an example -

http://refactoringaspnet.blogspot.com/2009/06/how-to-use-legacy-stored-procedures-in.html

answered Jun 18, 2009 at 19:52

Rohit Agarwal

4,2893 gold badges29 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jon Adams · Accepted Answer · 2009-01-28 02:29:49Z

3

I can't officially confirm for you, but as far as I know, not directly. Stored procedure use in NHibernate is very specific to doing standard CRUD.

If you want to grab output paramaters (that are't the standard row count output parameter for INSERT, UPDATE, and DELETE), you could fall back to a different (or the standard) database access tools that give you direct access to SQL and the result set. (Assuming you can get by with bypassing NHibernate's cache. You'll want to make sure you flush NHibernate before you run the query too, etc.)

answered Jan 28, 2009 at 2:29

Jon Adams

25.3k18 gold badges85 silver badges122 bronze badges

Collectives™ on Stack Overflow

Using NHibernate with output parameters

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related