Too many Updates to do
Hello. I'd want to know how does a .net application work when we have to do too many updates, I want to say for example 1000 updates on a file at the same time.
For only one update, if I'm rigth, we send to a procedure:
the connection and the sql statement I want.
The procedure, open the connection, execute the sql statement and close the connection.
But, If I have 1000 updates to do at the same time ? I can't open and close the connection for each update ? It's not logic, I guess...
Could anyone tell me how can I do that ?
Thanks....

