Queries with Contains() are not working on generic lists in LightSpeed 3.0

Hi,
using a simple table that contains in a "Value" column the first 20 prime numbers, the following code throws an exception, if the Contains() method of a List<int> is being used.

I wonder if this behavior really works as designed.

Regards,
Remo

int[] a=new int[] { 4, 6, 8, 10, 12 };
List<int> li=new List<int> { 1, 3, 5, 7, 9, 11, 13, 15 };

LightSpeedContext<LightSpeedModel1UnitOfWork> context=new LightSpeedContext<LightSpeedModel1UnitOfWork>("default");

using(var uow=context.CreateUnitOfWork())
{
    try
    {

        // this works fine
        if(uow.Primes.Any(_prime => a.Contains(_prime.Value)))
            MessageBox.Show("Yep!");
        else
            MessageBox.Show("Nope!");

        // this throws an exception (see below)
        if(uow.Primes.Any(_prime => li.Contains(_prime.Value)))
            MessageBox.Show("Yep!");
        else
            MessageBox.Show("Nope!");
    }
    catch(Exception ex)
    {
        MessageBox.Show(ex.Message+Environment.NewLine+ex.StackTrace);
    }
}

"This overload of method 'Contains' has no supported translation in LightSpeed."

   bei Mindscape.LightSpeed.Linq.Translations.SequenceContains.Apply(QueryExpression applyTo, DataProvider provider, QueryExpression[] arguments)
   bei Mindscape.LightSpeed.Linq.Sqo.CriteriaSqo.ExtractMethodCriteria(ExpressionVisitor visitor, IList`1 rangeVariables, MethodCallExpression expression)
   bei Mindscape.LightSpeed.Linq.Sqo.CriteriaSqo.ExtractCriteriaCore(ExpressionVisitor visitor, IList`1 rangeVariables, Expression expression)
   bei Mindscape.LightSpeed.Linq.Sqo.CriteriaSqo.ExtractCriteria(ExpressionVisitor visitor, IList`1 rangeVariables, Expression expression)
   bei Mindscape.LightSpeed.Linq.Sqo.CriteriaSqo.ExtractCriteriaCore(ExpressionVisitor visitor, IList`1 rangeVariables, Expression expression)
   bei Mindscape.LightSpeed.Linq.Sqo.CriteriaSqo.ExtractCriteria(ExpressionVisitor visitor, IList`1 rangeVariables, Expression expression)
   bei Mindscape.LightSpeed.Linq.Sqo.CriteriaSqo.ExtractCriteriaCore(ExpressionVisitor visitor, IList`1 rangeVariables, Expression expression)
   bei Mindscape.LightSpeed.Linq.Sqo.CriteriaSqo.ExtractCriteria(ExpressionVisitor visitor, IList`1 rangeVariables, Expression expression)
   bei Mindscape.LightSpeed.Linq.Sqo.CriteriaSqo.ExtractArgumentBasedCriteria(ExpressionVisitor visitor, IList`1 rangeVariables, IList`1 projectors, Expression expression)
   bei Mindscape.LightSpeed.Linq.Sqo.Any.Evaluate(ExpressionVisitor visitor, MethodCallExpression expression)
   bei Mindscape.LightSpeed.Linq.Plan.LinqQueryBuilder.VisitMethodCall(MethodCallExpression exp)
   bei Mindscape.LightSpeed.Linq.Plan.LinqQueryBuilder.Visit(Expression exp)
   bei Mindscape.LightSpeed.Linq.Plan.LinqQueryBuilder.Build(Expression translation, LinqQueryProvider provider)
   bei Mindscape.LightSpeed.Linq.LinqQueryProvider.GetExecutionPlan(Expression expression)
   bei Mindscape.LightSpeed.Linq.LinqQueryProvider.Execute(Expression expression)
   bei Mindscape.LightSpeed.Linq.LinqQueryProvider.System.Linq.IQueryProvider.Execute[S](Expression expression)
   bei System.Linq.Queryable.Any[TSource](IQueryable`1 source, Expression`1 predicate)
   bei WindowsFormsApplication18.Form1.Form1_Load(Object sender, EventArgs e) in F:\Source\WindowsFormsApplication18\WindowsFormsApplication18\Form1.cs:Zeile 37.

Thanks for drawing our attention to this.  We were handling the IEnumerable<T>.Contains() extension method, but not the List<T>.Contains instance method.  I've committed a fix for this and it will be included in nightly builds dated 6 Feb 2010 and above, available from about 1500 GMT.

If you need a workaround in the meantime, you can insert a call to AsEnumerable on your List<int>:

if (uow.Primes.Any(_prime => li.AsEnumerable().Contains(_prime.Value)))

This makes LINQ use the Contains extension method, which we handle correctly, instead of the instance method.

Hi Ivan,

works great.

Thx

Remo