修改CodeSmith中的SchemaExplorer.MySQLSchemaProvider

        /// <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( 0 );                        string nativeType = reader.GetString( 1 );                        long longSize = ( reader.IsDBNull( 2 ) == false ) ? reader.GetInt64( 2 ) : 0;                        byte precision = ( byte ) ( ( reader.IsDBNull( 3 ) == false ) ? reader.GetInt32( 3 ) : 0 );                        int scale = ( reader.IsDBNull( 4 ) == false ) ? reader.GetInt32( 4 ) : 0;                        bool isNullable = ( reader.IsDBNull( 5 ) == false ) && reader.GetBoolean( 5 );                        string direction = reader.GetString( 6 );                        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" ) > -1 );                        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();        }