Kentico 13 Order Item include SKU

When using OrderItemInfoProvider, what is the best way to include SKU info on fetch of order items to prevent multiple SQL Queries?

Also what in the ExpandColumns()?

Thanks

kentico 13 orderitem

So the OrderItemInfoProvider statics are obsolete, but looking at code it just uses a join

new QuerySource("COM_OrderItem").Join("COM_SKU", "COM_SKU.SKUID", "COM_OrderItem.OrderItemSKUID")

Thank you

0 votesVote for this answer Unmark Correct answer

does this help: http://devnet.kentico.com/docs/13_0/api/html/M_CMS_Ecommerce_OrderItemInfoProvider_GetOrderItems_1.htm

Returned items contain pre-loaded OrderItemSKU SKU data.

1 votesVote for this answer Mark as a Correct answer