/// <summary> /// Make stored procedure param. /// </summary> /// <param name="ParamName">Name of param.</param> /// <param name="DbType">Param type.</param> /// <param name="Size">Param size.</param> /// <param name="Direction">Parm direction.</param> /// <param name="Value">Param value.</param> /// <returns>New parameter.</returns> public static NpgsqlParameter MakeParam(string ParamName, NpgsqlTypes.NpgsqlDbType DbType, Int32 Size, object Value) { NpgsqlParameter param; if (Size > 0) param = new NpgsqlParameter(ParamName, DbType, Size); else param = new NpgsqlParameter(ParamName, DbType); param.Direction = ParameterDirection.Input; param.Value = Value; return param; }
/// <summary> /// Make stored procedure param. /// </summary> /// <param name="ParamName">Name of param.</param> /// <param name="DbType">Param type.</param> /// <param name="Size">Param size.</param> /// <param name="Direction">Parm direction.</param> /// <param name="Value">Param value.</param> /// <returns>New parameter.</returns> public static NpgsqlParameter MakeParam(string ParamName, NpgsqlTypes.NpgsqlDbType DbType, Int32 Size, ParameterDirection Direction, object Value) { NpgsqlParameter param; if (Size > 0) param = new NpgsqlParameter(ParamName, DbType, Size); else param = new NpgsqlParameter(ParamName, DbType); param.Direction = Direction; if (!(Direction == ParameterDirection.Output && Value == null)) param.Value = Value; return param; }
public void AddParameter(string name, object value, NpgsqlTypes.NpgsqlDbType npgsqlDbType, ParameterDirection direccion) { if (_npgsqlCommand == null) { throw new Exception("Command not initialized."); } NpgsqlParameter parametro = new NpgsqlParameter(); parametro.ParameterName = name; parametro.NpgsqlDbType = npgsqlDbType; parametro.Value = value; parametro.Direction = direccion; _npgsqlCommand.Parameters.Add(parametro); }
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; }
public void __AddProfileColumn( string Name, NpgsqlTypes.NpgsqlDbType columnType, int size) { // get column type... string type = columnType.ToString(); if ( size > 0 ) { type += "(" + size.ToString() + ")"; } string sql = String.Format( @"ALTER TABLE {0} ADD {1} {2} ", MsSqlDbAccess.GetObjectName( "prov_profile" ), Name, type ); using ( NpgsqlCommand cmd = new NpgsqlCommand( sql ) ) { cmd.CommandType = CommandType.Text; _dbAccess.ExecuteNonQuery(cmd); } }
public static bool GetDbTypeAndSizeFromString(string providerData, out NpgsqlTypes.NpgsqlDbType dbType, out int size) { return LegacyDb.GetDbTypeAndSizeFromString(providerData, out dbType, out size); }