using System;
using System.Data.SqlClient;

namespace Stored_procedure_con_parametro_di_output
{
    class Program
    {
        static void Main(string[] args)
        {
            SqlConnection cn = new SqlConnection("Data Source=.;Initial Catalog=tempdb;Integrated Security=SSPI");
            SqlCommand cmd = new SqlCommand("dbo.up_GetMailCounter", cn);

            /* Definisco il Command Type */
            cmd.CommandType = System.Data.CommandType.StoredProcedure;

            /* Definisco il parametro di output */
            SqlParameter Value = cmd.Parameters.Add("@Value", System.Data.SqlDbType.Int);
            Value.Direction = System.Data.ParameterDirection.Output;

            /* Apro la connessione ed eseguo la stored procedure */
            cmd.Connection.Open();
            cmd.ExecuteNonQuery();

            Console.WriteLine("ContatoreMail: {0}", cmd.Parameters["@Value"].Value.ToString());

            /* Pulizia */
            cn.Close();
        }
    }
}