public NextAsLiteralValueTestParameters( string chars, HsqlProviderType providerType, object value, int?errorCode, string errorMessage) { this.Chars = chars; this.ProviderType = providerType; this.Value = value; this.ErrorCode = errorCode; this.ErrorMessage = errorMessage; }
public HsqlParameter(string parameterName, HsqlProviderType dbType, int size, ParameterDirection direction, bool isNullable, byte precision, byte scale, string sourceColumn, DataRowVersion sourceVersion, object value) : this() { ParameterName = parameterName; ProviderType = dbType; Size = size; Direction = direction; IsNullable = isNullable; Precision = precision; Scale = scale; SourceColumn = sourceColumn; SourceVersion = sourceVersion; Value = value; }
static HsqlResult NewResult() { int columnCount = columns.GetUpperBound(1); HsqlResult result = new HsqlResult(columnCount); object[] row = new object[columnCount]; int i = 0; const int TypeOrdinal = 0; const int ValueOrdinal = 1; result.add(row); foreach (object[] column in columns) { HsqlProviderType dataType = (HsqlProviderType)column[TypeOrdinal]; row[i] = column[ValueOrdinal]; int scale = 0; switch (dataType) { case HsqlProviderType.Decimal: case HsqlProviderType.Numeric: { scale = 4; break; } } int size = HsqlTypes.getPrecision((int)dataType); result.metaData.catalogNames[i] = "mem:test"; result.metaData.classNames[i] = HsqlTypes.getTypeName((int)dataType); result.metaData.colLabels[i] = "COLUMN_" + i; result.metaData.colNames[i] = "C" + i; result.metaData.colNullable[i] = (int)BaseColumnNullability.Nullable; result.metaData.colScales[i] = scale; result.metaData.colSizes[i] = size; result.metaData.colTypes[i] = (int)dataType; result.metaData.isIdentity[i] = false; result.metaData.isLabelQuoted[i] = false; result.metaData.isWritable[i] = false; result.metaData.paramMode[i] = (int)ParameterMode.Unknown; result.metaData.schemaNames[i] = "PUBLIC"; result.metaData.tableNames[i] = "ALL_COL_TYPES"; } return(result); }
public NextAsLiteralValueTestParameters( string chars, HsqlProviderType providerType, object value, int? errorCode, string errorMessage) { this.Chars = chars; this.ProviderType = providerType; this.Value = value; this.ErrorCode = errorCode; this.ErrorMessage = errorMessage; }
internal void DeriveParametersInternal() { if (CommandType != CommandType.StoredProcedure) { throw new InvalidOperationException(string.Format( "Operation not supported for CommandType: " + CommandType.ToString())); } Prepare(); HsqlStatement statement = m_statement; ParameterMetaData pmd = statement.ParameterDescriptor.metaData; string[] parameterNames = pmd.colNames; int count = parameterNames.Length; HsqlParameter[] parameters = new HsqlParameter[count]; for (int i = 0; i < count; i++) { string name = parameterNames[i]; ParameterMode mode = (ParameterMode)pmd.paramMode[i]; int type = pmd.colTypes[i]; int precision = pmd.colSizes[i]; int scale = pmd.colScales[i]; int nullability = pmd.colNullable[i]; HsqlProviderType providerType = (HsqlProviderType)type; DbType dbType = HsqlConvert.ToDbType(providerType); ParameterDirection?direction = HsqlConvert.ToParameterDirection(mode); bool?isNullable = IsNullable(nullability); bool isCharacter = IsCharacterType(type); bool isNumber = (!isCharacter) && IsNumberType(type); bool isTemporal = !(isCharacter || isNumber) && IsTemporalType(type); int size = ToBufferSize(type, precision); if (isCharacter) { precision = 0; scale = 0; } else if (isNumber || isTemporal) { if (precision == 0) { precision = ToDefaultPrecision(type); } } HsqlParameter parameter = new HsqlParameter(); parameter.DbType = dbType; if (direction != null) { parameter.Direction = direction.Value; } if (isNullable != null) { parameter.IsNullable = isNullable.Value; } parameter.ParameterName = name; parameter.Precision = (byte)Math.Min(byte.MaxValue, precision); parameter.ProviderType = providerType; parameter.Scale = (byte)Math.Min(byte.MaxValue, scale); parameter.Size = size; parameter.SourceVersion = DataRowVersion.Default; parameters[i] = parameter; } HsqlParameterCollection pc = Parameters; pc.Clear(); foreach (HsqlParameter parameter in parameters) { pc.Add(parameter); } }
/// <summary> /// Constructor setting the parameter data type. /// </summary> /// <param name="parameterName">Name of the parameter.</param> /// <param name="dbType">The <c>DbType</c> of the parameter.</param> public HsqlParameter(string parameterName, HsqlProviderType dbType) : this() { this.ParameterName = parameterName; this.ProviderType = dbType; }
public HsqlParameter(string parameterName, HsqlProviderType dbType, int size, ParameterDirection direction, bool isNullable, byte precision, byte scale, string sourceColumn, DataRowVersion sourceVersion, object value) : this() { ParameterName = parameterName; ProviderType = dbType; Size = size; Direction = direction; IsNullable = isNullable; Precision = precision; Scale = scale; SourceColumn = sourceColumn; SourceVersion = sourceVersion; Value = value; }
/// <summary> /// Constructor setting the data type and size. /// </summary> /// <param name="parameterName">The name of the parameter to map</param> /// <param name="dbType">The <c>HsqlProviderType</c> of the parameter.</param> /// <param name="size">The length of the parameter.</param> public HsqlParameter(string parameterName, HsqlProviderType dbType, int size) : this() { ParameterName = parameterName; ProviderType = dbType; Size = size; }
/// <summary> /// Constructor setting the data type and size. /// </summary> /// <param name="parameterName">The name of the parameter to map</param> /// <param name="dbType">The <c>HsqlProviderType</c> of the parameter.</param> /// <param name="size">The length of the parameter.</param> public HsqlParameter(string parameterName, HsqlProviderType dbType, int size) : this() { ParameterName = parameterName; ProviderType = dbType; Size = size; }
/// <summary> /// Constructor setting the parameter data type. /// </summary> /// <param name="parameterName">Name of the parameter.</param> /// <param name="dbType">The <c>DbType</c> of the parameter.</param> public HsqlParameter(string parameterName, HsqlProviderType dbType) : this() { this.ParameterName = parameterName; this.ProviderType = dbType; }