SQL Server & AttachmentCollection C#

[funmonkee]

Hello! Long shot... Has anyone stored a AttachmentCollection (from System.Net.Mail...) in an SQL Table column (image , etc).. via a stored procedure
____________________
**** Don't ride faster than your angel can fly Get this Free Space
The democratically elected Mod of the Scottish Section - The Peoples Choice[b]

[Dawdles]

Without knowing that specific class itself, i'd probably attempt serializing into a steam (memorystream or perhaps a GZipStream), then blobbing it. Would that be good enough?

[funmonkee]

Thanks for the reply

Yeah that's where I was leaning. However, since I can't control the version and internals/serialization of those MS classes, I might create my own versions... that way I can be sure in the future I can manage the conversions... and not feck the database.

I'm just lazy and wanted someone to give me an easier solution
____________________
**** Don't ride faster than your angel can fly Get this Free Space
The democratically elected Mod of the Scottish Section - The Peoples Choice[b]

[funmonkee]

Update: I did have to create a mirror of the intersting information in System.Net.Mail.MailMessage.Attachment. The Attachment object can't be serialised, but my version could (1 liner). I then just converted my object array to binary stream and stored in an image column. I convert back from the binary/image stream to my object array...sorted
____________________
**** Don't ride faster than your angel can fly Get this Free Space
The democratically elected Mod of the Scottish Section - The Peoples Choice[b]