Exemple #1
0
        /// <summary>
        /// Returns the parameter of the passed name. If it does not exist, creates the parameter
        /// </summary>
        /// <param name="field">Parameter name</param>
        /// <param name="dir">Bind Direction</param>
        /// <returns>Returns existing or newly created bind parameter</returns>
        /// <remarks>
        /// If it becomes necessary to create the parameter, only the direction and name are set. All other properties must be set by the caller.
        /// For existing parameters, the passed direction is merged with the existing direction. Thus if an input parameter is found, and the passed
        /// direction is output, then this parameter now becomes input/output.
        /// </remarks>
        internal BindParameter GetBindParameter(string field, ParameterDirection dir)
        {
            BindParameter param;

            if (_bindParameters.Contains(field))
            {
                param = _bindParameters[field];
            }
            else
            {
                param = new BindParameter();
                param.ParameterName = field;
                param.Direction     = dir;
                _bindParameters.Add(param);
            }
            if (dir == ParameterDirection.ReturnValue || dir == ParameterDirection.InputOutput)
            {
                param.Direction = dir;
            }
            else if (param.Direction != dir)
            {
                switch (param.Direction)
                {
                case ParameterDirection.Input:
                    if (dir == ParameterDirection.Output)
                    {
                        param.Direction = ParameterDirection.InputOutput;
                    }
                    break;

                case ParameterDirection.InputOutput:
                    break;

                case ParameterDirection.Output:
                    if (dir == ParameterDirection.Input)
                    {
                        param.Direction = ParameterDirection.InputOutput;
                    }
                    break;

                case ParameterDirection.ReturnValue:
                    throw new NotSupportedException();

                default:
                    throw new NotImplementedException();
                }
            }
            return(param);
        }
Exemple #2
0
 internal OracleParameter GetParameter(string name)
 {
     try
     {
         var param = _bindParameters[name];
         return(param.CreateOracleParameter());
     }
     catch (KeyNotFoundException ex)
     {
         if (this.TolerateMissingParams)
         {
             // Create a dummy parameter with null value now
             var param = new BindParameter();
             param.ParameterName = name;
             param.Size          = 255;
             param.OracleDbType  = OracleDbType.Varchar2;
             param.Direction     = ParameterDirection.Input;
             _bindParameters.Add(param);
             return(param.CreateOracleParameter());
         }
         throw new KeyNotFoundException(string.Format("Parameter {0} has not been bound", name), ex);
     }
 }