Geting list with, oracle stored procedure and dapper

IDbConnection db2 = new OracleConnection(connStr);

var p = new OracleDynamicParameters();
p.Add("i_user_id", userID, OracleMappingType.Varchar2, ParameterDirection.Input);
p.Add("o_recordset", dbType: OracleMappingType.RefCursor, direction: ParameterDirection.Output);
var result = db.Query<MYDATATYPE>("my stored procedure name", p, commandType: CommandType.StoredProcedure);

var list = result.ToList();
catch (Exception ex)

Understanding NPM versioning


Let’s say there is a version number like below:


The first digit indicate major version, which might not support backward compatibility.

The second digit indicate minor version, which is something like adding new feature and it is not breaking backward compatibility.

The third digit indicate patching, which could be bug patch.

^1.2.3 :

Fix the first digit.

You can use this when you want to make sure the library will not break  backward compatibility .

The maximum version will be downloaded is 1.9.9


Fix the first and second digits.

It only allows bug patch.

The maximum version will be 1.2.9


The Journey Begins

Thanks for joining me!

Good company in a journey makes the way seem shorter. — Izaak Walton