Last active
January 12, 2017 03:02
-
-
Save JonathanMagnan/3978a9ed0d8a26bb800a2946c1f7b0cf to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// SELECT * FROM Order WHERE.... | |
// SELECT * FROM OrderItem WHERE EXISTS (/* previous query */) AND ... | |
// SELECT * FROM DeliveryItems WHERE EXISTS (/* previous query */) AND ... | |
var orders = ctx.Orders | |
.Where(x => x.OrderId == myOrderID) // 1 orders, 20 columns | |
.IncludeOptimized(x => x.Items) // 20 items, 10 columns | |
.IncludeOptimized(x => x.DeliveredItems) // 10 items, 10 columns | |
.ToList(); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment