/// <summary> /// Create an parameter to be passed by parameter index. /// </summary> public StoredProcedureParameter(object value, ParameterDirectionWrap parameterDirection) { this.key = null; this.value = value; this.parameterDirection = parameterDirection; this.size = null; }
/// <summary> /// Create an input parameter to be passed by parameter index. /// </summary> public StoredProcedureParameter(object value) { this.key = null; this.value = value; this.parameterDirection = ParameterDirectionWrap.Input; this.size = null; }
/// <summary> /// Create a parameter to be passed by parameter name. /// </summary> public StoredProcedureParameter(string key, object value, ParameterDirectionWrap parameterDirection, int size) { this.key = key; this.value = value; this.parameterDirection = parameterDirection; this.size = size; }
public void AddWithValue(string key, object value, ParameterDirectionWrap direction, int?size) { if (value == null) { value = DBNull.Value; } SqlParameter sp = new SqlParameter(key, value); System.Data.ParameterDirection pDir; switch (direction) { case ParameterDirectionWrap.Input: pDir = System.Data.ParameterDirection.Input; break; case ParameterDirectionWrap.InputOutput: pDir = System.Data.ParameterDirection.InputOutput; break; case ParameterDirectionWrap.Output: pDir = System.Data.ParameterDirection.Output; break; case ParameterDirectionWrap.ReturnValue: pDir = System.Data.ParameterDirection.ReturnValue; break; default: pDir = System.Data.ParameterDirection.Input; break; } sp.Direction = pDir; if (size.HasValue) { sp.Size = size.Value; } this.pm.Add(sp); }
public void AddWithValue(string key, object value, ParameterDirectionWrap direction, int? size) { if (value == null) value = DBNull.Value; SqlParameter sp = new SqlParameter(key, value); System.Data.ParameterDirection pDir; switch (direction) { case ParameterDirectionWrap.Input: pDir = System.Data.ParameterDirection.Input; break; case ParameterDirectionWrap.InputOutput: pDir = System.Data.ParameterDirection.InputOutput; break; case ParameterDirectionWrap.Output: pDir = System.Data.ParameterDirection.Output; break; case ParameterDirectionWrap.ReturnValue: pDir = System.Data.ParameterDirection.ReturnValue; break; default: pDir = System.Data.ParameterDirection.Input; break; } sp.Direction = pDir; if (size.HasValue) sp.Size = size.Value; this.pm.Add(sp); }
public void AddWithValue(string key, object value, ParameterDirectionWrap direction) { AddWithValue(key, value, direction, null); }
public void AddWithValue(string key, object value, ParameterDirectionWrap direction, int?size, DbType?dbType) { if (value == null) { value = DBNull.Value; } MySqlParameter sp = new MySqlParameter(key, value); if (dbType.HasValue) { sp.DbType = dbType.Value; } System.Data.ParameterDirection pDir; switch (direction) { case ParameterDirectionWrap.Input: pDir = System.Data.ParameterDirection.Input; break; case ParameterDirectionWrap.InputOutput: pDir = System.Data.ParameterDirection.InputOutput; break; case ParameterDirectionWrap.Output: pDir = System.Data.ParameterDirection.Output; break; case ParameterDirectionWrap.ReturnValue: pDir = System.Data.ParameterDirection.ReturnValue; break; default: pDir = System.Data.ParameterDirection.Input; break; } // Need to prevent adding a duplicate key int index = pm.IndexOf(key); if (index == -1) { sp.Direction = pDir; if (size.HasValue) { sp.Size = size.Value; } this.pm.Add(sp); } else { pm[index].Direction = pDir; if (size.HasValue) { pm[index].Size = size.Value; } pm[index].Value = value; } }
public void AddWithValue(string key, object value, ParameterDirectionWrap direction, int?size) { AddWithValue(key, value, direction, size, null); }
public void AddTypedDbNull(string key, ParameterDirectionWrap direction, DbType dbType) { AddWithValue(key, DBNull.Value, direction, null, dbType); }