private void Example()
        {
            using (var conn = new SqlConnection("connectionString"))
            {
                using (var command = conn.CreateCommand())
                {
                    command.CommandType = CommandType.StoredProcedure;
                    command.CommandText = "PROCEDURE_NAME";
                    command.Parameters.AddWithValue("Param1", "Value1");
                    command.Parameters.AddWithValue("Param1", "Value2");
                    conn.Open();
                    command.ExecuteNonQuery();
                    conn.Close();
                }
            }
        }