Re: Calling Stored Procedures

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Marc Scheuner [MVP ADSI] (m.scheuner_at_inova.SPAMBEGONE.ch)
Date: 03/21/05 

Date: Mon, 21 Mar 2005 08:34:16 +0100

>Like I said, using the SqlParameters collection is a more "clean" way of
>programming,

and the more recommended and the more performant, too - it's just a
matter of fact that using the CommandType = StoredProc results in a
more efficient call than calling the SP through a "EXEC <spname>"
using a CommandType = Text.

Marc
================================================================
Marc Scheuner May The Source Be With You!
Berne, Switzerland m.scheuner -at- inova.ch