>To repeat : The Update command is constructed based on the Select command
>
>You're selecting everything so it's updating everything.
>
My point is - why does it even update PK column and why does it construct such ugly where clause?
Assuming I will only change the UpdateCommand.CommandText manually, will it still work?
If it's not broken, fix it until it is.
My Blog