Advertisement
Guest User

Untitled

a guest
Jul 26th, 2017
45
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.05 KB | None | 0 0
  1. public class Customer
  2. {
  3. public int CustomerId { get; set;}
  4. public int CustomerName { get; set; }
  5. }
  6.  
  7. public class Order
  8. {
  9. public int OrderId { get; set; }
  10. public int CustomerId { get; set; } //BuyerCustomer
  11. public int CustomerSecondId { get; set; } //ReceiverCustomer
  12. public Customer BuyerCustomer { get; set; }
  13. public Customer ReceiverCustomer { get; set; }
  14. }
  15.  
  16. SELECT a.*, b.*, c.* FROM dbo.PRODUCTS_ORDER a
  17. INNER JOIN dbo.CUSTOMER b ON a.CustomerId=b.CustomerId
  18. INNER JOIN dbo.CUSTOMER c ON a.ShippingCustomerId=b.CustomerId
  19.  
  20. List<Order> order= null;
  21. order= (List<Order>)
  22. var con=connection.Query<Order, Customer, Customer, Order>(sql,
  23. (order, customer1,customer2) =>
  24. {
  25. order.BuyerCustomer = customer1;
  26. order.ReceiverCustomer = customer2;
  27. return order;
  28. }, splitOn: "CustomerId,CustomerSecondId ");
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement