我是Small white,问题:将DB中查找的数据转换成集合形式报错。
代码:
public DataTable FindTable(string sql, params DbParameter[] parameters)
{
using (OracleConnection conn = new OracleConnection(_connection))
{
conn.Open();
using (OracleCommand cmd = new OracleCommand(sql, conn))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add(parameters);
using (OracleDataAdapter sda = new OracleDataAdapter(cmd))
{
var dt = new DataTable();
sda.Fill(dt);
return dt;
}
}
}
}
系统报错明细:System.InvalidCastException:“Unable to cast object of type 'System.Data.Common.DbParameter[]' to type 'Oracle.ManagedDataAccess.Client.OracleParameter'.”