Response.BinaryWrite error by LINQ

Question

I have used the ADO.NET which i don't want to use to save Image to Database, but when i use LINQ to save image, i'm get error.

here is my DB:

ImageHandler.ashx
public class ImageHandler : IHttpHandler {

ImageDataDataContext image = new ImageDataDataContext();

public void ProcessRequest (HttpContext context) {

string imageid = context.Request.QueryString["ImID"];
var ketqua = (from img in image.tblImgs
where img.imgID == int.Parse(imageid)
select new
{
img.imgData
}).First();
context.Response.BinaryWrite((byte[])ketqua); //Cannot convert type 'AnonymousType#1' to 'byte[]' context.Response.End();
}

public bool IsReusable {
get {
return false;
}
}

}

Can you pls help me how to correct the error. thanks :)

nothing else · Answer

thank you so much...It's work now :)

Vulpes · Answer

I wasn't sure before but the error message has given me a clue about how LINQ to SQL is treating the 'image' column. Try this instead: string imageid = context.Request.QueryString[ImID]; byte[] ketqua = (from img in image.tblImgs where img.imgID == int.Parse(imageid) select img.imgData).First().ToArray(); context.Response.BinaryWrite(ketqua);

nothing else · Answer

@brunka Thanks you i'll try this @vulpes.. thank for replying but it's says: 'System.Data.Linq.Binary' does not contain a definition for 'Save' and no extension method 'Save' accepting a first argument of type 'System.Data.Linq.Binary' could be found (are you missing a using directive or an assembly reference?)

Vulpes · Answer

Try this: string imageid = context.Request.QueryString[ImID]; Image ketqua = (from img in image.tblImgs where img.imgID == int.Parse(imageid) select img.imgData).First(); MemoryStream ms = new MemoryStream(); ketqua.Save(ms System.Drawing.Imaging.ImageFormat.Gif); // or whatever the format is context.Response.BinaryWrite(ms.ToArray());

brunda k · Answer

http://debugmode.net/2010/05/10/inserting-and-retrieving-image-using-linq-to-sql-from-asp-net-application/