I have the following list
Dim ordersToUpdate as New List(Of OrderUpdate)
I am using a "For Each" to iterate and update a legacy DB
For Each order In ordersToUpdate
UpdateDB(order)
Next
I am having a LOCKING problem on the DB when the "ordersToUpdate" is large. Instead to puting a Threading.Thread.Sleep to pause, is there a proper way to break the list up into sections e.g iterating 100 at a time?