Blob SQL

blob example.cs

using (MySqlConnection conn = new MySqlConnection(ConnectionString))
{



    MySqlCommand cmd = new MySqlCommand(String.Format("INSERT INTO foto (idcantiere,data,immagine) VALUES ('{0}',{1},@Image);", idCantiere, DateToUnix(data.Date)), conn);
    MySqlParameter paramImage = new MySqlParameter("@Image", MySqlDbType.LongBlob, foto.Immagine.Length);
    paramImage.Value = foto.Immagine;
    
    
    
    cmd.Parameters.Add(paramImage);
    try
    {
        conn.Open();
        cmd.ExecuteNonQuery();
        conn.Close();
    }
    catch (MySqlException e)
    {
        OnMySqlError(new MySqlErrorEventArgs(e));
        conn.Close();
    }
}

ExecuteQuery(string query, string ConnectionString).cs

//basic MySQL reading method

public async override void ExecuteQuery(string query)
    {
        using (MySqlConnection conn = new MySqlConnection(ConnectionString))
        {
            MySqlCommand cmd = new MySqlCommand(query, conn);
            try
            {
                conn.Open();
                cmd.ExecuteNonQuery();
                conn.Close();
            }
            catch (MySqlException e)
            {
                OnMySqlError(new MySqlErrorEventArgs(e));
                conn.Close();
            }
        }
    }

Foto.cs

  public class Foto
    {
        public int Id { get; set; }
        public int Idcantiere { get; set; }
        public DateTime Data { get; set; }
        public byte[] Immagine { get; set; }
    }