在UWP中将BitmapImage转换为byte[]并在sqlite中插入

public byte[] ConvertBitmapImageToByteArray(BitmapImage image)
{
    using (MemoryStream stream = new MemoryStream())
    {
        WriteableBitmap bitmap = new WriteableBitmap(image.PixelWidth, image.PixelHeight);
        bitmap.SetSource(image.PixelBuffer);
        bitmap.SaveJpeg(stream, image.PixelWidth, image.PixelHeight, 0, 100);
        return stream.ToArray();
    }
}

public async Task InsertImageToSQLite(byte[] imageBytes)
{
    SQLiteConnection connection = new SQLiteConnection("database.db");
    connection.CreateTable<ImageTable>(); // 创建表格，ImageTable为自定义的数据表模型

    ImageTable imageTable = new ImageTable();
    imageTable.ImageData = imageBytes;

    connection.Insert(imageTable); // 插入数据

    connection.Close();
}

BitmapImage bitmapImage = new BitmapImage(new Uri("image.jpg", UriKind.RelativeOrAbsolute));
byte[] imageBytes = ConvertBitmapImageToByteArray(bitmapImage);
await InsertImageToSQLite(imageBytes);