SqlHelper.ExecuteNonQueryTypedParams

  • Thread starter Thread starter Brian Chapman
  • Start date Start date
B

Brian Chapman

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?

Thanks, Brian
 
Brian said:
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?
Click to expand...

I might miss something, but where can I find the SqlHelper class?

Frans.
 
Brian said:
SqlHelper is part of the Data Access Application Block.
Click to expand...

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.
 
Back
Top