chunking in binary (BLOB) data for generic providers

Tech-Archive recommends: Fix windows errors by optimizing your registry

I think that the answer is no, but is there a generic way to insert BLOB data into a table in a generic method via ADO.Net in blocks/chunks? From reading all examples, questions, and other information I can find on various web sites, newsgroup posts, etc, it appears to be no.

For example, if I have a large binary object that I want to store in a database (ignoring the philosophical debate of whether this should be in the database), I certainly don't want to load a 100MB of data and transmit it across the wire in one piece.

All other database access methods (ODBC via SQLPutData, JDBC, etc) support inserting data in chunks. Reading MSDN docs, it appears that old ADO does.
(http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q308042)

ADO.Net doesn't appear to:
http://support.microsoft.com/kb/317016/

The only thing I see even close to it is using proprietary SQL2005 extensions for update.write.
http://msdn2.microsoft.com/en-us/library/a1904w6t.aspx
http://staceyw.spaces.live.com/Blog/cns!1pnsZpX0fPvDxLKC6rAAhLsQ!404.entry

This seems to be a step backwards from ADO and even ODBC.
.

Relevant Pages

  • Re: Which database support?
    ... ADO is likely the better way to go, although ODBC is a close second. ... but *only* if the target database is based on the MSFT Jet Engine ... ADO is built on OLEDB; Both are based on a set of interfaces defined by ...
    (microsoft.public.vc.mfc)
  • Re: Regarding fastest database interaction with Oracle in VC++
    ... access Oracle database using VC++. ... It only use ODBC if the OLE DB provider for ODBC is used as the ADO ... Using native OLD DB providers with ADO is fastest and does not use ODBC. ...
    (microsoft.public.vc.database)
  • Re: Which database support?
    ... it presumes that the user is apparently interacting with the database through ... >ADO is likely the better way to go, although ODBC is a close second. ... >ADO is built on OLEDB; Both are based on a set of interfaces defined by ...
    (microsoft.public.vc.mfc)
  • Re: Which database support?
    ... it presumes that the user is apparently interacting with the database through ... >>ADO is likely the better way to go, although ODBC is a close second. ... >>ADO is built on OLEDB; Both are based on a set of interfaces defined by ...
    (microsoft.public.vc.mfc)
  • ADO Vs ODBC Data types and formatting
    ... I am replacing a VB5 application that handles database communication ... directly through ODBC API calls with a VB5 application that uses ADO ... I am having some issues with mapping the data types returned by ODBC ...
    (microsoft.public.vb.database)