public System.Data.Common.DbParameter GetNewParameter(string parametername, NpgsqlTypes.NpgsqlDbType type, object value) { return(new NpgsqlParameter(parametername, type) { Value = value }); }
protected override Type ConvertDbTypeToTypeInternal(int sqlType) { NpgsqlTypes.NpgsqlDbType dbType = (NpgsqlTypes.NpgsqlDbType)sqlType; switch (dbType) { case NpgsqlTypes.NpgsqlDbType.Bigint: case NpgsqlTypes.NpgsqlDbType.Smallint: case NpgsqlTypes.NpgsqlDbType.Integer: return(typeof(Int64)); case NpgsqlTypes.NpgsqlDbType.Money: case NpgsqlTypes.NpgsqlDbType.Numeric: return(typeof(decimal)); case NpgsqlTypes.NpgsqlDbType.Double: case NpgsqlTypes.NpgsqlDbType.Real: return(typeof(double)); case NpgsqlTypes.NpgsqlDbType.Boolean: return(typeof(bool)); case NpgsqlTypes.NpgsqlDbType.Date: case NpgsqlTypes.NpgsqlDbType.Timestamp: return(typeof(DateTime)); default: return(typeof(string)); } }
public static void AddToCommand(string sub, NpgsqlTypes.NpgsqlDbType type, NpgsqlCommand command, Object o) { NpgsqlParameter param = null; if (o == null) { param = new NpgsqlParameter(sub, DBNull.Value); } else if (type == NpgsqlTypes.NpgsqlDbType.Date) { DateTime date = (DateTime)o; param = new NpgsqlParameter(sub, type); param.Value = new NpgsqlTypes.NpgsqlDate((DateTime)o); } else if (type == NpgsqlTypes.NpgsqlDbType.Boolean) { param = new NpgsqlParameter(sub, type); param.Value = ((bool)o) ? true : false; } else { param = new NpgsqlParameter(sub, type); param.Value = o.ToString(); } command.Parameters.Add(param); }
public virtual StiDataParameter AddParameter(string name, string expression, NpgsqlTypes.NpgsqlDbType type, int size) { var parameter = AddParameter(); parameter.Name = name; parameter.Expression = expression; parameter.Type = (int)type; parameter.Size = size; return(parameter); }
private void AddParams(string name, NpgsqlTypes.NpgsqlDbType type, dynamic value) { var NewParameter = new NpgsqlParameter() { ParameterName = name, Value = value, NpgsqlDbType = type }; Params.Add(NewParameter); }
public static NpgsqlParameterCollection AddParamWithValue( this NpgsqlParameterCollection parameters, string parameterName, NpgsqlTypes.NpgsqlDbType dbType, int size, object value) { var parameter = new NpgsqlParameter(parameterName, dbType, size); parameter.Value = value; parameters.Add(parameter); if (value != DBNull.Value) { parameter.ResetDbType(); } return(parameters); }
public void Set(string column, NpgsqlTypes.NpgsqlDbType type, object v) { values [column] = new Value { type = type, v = v }; }
public TypeValuePair(NpgsqlTypes.NpgsqlDbType a, string value) { this.valueType = a; this.value = value; }
/// <summary> /// Initializes a new instance of the <see cref="SettingsPropertyColumn"/> class. /// </summary> /// <param name="settings"> /// The settings. /// </param> /// <param name="dataType"> /// The data type. /// </param> /// <param name="size"> /// The size. /// </param> public SettingsPropertyColumn(SettingsProperty settings, NpgsqlTypes.NpgsqlDbType dataType, int size) { this.DataType = dataType; this.Settings = settings; this.Size = size; }