How do you SelectMany in LightSpeed?

Say I have the following tables as well as the matching LightSpeed entities:
Customer
Order
Product

I have a query like:
var customersWhoOrderedProduct = work.Products.Where(prod => prod.Name == filter).SelectMany(prod => prod.Orders.Select(ord => ord.Customer)).Distinct();

When I run this query I get an exception that SelectMany is not supported.

Hi Todd,

We're still rounding out our LINQ support and SelectMany is high on our list. However, your query is able to be expressed using a normal LightSpeed query:

var query = new Query(Entity.Attribute("Orders.Product.Name") == "Rum") {Distinct = true};
var customers = _unitOfWork.Find<Customer>(query);

Cheers,

Andrew.

Hi Todd,

We have now added experimental support for SelectMany.  This does not cover all possible SelectMany scenarios, but it should deal with queries of the type you describe (flattening queries without multi-table projections or sub-expressions (let clauses)).  We would welcome feedback on whether it is sufficient for your needs.

This feature will be included in nightly builds numbered 20080626 and above, available from http://www.mindscape.co.nz/Products/LightSpeed/nightlybuilds.aspx (Express edition) or the store (Standard and higher editions) from about 1800 GMT.

 Ivan,

 I've downloaded both the 20080626 and 20080627 build to test out SelectMany and get the same exception with both.

Here is a callstack from a simple Program that uses SelectMany.

 Unhandled Exception: System.TypeLoadException: Could not load type 'Mindscape.LightSpeed.Model.TypeModel' from assembly 'Mindscape.LightSpeed, Version
=2.0.542.8375, Culture=neutral, PublicKeyToken=360c8f37b466ebb2'.
   at Mindscape.LightSpeed.Linq.Sqo.SelectMany.GetReverseAssociation(MemberInfo association)
   at Mindscape.LightSpeed.Linq.Sqo.SelectMany.<GetReverseAssociations>b__0(MemberInfo mi)
   at System.Linq.Enumerable.<SelectIterator>d__d`2.MoveNext()
   at System.Collections.Generic.List`1.InsertRange(Int32 index, IEnumerable`1 collection)
   at Mindscape.LightSpeed.Linq.Sqo.SelectMany.AddTraversalChainToQuery(List`1 traversalChain, LinqQueryExecutionPlan plan)
   at Mindscape.LightSpeed.Linq.Sqo.SelectMany.OnVisit(LinqQueryTranslator visitor, MethodCallExpression expression)
   at Mindscape.LightSpeed.Linq.Sqo.SqoBase.PerformVisit(LinqQueryTranslator visitor, MethodCallExpression expression)
   at Mindscape.LightSpeed.Linq.LinqQueryTranslator.VisitMethodCall(MethodCallExpression m)
   at Mindscape.LightSpeed.Linq.ExpressionVisitor.Visit(Expression exp)
   at Mindscape.LightSpeed.Linq.Sqo.Distinct.OnVisit(LinqQueryTranslator visitor, MethodCallExpression expression)
   at Mindscape.LightSpeed.Linq.Sqo.SqoBase.PerformVisit(LinqQueryTranslator visitor, MethodCallExpression expression)
   at Mindscape.LightSpeed.Linq.LinqQueryTranslator.VisitMethodCall(MethodCallExpression m)
   at Mindscape.LightSpeed.Linq.ExpressionVisitor.Visit(Expression exp)
   at Mindscape.LightSpeed.Linq.LinqQueryTranslator.Translate(Expression expression, IUnitOfWork unitOfWork)
   at Mindscape.LightSpeed.Linq.LinqQueryProvider.System.Linq.IQueryProvider.Execute(Expression expression)
   at Mindscape.LightSpeed.Linq.LinqQuery`1.System.Collections.Generic.IEnumerable<T>.GetEnumerator()
   at System.Linq.Enumerable.<SelectIterator>d__d`2.MoveNext()
   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
   at PeopleDatabaseTester.Program.Main(String[] args) in C:\Code\dev\Tools\BiblicalPeople\src\PeopleDatabaseTester\Program.cs:line 32

Hello Todd,

We've tracked this down to an obfuscation issue.  We're sorry for the error.  The problem will be fixed in nightly builds numbered 20080701 and above, available from http://www.mindscape.co.nz/Products/LightSpeed/nightlybuilds.aspx (Express edition) or the store (Standard and higher edition) from about 1800 GMT.  Thanks for your patience and apologies again for this mistake.

Ivan,

Looks like from my initial tests SelectMany is working. I'll let you know if I run into any more issues.

-Todd