DataAdapter

  • Thread starter Thread starter Tony Johansson
  • Start date Start date
T

Tony Johansson

Hello!

I wonder when is it advisable to set the update, insert or delete command
explicitly by using DataAdapter.
instead of using the SqlCommandBuilder.

Does this SqlCommandBuilder build insert, update and delete command that is
wrong in some way or what is the reason.

//Tony
 
Tony said:
Does this SqlCommandBuilder build insert, update and delete command that is
wrong in some way or what is the reason.
Click to expand...

Not necessarily wrong, but it is a pretty simple straight-forward tool.
You will often be able to optimize by removing unnecessary columns from
where clauses for example.

And when dealing with a slightly more complex situation, like a Join in
the Select statement, CommandBuilder will give up and you will have to
write the SQL by yourself.
 
Back
Top