IDbConnection (ExecuteQuery<Orders> via StoredProcedures)

IDbConnectionExecuteQueryOrdersViaStoredProcedure.cs

using (var connection = new SqlConnection(connectionString))
{
     var orders = connection.ExecuteQuery<Order>("[dbo].[sp_get_customer_orders]",
          new { CustomerId = 10045 },
          commandType: CommandType.StoredProcedure);
}