实体框架核心中的动态选择

Question

我正在创建一个执行动态选择字段的过程。 例如：

List<Company> items = await entity
    .Skip(model.Start)
    .Take(model.Length)
    .Select(GenerateDynamicSelect<Company>("Id,Name"))
    .ToListAsync();

公司实体是：

public class Category
{
    public int Id { get; set; }
    public string? Name { get; set; }
    ...others 100 properties...
}

public class Company 
{
    public int Id { get; set; }
    public int? CategoryId { get; set; }
    public Category? Category { get; set; }
    public string? Code { get; set; }
    public string? Name { get; set; }
    ...others 100 properties...
}

如果我使用的话，一切正常，

GenerateDynamicSelect<Company>("Id,Name")

但是如何使用嵌套字段？

GenerateDynamicSelect<Company>("Id,Name,Category.Name")

避免加载类别表的所有列很重要。

我写的代码：

private static Expression<Func<T, T>> GenerateDynamicSelect<T>(string fields)
{
    Type type = typeof(T);
    ParameterExpression parameter = Expression.Parameter(type, "x");
    NewExpression objToInitialise = Expression.New(type);
    HashSet<string> parsedColumns = new();

    BindingFlags searchFlags = BindingFlags.IgnoreCase | BindingFlags.Public | BindingFlags.Instance;
    IEnumerable<MemberAssignment> bindings = fields.Split(',')
        .Select(columnName => columnName.Trim().ToLower())
        .Where(columnName => !parsedColumns.Contains(columnName))
        .Select(columnName =>
            {
                parsedColumns.Add(columnName);
                PropertyInfo? property;
                if (columnName.Contains('.'))
                {
                    string[] parts = columnName.Split('.');
                    property = type.GetProperty(parts[0], searchFlags);

                    how i can do?
                }
                else
                {
                    property = type.GetProperty(columnName, searchFlags);
                }
                MemberExpression originalValue = Expression.Property(parameter, property);
                return Expression.Bind(property, originalValue);
            }
        );
    MemberInitExpression initializedMember = Expression.MemberInit(objToInitialise, bindings);
    return Expression.Lambda<Func<T, T>>(initializedMember, parameter);
}

谢谢。我使用.NET 6