ado.net 2.0 inserting and getting blob columns

10 Dec 2004 4:08 PM

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?

13 Dec 2004 10:22 PM

Pablo Castro [MS]

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.

Show quote

"dgxhubbard" <dhubb***@opentext.com> wrote in message
news:1102694913.045330.271790@z14g2000cwz.googlegroups.com...
> 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?
>