Executing Stored Procedures With Dapper | Learn Dapper

var sql = "exec [Sales by Year] @Beginning_Date, @Ending_Date";
var values = new { Beginning_Date = "2017.1.1", Ending_Date = "2017.12.31" };
var results = connection.Query(sql, values).ToList();
results.ForEach(r => Console.WriteLine($"{r.OrderID} {r.Subtotal}"));