Loading

Saving System.Net.Attachment into Database

Glenn Sanchez

Hi All,

Is there a way of saving a System.Net.Attachment directly into a database field without writing to disk?

I am using LINQ and this is what I have for now:

AttachmentDetail attd = new AttachmentDetail();
attd.HeaderID=atth.ID;
attd.FileName = att.ContentDisposition.FileName;

attd.Object = ? //Something to put here...

Thanks and Regards

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Glenn Sanchez14y ago
This code worked for me.
Glenn Sanchez14y ago
Haven't confirmed if this will work:

AttachmentDetail attd = new AttachmentDetail();
attd.HeaderID=atth.ID;
attd.FileName = att.ContentDisposition.FileName;

byte[] data = new byte[att.ContentStream.Length];
att.ContentStream.Read(data,0,Convert.ToInt32(att.ContentStream.Length));

attd.Object = data.ToArray();

I can only confirm after I finish the thread that translates these attachments to a file.

regards