DataAdapter

[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

 

[henk holterman]

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

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.