Re: [Firebird-net-provider] Order of parameters to stored procedure

[Shreekar J. <Shr...@kp...>]

Thanks for that.

However, since the SP I am trying to execute does not return any values,
(only insert/update/delete in the SP), select... from SP is not an
option.

Actually, I am stuck on this issue with NHibernate where NHibernate
cannot successfully execute the SP which does not return a value. But, I
tested with SQL Server and NHibernate successfully executes the SP which
does not return a value when SQL Server is used.=20

Hence, I was wondering if this had something to do with the provider.=20

About getting names and order of parameters from database, is it a good
idea to cache the SP params and orders at application level (maybe in a
singleton class hashtable)? This implementation will be in a windows
forms application and not web based.

Shreekar Joshi=20


-----Original Message-----
From: fir...@li...
[mailto:fir...@li...] On Behalf
Of Jiri Cincura
Sent: Wednesday, November 14, 2007 3:23 PM
To: For users and developers of the Firebird .NET providers
Subject: Re: [Firebird-net-provider] Order of parameters to stored
procedure

If you will use "select ... from SP ..." and not
CommandType.StoredProcedure, you can use named parameters.

Getting parameters names from stored procedure is possible, but it's a
one roundtrip to database, which isn't good for performace.

--=20
Jiri {x2} Cincura (Microsoft Student Partner)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com

------------------------------------------------------------------------
-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider