Olli-Pekka Isola comments

Repositories
Issues
Comments

Results 2 comments of


                                            Olli-Pekka Isola

Bulk inserts

I welcome this idea. I have achieved high throughput by implementing System.Data.IDataReader interface over System.Collections.Generic.IList collections and by letting System.Data.SqlClient.SqlBulkCopy class to read its input via IDataReader implementation. Works for...

Bulk inserts

Well, IDataReader is .NET Framework construct, ie. database agnostic. SqlBulkCopy is MS SQL specific class. Oracle and few others support MERGE INTO. Take a look at http://en.wikipedia.org/wiki/Merge_%28SQL%29. I have personal...