Frans
Fri Sep 10 03:16:49 CDT 2004
Brian Chapman wrote:
> SqlHelper is part of the Data Access Application Block.
ah ok :)
Well, I never used it, but looking at the method name, I can imagine it's
the version which uses typed parameters. As the DAAB is a generic solution
which works with various databases, using that method requires that the
actual database provider used supports named parameters.
A lot support named parameters, like the SqlClient provider, the Oracle
provider etc. The OleDb provider used for connecting with Access doesn't. So
if you are going to use your code with Access as well, I think it's better to
avoid this method.
Frans.
>
> Brian
>
> "Frans Bouma [C# MVP]" <perseus.usenetNOSPAM@xs4all.nl> wrote in message
> news:<xn0dn2n6l861v5000@msnews.microsoft.com>...
> > Brian Chapman wrote:
> >
> > > Can anyone post their experience using the ExecuteNonQueryTypedParams
> > > method of the SQLHelper class? It seems a little too easy for
> > > updating rows in a dataset. Is there something I'm missing that's
> > > going to bite in the end?
> >
> > I might miss something, but where can I find the SqlHelper class?
> >
> > Frans.
--
Get LLBLGen Pro, productive O/R mapping for .NET:
http://www.llblgen.com
My .NET Blog:
http://weblogs.asp.net/fbouma
Microsoft C# MVP