c# - Dapper Call stored procedure and map result to class -

i have t-sql stored procedure:

create procedure [dbo].[getrequesttest]          @requestid uniqueidentifier begin     select          request.amount,         request.checksum               request              requestid = @requestid end 

c# mapping class:

public class customtest : itest {     public decimal amount {get;set;}     public string checksum { get; set; } } 

i'm calling trying invoke stored procedure using dapper:

public void load(customtest obj, guid requestid) {     using (var con = base.getclosedconnection())     {         con.open();          var p = new dynamicparameters();         p.add("@requestid", dbtype: dbtype.guid, direction: parameterdirection.input);                         var result = con.executereader("[dbo].[getrequesttest]", param: p, commandtype: commandtype.storedprocedure);          while (result.read())              obj.amount = (decimal)result["amount"];     }             } 

but result null

i tried call put sql statement stored procedure directly c# code - , works fine, doesn't work stored procedure.

any ideas - how make work?

you call wrong method:

public void load(customtest obj, guid requestid) {     using (var con = base.getclosedconnection())     {         con.open();                          //result list of customtest         var result = db.query<customtest>("getrequesttest", new {requestid}, commandtype: commandtype.storedprocedure);      }             } 

how use dapper: https://github.com/stackexchange/dapper-dot-net