Comments on Derek says:: Bulk upsert to SQL Server from .NET

@outofcoolnames Not put this into Simple.Data, no....

2012-01-22T16:01:07.220Z

@outofcoolnames
Not put this into Simple.Data, no. Last I checked Mark had implemented an alternative but it may be worth revisiting.

@Mickey
First off the upserter doesn't do deletes, it's update and insert only.

The upserter uses IDataReader instead of something like DataSet as this makes it usable in a wider set of data access scenarios - not everyone uses DataSets but most probably have, or could easily create, an implementation of IDataReader.

I'm using a bulk copy to transport the data to the database rather than individual insert and update commands you would get from the likes of a DataAdapter as it is far more efficient.

Also, in high volume scenarios, by using an IDataReader it's possible to stream a large amount of data from a source up to your database without having that entire set of data resident in memory.

Not to be a spoil sport, but why did you reinvent ...

2012-01-22T15:11:31.766Z

Not to be a spoil sport, but why did you reinvent the dataset object instead of relying on it ?

I think it would make more sense to for me to tell you what table on the dataset you are to upsert, and you can reuse the datatable adapter and commands which have been already programmed for update and insert and delete, no ?

Am I missing something ?

Hi Derek, Did you get around to integrating this i...

2012-01-18T17:08:00.235Z

Hi Derek,
Did you get around to integrating this into Simple.Data? I've had a quick look at some of the code within Simple.Data and don't see your stuff but I giess it may have changed...
Regards,
Thomas

Have you added bulk upsert functionality to your e...

2011-09-15T17:32:46.170+01:00

Have you added bulk upsert functionality to your excellent Simple.Data project?

Nice one. I'll be adding that into Simple.Data...

2011-05-16T08:48:14.126+01:00

Nice one. I'll be adding that into Simple.Data soon then.