public void TestSelectBinaryDataFromCellAndSaveToFile()
{
const string sqlCreateTable = "create table test (bin blob);";
const string sqlInsertImage = "insert into test (bin) values (@bin);";
const string sqlSelectImage = "select bin from test limit 1;";
const string fileName = "image.png";
const int imageDimension = 100;
var image = new Bitmap(imageDimension, imageDimension);
byte[] binary;
using (var g = Graphics.FromImage(image))
{
g.Clear(Color.Gold);
}
using (var memory = new MemoryStream())
{
image.Save(memory, ImageFormat.Png);
binary = memory.ToArray();
}
var xQuery = new XQuerySqlite(SetUp.SqliteConnectionString);
xQuery.BeginTransaction();
xQuery.Create(sqlCreateTable);
xQuery.InsertBinaryIntoCell(binary, sqlInsertImage, "@bin");
File.Delete(fileName);
var result = xQuery.SelectBinaryAndSave(fileName, sqlSelectImage);
Assert.IsTrue(result);
}
