ADO.NET: GETCHUNK & APPENDCHUNK

[=?Utf-8?B?QUEyZTcyRQ==?=]

ADO has GetChunk & AppendChunk, features that are not supported by ADO.NET.

Is there a workaround in ADO.NET?
I am trying to write large files to LOB fields in a database table.

[Nicholas Paldino [.NET/C# MVP]]

When reading data from the database, call ExecuteReader on the
SqlCommand you are issuing, passing CommandBehavior.SequentialAccess. This
will allow you to call GetBytes or GetChars, specifying the range of bytes
you want to read from the database.

Granted, you have the option of reading the entire contents from the
database as well into a byte array.

There is no equivalent to write the data to the database. You will have
to place the data into a byte array and pass that byte array as a parameter
to whatever method you are using to save the data to the database. Granted,
the story here could be a little better, since for very large pieces of
data, it's not practical to load the complete contents into memory.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"AA2e72E" <AA*****@discussions.microsoft.comwrote in message
news:68**********************************@microsof t.com...

ADO has GetChunk & AppendChunk, features that are not supported by
ADO.NET.

Is there a workaround in ADO.NET?
I am trying to write large files to LOB fields in a database table.

[Marc Gravell]

For an example of writing in chunks:
http://groups.google.co.uk/group/mic...4e7e3782e59a93

Note that this does one round-trip per chunk, so you might want to
upsize the chunks a little - but try to stay in multiples of 8040 for
best performance. The example uses the older SQL syntax;
varbinary(max)/etc have slightly different syntax.

Marc