/// <summary>

        /// Gets the parameters for a given command.

        /// </summary>

        /// <param name="connectionString">The connection string used to connect to the target database.</param>

        /// <param name="command"></param>

        /// <returns></returns>

        public ParameterSchema[] GetCommandParameters( string connectionString, CommandSchema command )

        {

            // MySQL does not yet implement INFORMATION_SCHEMA.PARAMETERS

            // MySQL Connector/Net 1.0.7 is supposed to support DeriveParameters()

            // However, in my testing there appears to be a bug (throws a NULL reference exception)

            // This method will be unsupported until a subsequent release of DeriverParameters()

            // is working.

            // throw new NotSupportedException( "GetCommandParameters() is not supported in this release." );

            /*

            ArrayList a = new ArrayList();

            ParameterSchema ps;

            DbConnection cnx = null;

            DbCommand cmd = null;

            try

            {

                cnx = new DbConnection(connectionString);

                cmd = new DbCommand(command.Name, cnx);

                cmd.CommandType = CommandType.StoredProcedure;

                cnx.Open();

                IDbCommandBuilder.DeriveParameters(cmd);

                cnx.Close();

                foreach(MySqlParameter param in cmd.Parameters)

                {

                    ps = new ParameterSchema(command, param.ParameterName, param.Direction, param.DbType,

                        param.MySqlDbType.ToString(), param.Size, param.Precision, param.Scale, param.IsNullable);

                    a.Add(ps);

                }

            }

            catch

            {

                throw;

            }

            finally

            {

                if (cnx != null)

                    cnx.Close();

            }

            return (ParameterSchema[]) a.ToArray(typeof (ParameterSchema));

            */

            string commandText = string.Format("SELECT PARAMETER_NAME, DATA_TYPE, CHARACTER_OCTET_LENGTH, NUMERIC_PRECISION,"

                + " NUMERIC_SCALE, 0 IS_NULLABLE, PARAMETER_MODE"

                + " FROM INFORMATION_SCHEMA.PARAMETERS WHERE SPECIFIC_SCHEMA = '{0}' AND SPECIFIC_NAME = '{1}' AND ROUTINE_TYPE = 'PROCEDURE' ORDER BY ORDINAL_POSITION", command.Database.Name, command.Name);

            List<ParameterSchema> parameterSchema = new List<ParameterSchema>();

            using (DbConnection connection = CreateConnection(connectionString))

            {

                connection.Open();

                DbCommand cmd = connection.CreateCommand();

                cmd.CommandText = commandText;

                cmd.Connection = connection;

                using (IDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection))

                {

                    while (reader.Read())

                    {

                        string name = reader.GetString(  );

                        string nativeType = reader.GetString(  );

                        long longSize = ( reader.IsDBNull(  ) == false ) ? reader.GetInt64(  ) : ;

                        byte precision = ( byte ) ( ( reader.IsDBNull(  ) == false ) ? reader.GetInt32(  ) :  );

                        int scale = ( reader.IsDBNull(  ) == false ) ? reader.GetInt32(  ) : ;

                        bool isNullable = ( reader.IsDBNull(  ) == false ) && reader.GetBoolean(  );

                        string direction = reader.GetString(  );

                        ParameterDirection paramDirection = ParameterDirection.Input;

                        switch(direction)

                        {

                            case "IN":

                                paramDirection = ParameterDirection.Input;

                                break;

                            case "OUT":

                                paramDirection = ParameterDirection.Output;

                                break;

                            case "INOUT":

                                paramDirection = ParameterDirection.InputOutput;

                                break;

                            default:

                                paramDirection = ParameterDirection.Input;

                                break;

                        }

                        int size = ( longSize < int.MaxValue ) ? ( int ) longSize : int.MaxValue;

                        bool isUnsigned = ( nativeType.IndexOf( "unsigned" ) > - );

                        DbType type = GetDbType( nativeType, isUnsigned );

                        parameterSchema.Add(new ParameterSchema(command,name,paramDirection,type,nativeType,size,precision,scale,isNullable));

                    }

                    if (!reader.IsClosed)

                        reader.Close();

                }

                if (connection.State != ConnectionState.Closed)

                    connection.Close();

            }

            return parameterSchema.ToArray();

        }