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;
}
