I have a T-SQL stored procedure:
CREATE PROCEDURE [dbo].[GetRequestTest]
@RequestId UNIQUEIDENTIFIER
AS
BEGIN
SELECT
Request.Amount,
Request.Checksum
FROM
Request
WHERE
RequestId = @RequestId
END
C# mapping class:
public class CustomTest : Itest
{
public decimal Amount {get;set;}
public string Checksum { get; set; }
}
I'm calling trying to invoke stored procedure by 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 is null
I tried to call to put SQL statement from stored procedure directly into C# code - and it works fine, but it doesn't work with stored procedure.
Any ideas - how to make it work?
3条答案
按热度按时间tvmytwxo1#
You call wrong method:
How to use dapper: https://github.com/StackExchange/dapper-dot-net
zaqlnxep2#
Column names stored procedure or query returns should be same as CustomTest`s property names (e.g. Amount, Checksum). As result you will receive IEnumerable filled with appropriate data.
m528fe3b3#
If you are like me, you came here from Google because you need to call a stored procedure and you can't change that stored procedure, you just need to map the return results to a normal looking POCO.
Query and QuerySingle/First all return dynamic. So you can just manually map like this most of the time: