ado.net 2.0 inserting and getting blob columns

  • Thread starter Thread starter dgxhubbard
  • Start date Start date
D

dgxhubbard

Has retrieving and inserting blobs been updated in ado.net 2.0. I have
read examples for 1.0 and 1.1 and understand what to do there. I have
been developing Odbc applications and use the bcp api and thought it
was SqlBulkCopy but that is for row inserts. I did see something about
about SqlBulkCopyColumnAssociation but there is no mention of it in the
beta 1 refresh. Also there is the type SqlBytes which has a Fill method
but no examples of useage in the docs. Should I stick with 1.0 and 1.1
method or is there another way?
 
Hi,

We didn't do any major change to the API for handling blobs. For blob
retrieval, you can use CommandBehavior.SequentialAccess and
GetBytes/GetChars to get a chunk at a time and avoid buffering the whole
value in memory at once. That is already available in previous versions and
will continue to be the way of retrieving blobs in 2.0.

--
Pablo Castro
Program Manager - ADO.NET Team
Microsoft Corp.

This posting is provided "AS IS" with no warranties, and confers no rights.
 
Back
Top