sqlite 保存 二进制数据

in C#:

class Program
{
    static void Main(string[] args){if(File.Exists("test.db3")){File.Delete("test.db3");}using(var connection = new SQLiteConnection("Data Source=test.db3;Version=3"))using(var command = new SQLiteCommand("CREATE TABLE PHOTOS(ID INTEGER PRIMARY KEY AUTOINCREMENT, PHOTO BLOB)", connection)){
            connection.Open();
            command.ExecuteNonQuery();

            byte[] photo = new byte[]{1,2,3,4,5};

            command.CommandText ="INSERT INTO PHOTOS (PHOTO) VALUES (@photo)";
            command.Parameters.Add("@photo", DbType.Binary,20).Value = photo;
            command.ExecuteNonQuery();

            command.CommandText ="SELECT PHOTO FROM PHOTOS WHERE ID = 1";using(var reader = command.ExecuteReader()){while(reader.Read()){
                    byte[] buffer = GetBytes(reader);}}}}

    static byte[] GetBytes(SQLiteDataReader reader){
        const int CHUNK_SIZE =2*1024;
        byte[] buffer = new byte[CHUNK_SIZE];
        long bytesRead;
        long fieldOffset =0;using(MemoryStream stream = new MemoryStream()){while((bytesRead = reader.GetBytes(0, fieldOffset, buffer,0, buffer.Length))>0){
                stream.Write(buffer,0,(int)bytesRead);
                fieldOffset += bytesRead;}return stream.ToArray();}}}
  • 1
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值