public virtual DbParameter AddParameter(DbCommand cmd, String name, String value, SqlParamterTypes type, int size, System.Data.ParameterDirection direction) { Logger?.Invoke("AddParameter", @"Unknown database type. Can not create parameter."); return(null); }
public override DbParameter AddParameter(DbCommand cmd, String name, String value, SqlParamterTypes type, int size, System.Data.ParameterDirection direction) { SqlParameter param = new SqlParameter(); SqlCommand command = (SqlCommand)cmd; param.ParameterName = name; param.Value = value; param.Direction = direction; param.Size = size; param.DbType = (System.Data.DbType)Enum.Parse(typeof(System.Data.DbType), type.ToString()); command.Parameters.Add(param); return(param); }
public override DbParameter AddParameter(DbCommand cmd, String name, String value, SqlParamterTypes type, int size, System.Data.ParameterDirection direction) { OracleParameter param = new OracleParameter(); OracleCommand command = (OracleCommand)cmd; param.ParameterName = name; param.Direction = direction; param.Value = value; param.Size = size; int enumValue = (int)type; if (enumValue >= 100) { param.OracleDbType = (OracleDbType)Enum.Parse(typeof(OracleDbType), type.ToString()); } else { param.DbType = (System.Data.DbType)Enum.Parse(typeof(System.Data.DbType), type.ToString()); } // For Oracle Functions, ReturnValue Must Be First Parameter if (param.Direction == System.Data.ParameterDirection.ReturnValue) { command.Parameters.Insert(0, param); } else { command.Parameters.Add(param); } return(param); }