score:3
Accepted answer
If you want to go down the differed loading path, than you would do the same for your Ranks:
options.LoadWith<Pilot>(x => x.Operator);
options.LoadWith<Operators>(y=>y.Rank);
yourDataContext.LoadOptions = options;
Then you can also always do the join with linq as well as the LoadOptions is known to produce very inefficient queries.
Source: stackoverflow.com
Related Articles
- LINQ to SQL LoadWith Mutilple Joins
- LINQ Source Code Available
- creating Linq to sqlite dbml from DbLinq source code
- source code for LINQ 101 samples
- c# Linq or code to extract groups from a single list of source data
- Convert string[] to int[] in one line of code using LINQ
- How to do joins in LINQ on multiple fields in single join
- Code equivalent to the 'let' keyword in chained LINQ extension method calls
- Linq to Sql: Multiple left outer joins
- Linq code to select one item
- How are people unit testing code that uses Linq to SQL
- LINQ query to perform a projection, skipping or wrapping exceptions where source throws on IEnumerable.GetNext()
- Doing multiple joins within a LINQ statement
- Syntax to execute code block inside Linq query?
- LINQ to Nhibernate duplicates joins
- Can't get c# linq query to compile with joins
- Linq To Objects - Under The Hood Of Joins
- convert linq to lambda with multiple joins
- Enumerable.Empty<T>().AsQueryable(); This method supports the LINQ to Entities infrastructure and is not intended to be used directly from your code
- LINQ Joins - Performance
- Best open source LINQ provider
- Forcing linq to perform inner joins
- Is there a good source that gives an overview of linq optimizations?
- Does this LINQ code perform multiple lookups on the original data?
- Writing LINQ queries. Joins VS navigational properties
- When to prefer joins expressed with SelectMany() over joins expressed with the join keyword in Linq
- How to understand the following C# linq code of implementing the algorithm to return all combinations of k elements from n
- LINQ WHERE method alters source collection
- Conditional Joins With Linq
- LINQ to SQL join generates SQL which joins on IS NULL
- add string after finding another one on specific line c#
- Inside of a lamba expression trying to divide two values and compare to another value
- WPF XAML LINQ: How to load xml file only once?
- Use Linq to shortlist parent records by using Entity Framework relations
- Find distinct categories of all elements using LINQ
- NHibernate Group By Many-to-Many Association
- OrderBy with SwitchExpression in Linq to entities
- Help with LINQ Projection
- I'm getting an error when trying to join against multiple tables in a query
- LinqToSQL and auditing changed fields
- Getting all elements with a specific attribute in LINQ to XML
- LinQ: Multiple joins with multiple columns identifiers
- Combine two linq expressions to inject navigation property
- EF version updated to 3.1.22 from 2.1 breaks Linq
- Getting key-value combinations from a Dictionary using LINQ
- How can I split a MultiSelectList into n number of items and wrap each partitioned group of items with markup
- Linq Query instead of Contains Operator for Performance issue
- Optimization of correlated subqueries with Automapper
- XML to Dictionary using Linq - Not getting Child values
- Is a lambda expression from this possible?
