Geting list with asp.net, oracle stored procedure and dapper


IDbConnection db2 = new OracleConnection(connStr);
try
{

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)
{
Log.WriteInfo(ex);
throw;
}
finally
{
db2.Close();
}

Understanding NPM versioning

Basic:

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

1.2.3

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

~1.2.3:

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

post