LINQ : Dynamic select

by

You can do this by dynamically creating the lambda you pass to Select:

Func<Data,Data> CreateNewStatement( string fields )
{
    // input parameter "o"
    var xParameter = Expression.Parameter( typeof( Data ), "o" );

    // new statement "new Data()"
    var xNew = Expression.New( typeof( Data ) );

    // create initializers
    var bindings = fields.Split( ',' ).Select( o => o.Trim() )
        .Select( o => {

            // property "Field1"
            var mi = typeof( Data ).GetProperty( o );

            // original value "o.Field1"
            var xOriginal = Expression.Property( xParameter, mi );

            // set value "Field1 = o.Field1"
            return Expression.Bind( mi, xOriginal );
        }
    );

    // initialization "new Data { Field1 = o.Field1, Field2 = o.Field2 }"
    var xInit = Expression.MemberInit( xNew, bindings );

    // expression "o => new Data { Field1 = o.Field1, Field2 = o.Field2 }"
    var lambda = Expression.Lambda<Func<Data,Data>>( xInit, xParameter );

    // compile to Func<Data, Data>
    return lambda.Compile();
}

Then you can use it like this:

var result = list.Select( CreateNewStatement( "Field1, Field2" ) );

More Related Contents:

  1. How do I do a left outer join with Dynamic Linq?
  2. Is Injection Possible through Dynamic LINQ?
  3. Convert DateTime to Date string “dd/mm/yyyy”
  4. Remove duplicates in the list using linq
  5. Deserializing JSON to .NET object using Newtonsoft (or LINQ to JSON maybe?)
  6. Use LINQ to get items in one List, that are not in another List
  7. Split a collection into `n` parts with LINQ? [duplicate]
  8. How to combine more than two generic lists in C# Zip?
  9. Why aren’t C# static class extension methods supported?
  10. Establish a link between two lists in linq to entities where clause
  11. Select parsed int, if string was parseable to int
  12. What is the point of Lookup?
  13. GroupBy on complex object (e.g. List)
  14. Enumerating through an object’s properties (string) in C#
  15. Is the Linq Count() faster or slower than List.Count or Array.Length?
  16. Return list using select new in LINQ
  17. Intersect LINQ query
  18. LINQ – Query syntax vs method chains & lambda [closed]
  19. How to get first record in each group using Linq
  20. String.IsNullOrWhiteSpace in LINQ Expression
  21. How to Quickly Remove Items From a List
  22. How to use LINQ Distinct() with multiple fields
  23. LINQ query to return a Dictionary
  24. LINQ: Select where object does not contain items from list
  25. How/Can I use linq to xml to query huge xml files with reasonable memory consumption?
  26. AutoMapper for Func’s between selector types
  27. Convert / Cast IEnumerable to IEnumerable
  28. Where can I find the System.Linq.Dynamic dll?
  29. C# Searching for files and folders except in certain folders
  30. What is the difference between LINQ ToDictionary and ToLookup

Leave a Comment