在LINQ to SQL中,如何将LINQ查询的一部分传递给函数

using System;
using System.Linq.Expressions;

public class Sample
{
    public int Id { get; set; }
    public string Name { get; set; }
}

public static class QueryHelper
{
    public static IQueryable<Sample> FilterByName(this IQueryable<Sample> query, string name)
    {
        var parameter = Expression.Parameter(typeof(Sample), "sample");
        var property = Expression.Property(parameter, nameof(Sample.Name));
        var constant = Expression.Constant(name, typeof(string));
        var equal = Expression.Equal(property, constant);
        var lambda = Expression.Lambda<Func<Sample, bool>>(equal, parameter);

        return query.Where(lambda);
    }
}

public static void Main(string[] args)
{
    var query = new Sample[] { }.AsQueryable();
    var filteredQuery = query.FilterByName("John");

    // 在此处使用LINQ to SQL将查询转换为SQL语句并执行
}