public void TestSelectBinaryDataFromCellAsImage() { const string sqlCreateTable = "create table test (bin blob);"; const string sqlInsertImage = "insert into test (bin) values (@bin);"; const string sqlSelectImage = "select * from test;"; 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"); var retrivedImage = xQuery.SelectBinaryAsImage(sqlSelectImage); Assert.AreEqual(100, retrivedImage.Size.Width); }