CS1061: Retrieve image from DB to PictureBox control

Question

I have winforms that contains pictureBox form, I want to retrieve an img from DB to that control using LINQ.

This is the error when compiling,

CS1061: IQueryable does not contain a definition for Image and no extension method Image accepting a first argument of type IQueryable could be found (are you missing a using directive or an assembly reference?)

    private void pictureBox1_Click(object sender, EventArgs e)
    {
        // Get as single image from the database
        var q = from image in context.Products
                where image.Pro_ID == 1
                select image;
        // Convert the byte[] to an System.Drawing.Image
        img.Image = ByteArrayToImage(q.Image.ToArray());
    }

    private byte[] ImageToByteArray(System.Drawing.Image imageIn)
    {
        using (MemoryStream ms = new MemoryStream())
        {
            imageIn.Save(ms, System.Drawing.Imaging.ImageFormat.Gif);
            return ms.ToArray();
        }
    }

Answer 1

Your problem is ImageToByteArray accepts an image as varieble but you used this:

ByteArrayToImage(q.Image.ToArray());

That use this function with an array as varieble.

After getting q from sql (If q is a byte array)

var q = (from x in context.Products
               where x.Pro_ID == 1
               select x.Image).FirstOrDefault();


Image image1 = byteArrayToImage((byte[])q);

and a method

public Image byteArrayToImage(byte[] byteArrayIn)
{
     using (var ms = new MemoryStream(byteArrayIn))
     {
        return Image.FromStream(ms);
     }
}

Do not forget using the name space System.Drawing.Image