public static MySqlParameter GetDataParameter(DBCommandParameter parameter)
{
switch (parameter.ParamType)
{
case DBCommandParamType.Int:
return(new MySqlParameter(string.Format("@{0}", parameter.ParamName), MySqlDbType.Int32, parameter.ParamLength));
case DBCommandParamType.VarChar:
return(new MySqlParameter(string.Format("@{0}", parameter.ParamName), MySqlDbType.VarChar, parameter.ParamLength));
default:
return(null);
}
}
public static OracleParameter GetDataParameter(DBCommandParameter parameter)
{
switch (parameter.ParamType)
{
case DBCommandParamType.Int:
return(new OracleParameter(string.Format("{0}", parameter.ParamName), OracleType.Int32, parameter.ParamLength));
case DBCommandParamType.Number:
return(new OracleParameter(string.Format("{0}", parameter.ParamName), OracleType.Number, parameter.ParamLength));
case DBCommandParamType.VarChar:
return(new OracleParameter(string.Format("{0}", parameter.ParamName), OracleType.VarChar, parameter.ParamLength));
case DBCommandParamType.NVarChar:
return(new OracleParameter(string.Format("{0}", parameter.ParamName), OracleType.NVarChar, parameter.ParamLength));
default:
return(null);
}
}