How to create a dynamic LINQ join extension method

by

I’ve fixed it myself now. It was a schoolboy error passing too many parameters to the CreateQuery(… ) call. Paste the following code into the Dynamic.cs file within the DynamicQueryable class for a dynamic Join extension method. You can find the source for the DynamicQuery sample project at http://code.msdn.microsoft.com/csharpsamples.

Enjoy.

    public static IQueryable Join(this IQueryable outer, IEnumerable inner, string outerSelector, string innerSelector, string resultsSelector, params object[] values)
    {
        if (inner == null) throw new ArgumentNullException("inner");
        if (outerSelector == null) throw new ArgumentNullException("outerSelector");
        if (innerSelector == null) throw new ArgumentNullException("innerSelector");
        if (resultsSelector == null) throw new ArgumentNullException("resultsSelctor");

        LambdaExpression outerSelectorLambda = DynamicExpression.ParseLambda(outer.ElementType, null, outerSelector, values);
        LambdaExpression innerSelectorLambda = DynamicExpression.ParseLambda(inner.AsQueryable().ElementType, null, innerSelector, values);

        ParameterExpression[] parameters = new ParameterExpression[] {
            Expression.Parameter(outer.ElementType, "outer"), Expression.Parameter(inner.AsQueryable().ElementType, "inner") };
        LambdaExpression resultsSelectorLambda = DynamicExpression.ParseLambda(parameters, null, resultsSelector, values);

        return outer.Provider.CreateQuery(
            Expression.Call(
                typeof(Queryable), "Join",
                new Type[] {outer.ElementType, inner.AsQueryable().ElementType, outerSelectorLambda.Body.Type, resultsSelectorLambda.Body.Type  },
                outer.Expression, inner.AsQueryable().Expression, Expression.Quote(outerSelectorLambda), Expression.Quote(innerSelectorLambda), Expression.Quote(resultsSelectorLambda)));
    }


    //The generic overload.
    public static IQueryable<T> Join<T>(this IQueryable<T> outer, IEnumerable<T> inner, string outerSelector, string innerSelector, string resultsSelector, params object[] values)
    {
        return (IQueryable<T>)Join((IQueryable)outer, (IEnumerable)inner, outerSelector, innerSelector, resultsSelector, values);
    }

More Related Contents:

  1. Learning about LINQ [closed]
  2. LINQ-to-SQL vs stored procedures? [closed]
  3. Linq: adding conditions to the where clause conditionally
  4. LINQ to Entities does not recognize the method ‘System.String Format(System.String, System.Object, System.Object)’
  5. LINQ Between Operator
  6. How to store a list in a column of a database table
  7. LINQ across multiple databases
  8. Convert String to Int in EF 4.0
  9. LINQ to SQL and a running total on ordered results
  10. How can I reject all changes in a Linq to SQL’s DataContext?
  11. LINQ with SQLite (linqtosql)
  12. Instantiating a context in LINQ to Entities
  13. LINQ not updating on .SubmitChanges()
  14. Why use LINQ Join on a simple one-many relationship?
  15. Linq To Entities – how to filter on child entities
  16. How to dynamically add OR operator to WHERE clause in LINQ
  17. LINQ To SQL exception: Local sequence cannot be used in LINQ to SQL implementation of query operators except the Contains operator
  18. Linq To Sql – Dynamic OrderBy – Case When
  19. The specified type member ‘Date’ is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties
  20. Is there a pattern using Linq to dynamically create a filter?
  21. Linq to SQL how to do “where [column] in (list of values)”
  22. Multiple WHERE clause in Linq
  23. linq to entities vs linq to objects – are they the same?
  24. How do I write this cross apply query in LINQ-to-SQL?
  25. If condition in LINQ Where clause
  26. Point connectionstring in dbml to app.config
  27. Building Dynamic LINQ Queries based on Combobox Value
  28. NHibernate vs LINQ to SQL
  29. Is Injection Possible through Dynamic LINQ?
  30. C# Linq to SQL: How to express “CONVERT([…] AS INT)”?

Leave a Comment