Is there a way to use SqlBulkCopy without converting the data to a DataTable? I have a list of objects (List) in RAM and I really don't want to use more memory to create the DataTable. Could it be possible to implement IDataReader on a List?
I would certainly imagine that you could.
BulkDataReader requires schema information; that's why you can't simply provide a
List. If you design a class that implements
IDataReader, you'll be providing this in your
I would simply create a
DataTable myself, unless I could demonstrate a real memory issue that would justify the implementation.