dapper stored procedure with output parameters code example

Example: c# dapper execute stored procedure with parameters

public void GetSomething(int somethingId)
{
    IRepository repository = UnitOfWork.GetRepository();

    var param = new DynamicParameters();
    param.Add("@somethingId", dbType: DbType.Int32, value:somethingId, direction: ParameterDirection.Input);

    var result = repository.Exec(SomethingEnum.spMyStoredProcedure, param);

    ...

}