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}"));
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter