Really complex LINQ (to SQL) query example <p>We're thinking about adding more LINQ tests for ORMBattle.NET, but have no more ideas. All LINQ tests there are checking common LINQ functionality:</p> <ul> <li>Any test must pass on LINQ to IEnumerable</li> <li>For any test, there must be at least one ORM, on it passes (actually it doesn't matter if it is listed @ ORMBattle or not).</li> </ul> <p>Currently the goal of LINQ test sequence is to <em>automatically</em> compute LINQ implementation coverage score.</p> <p><strong>Prerequisites:</strong></p> <ul> <li><a href="http://code.google.com/p/ormbattle/source/browse/trunk/Tests/Linq/Linq2Sql.generated.cs" rel="nofollow noreferrer">Code of tests for LINQ to SQL is here</a>. This must give some imagination of what's already covered.</li> <li>Tests for other tools (actually they're generated by <a href="http://code.google.com/p/ormbattle/source/browse/trunk/Tests/Linq/LinqTests.tt" rel="nofollow noreferrer">this T4 template</a>) are <a href="http://code.google.com/p/ormbattle/source/browse/#svn/trunk/Tests/Linq" rel="nofollow noreferrer">here</a>.</li> </ul> <p>If you have any ideas on what can be added there, please share them. I'll definitely accept <em>any</em> example of LINQ query that satisfies above requirements, and possibly - some good idea related to improvement of test suite, that <em>can be implemented</em> (so e.g. if you'd suggest us to manually study the quality of translation, this won't work, because we can't automate this).</p>