When I've tried in Linq2Sql to load table with 2 child tables, I've noticed, that multiple SQLs are generated. I've f
ound that it isa known issue, if you try to specify more than one to pre-load it just picks which one to pre-load and which others to leave deferred (simply ignoring those LoadWith hints) There are more explanations in
Product firstProduct = db.Product.Include("OrderDetail").Include("Supplier").First();
м