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. Hence, I was wondering if this had something to do with the provider. 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 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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. -- 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 [email protected] https://lists.sourceforge.net/lists/listinfo/firebird-net-provider ------------------------------------------------------------------------- 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 [email protected] https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
