LINQ無法在asp.net中翻譯

我收到這個錯誤。

var query = DbContext.Registries.AsNoTracking().ProjectTo<Registry>(Mapper.ConfigurationProvider);
        if (onlyMine) {
            query = from registry in DbContext.Registries.AsNoTracking()
                    join member in DbContext.RegistryMembers.AsNoTracking() on registry.Id equals member.RegistryId into members
                    from membership in members.DefaultIfEmpty()
                    where onlyMine && membership.MemberId == userId
                    select new Registry {
                        Id = registry.Id,
                        Customer = new Customer {
                            Id = registry.Customer.Id,
                            Name = registry.Customer.Name,
                        },
                        Title = registry.Title,
                        Membership = membership.Role
                    };
        }
        if (!string.IsNullOrWhiteSpace(options.Search)) {
            var term = options.Search.Trim().ToLowerInvariant();
            query = query.Where(x => x.Title.ToLower().Contains(term) ||  x.Customer.Name.ToLower().Contains(term));
        }
        return await query.ToResultSetAsync(options);

我收到以下錯誤

System.InvalidOperationException：LINQ 運算式'DbSet .LeftJoin（外部：DbSet，內部：d => EF.Property（d，“CustomerId”），outerKeySelector：d0 => EF.Property（d0，“Id”），innerKeySelector： (o, i) => new TransparentIdentifier<DbRegistry, DbCustomer>( Outer = o, Inner = i )) .OrderBy(d => EF.Property(d.Inner, "Id") == null ? null : new Customer { Id = d.Inner.Id, Name = d.Inner.Name } .Name)' 無法翻譯。以可翻譯的形式重寫查詢，或通過插入對 AsEnumerable()、AsAsyncEnumerable()、ToList() 或 ToListAsync() 的呼叫顯式切換到客戶端評估。

uj5u.com熱心網友回復：

var query = DbContext.Registries.AsNoTracking().ProjectTo<Registry>(Mapper.ConfigurationProvider);
    if (onlyMine) {
        query = from registry in DbContext.Registries.AsNoTracking()
                join member in DbContext.RegistryMembers.AsNoTracking() on registry.Id equals member.RegistryId into members
                from membership in members.DefaultIfEmpty()
                where onlyMine && membership.MemberId == userId
                select new Registry {
                    Id = registry.Id,
                    Customer = new Customer {
                        Id = registry.Customer.Id,
                        Name = registry.Customer.Name,
                    },
                    Title = registry.Title,
                    Membership = membership.Role
                };
    } else if (isVendor) {
        query = from registry in DbContext.Registries.AsNoTracking()
                join member in DbContext.RegistryMembers.AsNoTracking() on registry.Id equals member.RegistryId into members
                from membership in members.DefaultIfEmpty()
                select new Registry {
                    Id = registry.Id,
                    Customer = new Customer {
                        Id = registry.Customer.Id,
                        Name = registry.Customer.Name,
                    },
                    Title = registry.Title,
                    Membership = membership.Role
                };
    }
    if (!string.IsNullOrWhiteSpace(options.Search)) {
        var term = options.Search.Trim().ToLowerInvariant();
        query = query.Where(x => x.Title.ToLower().Contains(term) ||  x.Customer.Name.ToLower().Contains(term));
    }
    return await query.ToResultSetAsync(options);

標籤：C＃网林克

上一篇：如何將由陣列組成的物件映射到串列中

下一篇：LINQ選擇Where，然后加入Where