PC Review Forums Newsgroups Microsoft DotNet Microsoft ADO .NET what is similar to Adodb.Stream for blobs?

Reply

what is similar to Adodb.Stream for blobs?

 
Thread Tools Rate Thread
Old 25-08-2003, 04:00 PM   #1
bill dawson
Guest
 
Posts: n/a
Default what is similar to Adodb.Stream for blobs?


Hello all,
I've seen a lot of sample code out there that, for example, puts an image up
to SQL Server by first reading it in a stream and setting it to a byte
array, then putting that byte array as the value of a SqlParameter.

It seems like this duplicates effort in some way. I mean, with Adodb.stream
we could set a stream to the value of a Recordset field. I'm not really
sure what then happened behind the scenes when we did that -- perhaps
everything got sucked into a byte array in memory at one time, but I always
kinda assumed something more "memory friendly" was happening (like buffer,
send, buffer, send...), assuming the connection was open.

Isn't there something we can do in .NET to eliminate the step of filling up
a byte array just in order to then put it as the value of a SqlParameter, in
other words, something we can do to send the stream that loaded the image
itself as a parameter?

thank you,
Bill Dawson


  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off