• Just for the completeness, there is another great way to send multiple rows to database from the client side and it's covered in many articles usually under the title "streaming data". I used this article "http://www.sqlservercentral.com/articles/SQL+Server+2008/66554/" to implement one with a great success. This may require more work on the client side but if the number of rows is very large (in my case it was around 100K), the speed of this method is on par with BULK solutions.

    Hope it helps,

    Sinan