.net: Converting a Generic List to a DataReader?

Question

Hi I have a Populated Generic List in a winform and now wanna to send its data into a SQL server table as a bulk Copy. As I read the SqlBulkCopy Class, it needs a data reader as a source.

Now, how can I convert it to a DataReader?

Thank you

See this answer for converting a generic list to a DataTable: http://stackoverflow.com/questions/564366/generic-list-to-datatable — Andy Rose, Feb 01 '11 at 08:41

score 4 · Accepted Answer · edited May 23 '17 at 09:58

4

You can convert it to DataTable and send to SqlBulkCopy. It would be much easier, and there is no performance penalty, because all data is already present in memory.

There is similar question on SO.

edited May 23 '17 at 09:58

Community

1
1

answered Feb 01 '11 at 08:31

gor

11,498
5
36
42

score 2 · Answer 2 · answered Feb 01 '11 at 08:33

If the data-volume is sane enough to exist as a List<T>, you might as well just construct a DataTable and push the data in that way. I don't like DataTable, but it does this job nicely. The alternative would be to write a custom IDataReader implementation like this, but which iterates over the items in the list each time. I'm not sure it is worth the effort.

.net: Converting a Generic List to a DataReader?

2 Answers2