Calling a Packaged Procedure via .Net

Someone recently posted a question in the Postgres Forums about how to call a package in Advanced Server. He also had a question about how to call a packaged procedure in a specific schema.

Here is my reply to the question:

You can't actually execute packages. You execute the procedures or functions in them. Here is some code to execute a procedure in a package. I am using public as the schema name. If you want to execute a procedure in a user's schema, just replace public with the user's name.

using System;
using System.Data;
using EnterpriseDB.EDBClient;

namespace ConsoleApplication2
{
    class Program
    {
        static void Main(string[] args)
        {
            EDBConnection conn =
               new EDBConnection(
                     "Server=localhost;" +
                     "Port=5444;" +
                     "User Id=enterprisedb;" +
                     "Password=enterprisedb;" +
                     "Database=edb");

            conn.Open();
            EDBCommand cmd = new EDBCommand();
            cmd.Connection = conn;

            int vEmpId = 7876;
            String query = "public.emp_admin.fire_emp(:e_id)";
            cmd.CommandText = query;
            cmd.CommandType = CommandType.StoredProcedure;

            EDBParameter prm = new EDBParameter(
                             "e_id", 
                             EDBTypes.EDBDbType.Integer);

            cmd.Parameters.Add(prm);

            cmd.Parameters[0].Value = vEmpId;    

            cmd.Prepare();

            cmd.ExecuteNonQuery();

            conn.Close();
        }
    }
}

.Net enterprisedb