stored procedures ?

[Jarod]

Hey
I have class that gets data through stored procedures what's best technique
to use stored procedures ? For example now I am using a bit modified
SqlHelper class... I know about enterprise library but it wasn't possible to
use it up to know. But know I build project on ASP.Net does it have
something comfortable to use stored p. ?
Jarod

 

[Q. John Chen]

Here is my take beyond your original question.

1. Always use SP, Or at least Parametized SQL Text (if have param)

2. In .NET 1, I like SqlHelper (or the old Application Block). The
Enterprise Library is better but it take some extra time to figure it
out (configuration, coding, and deployment).

3. In .NET2.0, there is already things like ConfigurationManager etc.
So not sure whether EL helps or not. or new EL?