Tests.DapperReadmeVsChain.Example7_Dapper C# (CSharp) Method

        public void Example7_Dapper()
        {
            var sql =
@"
select * from Sales.Customer where CustomerKey = @id
select * from Sales.[Order] where CustomerKey = @id
select * from Sales.[Return] where CustomerKey = @id";

            var selectedId = 1;

            using (var connection = new SqlConnection(s_ConnectionString))
            {
                using (var multi = connection.QueryMultiple(sql, new { id = selectedId }))
                {
                    var customer = multi.Read<Customer>().SingleOrDefault();
                    var orders = multi.Read<Order>().ToList();
                    var returns = multi.Read<Return>().ToList();

                }
            }
        }