ehappy
c# dapper oracle like 参数

sb.AppendFormat(" And(A.Code Like :KEYS  Or A.Name Like :KEYS )");

using (IDataReader dr = OracleHelper.ExecuteReader(sb.ToString(), new OracleParameter[] {
new OracleParameter { OracleType = OracleType.VarChar, Value = "%"+key+"%", ParameterName = ":KEYS" }
}))


粤ICP备18122249号