C# Pass Lambda Expression as Method Parameter

by

Use a Func<T1, T2, TResult> delegate as the parameter type and pass it in to your Query:

public List<IJob> getJobs(Func<FullTimeJob, Student, FullTimeJob> lambda)
{
  using (SqlConnection connection = new SqlConnection(getConnectionString())) {
    connection.Open();
    return connection.Query<FullTimeJob, Student, FullTimeJob>(sql, 
        lambda,
        splitOn: "user_id",
        param: parameters).ToList<IJob>();   
  }  
}

You would call it:

getJobs((job, student) => {         
        job.Student = student;
        job.StudentId = student.Id;
        return job;
        });

Or assign the lambda to a variable and pass it in.

More Related Contents:

  1. Linq – Where().Where() is AND or OR?
  2. System.Linq.Expression.Compile error
  3. How to LINQ List and flatten it using SelectMany?
  4. Get All instead of FirstOrDefault
  5. Retrieving Property name from lambda expression
  6. Combining two expressions (Expression)
  7. Join/Where with LINQ and Lambda
  8. How to perform Join between multiple tables in LINQ lambda
  9. How can I get every nth item from a List?
  10. How do I invoke an extension method using reflection?
  11. Mutating the expression tree of a predicate to target another type
  12. What is the Efficiency and Performance of LINQ and Lambda Expression in .Net?
  13. Multiple Order By with LINQ [duplicate]
  14. How to convert an expression tree to a partial SQL query?
  15. lambda expressions in immediate window for VS2015
  16. Cannot use a lambda expression as an argument to a dynamically dispatched operation without first casting it to a delegate or expression tree type
  17. Cannot convert lambda expression to type ‘string’ because it is not a delegate type [duplicate]
  18. LINQ – Query syntax vs method chains & lambda [closed]
  19. Local variable and expression trees
  20. LINQ identity function
  21. How to merge a list of lists with same type of items to a single list of items?
  22. LINQ Expression to return Property value?
  23. How to check for nulls in a deep lambda expression? [duplicate]
  24. String.IsNullOrWhiteSpace in LINQ Expression
  25. List complex sorting
  26. Max return value if empty query
  27. How do I dynamically create an Expression predicate?
  28. Linq – Top value from each group
  29. Linq query or Lambda expression?
  30. Convert DataTable to Generic List in C#

Leave a Comment