How SqlDataAdapter works internally?
- by tigrou
I wonder how SqlDataAdapter works internally, especially when using UpdateCommand for updating a huge DataTable (since it's usually a lot faster that just sending sql statements from a loop).
Here is some idea I have in mind :
It creates a prepared sql statement (using SqlCommand.Prepare()) with CommandText filled and sql parameters initialized…