c# write big files to blob sqlite

Question

I have c# application which writes files to an sqlite database. It uses entity framework for modelling data. It converts the file to a blob (entity byte[] variable) with this line:

row.file = System.IO.File.ReadAllBytes(file_to_load.FileName); //row.file is type byte[]
                                                               //row is entity class table

This works correctly when the file size is less than 300MB. When the file size is more than 300MB, the app throws an exception:

Exception of type 'System.OutOfMemoryException' was thrown.

How I can write to blob direct, without in-memory variables?

Scorpion · Accepted Answer · 2022-02-12 11:43:20Z

1

You'll have to use so-called Incremental BLOB I/O. See this post on a System.Data.SQLite forum.

edited Feb 12, 2022 at 11:43

Scorpion

7937 silver badges25 bronze badges

answered May 20, 2010 at 13:10

Anton Gogolev

116k39 gold badges204 silver badges293 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

MarkDaniel Over a year ago

For the curious, this (now expired) link went to here but it seems the proposed patch never made it and Incremental Blob IO is still not possible with System.Data.SQLite 1.0.95

Mark Over a year ago

It should be in 1.0.103.0 according to this timeline

Collectives™ on Stack Overflow

c# write big files to blob sqlite

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related