[C#] Allegato: da mail a DB

[ttttttttttttttt]

Ciao a tutti,

io sto sviluppando un'applicazione che legge le mail da Outlook e inserisce dati come

oggetto
mittente
destinatario

in un DB...... dovrei inserire anche gli allegati (immagini, documenti..ecc) nel campo di tipo LONGBLOB.... come si fa precisamente? Non so bene cosa convertire...... vi posto un pò di codice "depurato".....

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using MySql.Data.MySqlClient;
using Microsoft.Office.Interop.Outlook;
using CDO;
using System.Runtime.InteropServices;
using System.IO;


namespace MailReader
{
class Program
{
string hh;
static void Main(string[] args)
{
Application app = null;
_NameSpace ns = null;
MailItem item = null;
MAPIFolder inboxFolder = null;
MAPIFolder subFolder = null;

string SQLQuery, SQLQuery2, SQLQuery3, str, FILENAME, CONTENT_SIZE, SQLQuery_att_id;
int article_type_id;
bool ticket_duplicate;

try
{
app = new Application();

ns = app.GetNamespace("MAPI");

ns.Logon(null, null, false, false);


inboxFolder = ns.GetDefaultFolder(OlDefaultFolders.olFolderInbox );



for (int i = 1; i <= inboxFolder.Items.Count; i++)
{
try
{

if (inboxFolder.Items[i] is MailItem)
{
item = (MailItem)inboxFolder.Items[i];

//SALVO ALLEGATI
if (item.Attachments.Count > 0)
{
for (int x = 1; x <= item.Attachments.Count; x++)
{
string retrive_type = item.Attachments[i].FileName.ToString();
string type = retrive_type.Substring(retrive_type.Length - 3);

string CONTENT_TYPE = "";
switch (type)
{
case "doc":
CONTENT_TYPE = "application/msword; name=" + item.Attachments[i].FileName.ToString();
break;

case "xls":
CONTENT_TYPE = "application/vnd.ms-excel; name=" + item.Attachments[i].FileName.ToString();
break;

case "lsx":
CONTENT_TYPE = "application/vnd.ms-excel; name=" + item.Attachments[i].FileName.ToString();
break;

case "pdf":
CONTENT_TYPE = "application/octet-stream; name=" + item.Attachments[i].FileName.ToString();
break;

case "gif":
CONTENT_TYPE = "application/gif; name=" + item.Attachments[i].FileName.ToString();
break;

case "png":
CONTENT_TYPE = "application/octet-stream; name=" + item.Attachments[i].FileName.ToString();
break;

case "rar":
CONTENT_TYPE = "application/octet-stream; name=" + item.Attachments[i].FileName.ToString();
break;

case "zip":
CONTENT_TYPE = "application/octet-stream; name=" + item.Attachments[i].FileName.ToString();
break;

default:
CONTENT_TYPE = "application/octet-stream; name=" + item.Attachments[i].FileName.ToString();
break;

}

FILENAME = item.Attachments[i].FileName.ToString();
CONTENT_SIZE = item.Attachments[i].Size.ToString();

Byte[] imgByte = null;
imgByte = new Byte[item.Attachments[i]. -->.... incosa lo converto??


}
}
}
}
}

}

}