in

System.Data.SQLite

An open source ADO.NET provider for the SQLite database engine

Writing a BLOB to the database in chunks.

Last post 09-02-2009 4:05 AM by liron. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 03-23-2009 9:08 PM

    Writing a BLOB to the database in chunks.

    Hey, I'm developing an application for CF where I need to store images in the database. Due to memory constraints, I can't use a byte array, I have to use streams.

     I've created a BlobStream to read images out of the database, however writing images to databases in chunks are proving difficult.

    The BlobStream uses DbDataReader.GetBytes() to read data out in chunks, but I can't find an equivalent method to write data. Is there such a thing in ADO.NET?

     

    Any other suggestions?

     

  • 09-02-2009 4:05 AM In reply to

    • liron
    • Top 50 Contributor
    • Joined on 06-14-2008
    • Posts 29

    Re: Writing a BLOB to the database in chunks.

    This may come late but maybe it will be of interest to other users.. See my reply to another (similar) post request: http://sqlite.phxsoftware.com/forums/p/1110/7371.aspx#7371. Specifically see the included file for reference code. Liron
    Filed under:
Page 1 of 1 (2 items)
Powered by Community Server (Commercial Edition), by Telligent Systems