LINQ Join方法类型参数无法推断的问题排查与解决

问题描述 #

我的查询代码如下：

List<Models.adModel> ads = context.ads
    .Join(context.Locations, 
          x => new { x.lid, x.cid },
          y => new {y.lid,y.cid }, 
          w => new Models.adModel { adid=w.adid,... })
     .ToList();

运行时遇到错误：

The type argument for method IQueryable<TOuter,TInner,TKey,TResult> cannot be inferred from the usage. Try specifying type argument explicitly

我排查过连接键的字段名，两边的lid和cid字段名完全一致，甚至尝试修改参数名，错误依然存在。

实体类定义 #

ad 实体 #

public partial class ad
{
    [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2214:DoNotCallOverridableMethodsInConstructors")]
    public ad()
    {
        this.images = new HashSet<image>();
    }
    
    public int adid { get; set; }
    public string title { get; set; }
    public string description { get; set; }
    public string phone { get; set; }
    public string email { get; set; }
    public Nullable<decimal> price { get; set; }
    public int lid { get; set; }
    public int cid { get; set; }
    public int catid { get; set; }
    
    public virtual Category Category { get; set; }

    [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
    public virtual ICollection<image> images { get; set; }

    public virtual Location Location { get; set; }
}

Location 实体 #

public partial class Location
{
    [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2214:DoNotCallOverridableMethodsInConstructors")]
    public Location()
    {
        this.ads = new HashSet<ad>();
    }
    
    public int lid { get; set; }
    public string city { get; set; }
    public int cid { get; set; }
    
    [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
    public virtual ICollection<ad> ads { get; set; }

    public virtual Country Country { get; set; }
}

Country 实体 #

public partial class Country
{
    [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2214:DoNotCallOverridableMethodsInConstructors")]
    public Country()
    {
        this.Locations = new HashSet<Location>();
    }
    
    public int cid { get; set; }
    public string country_name { get; set; }
    
    [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
    public virtual ICollection<Location> Locations { get; set; }
}

错误原因与解决方法 #

核心原因 #

Join方法的结果选择器参数错误：当前写法里w => new Models.adModel { ... }中的w仅代表外部集合（ads）的元素，但Join的结果选择器需要同时接收外部元素和内部元素两个参数，正确的参数签名应该是(outerAd, innerLocation) => new Models.adModel { ... }。

从实体类定义看，两边的lid和cid都是int类型，数据类型匹配，因此主要问题集中在结果选择器的参数数量错误上。

解决方法 #

修正Join的结果选择器，同时接收两个参数，并按需从ad和Location实体中取数据构建adModel：

List<Models.adModel> ads = context.ads
    .Join(context.Locations, 
          ad => new { ad.lid, ad.cid }, // 外部键：ad的lid和cid
          location => new { location.lid, location.cid }, // 内部键：Location的lid和cid
          (adItem, locationItem) => new Models.adModel 
          { 
              adid = adItem.adid,
              title = adItem.title,
              city = locationItem.city, // 可按需添加Location的字段
              // ... 其他需要的属性
          })
     .ToList();

额外优化建议 #

由于EF实体已定义导航属性（ad实体有Location导航属性），可以直接使用导航属性关联数据，避免手动写Join，代码更简洁且不易出错：

List<Models.adModel> ads = context.ads
    .Include(ad => ad.Location) // 预加载Location关联数据
    .Select(ad => new Models.adModel
    {
        adid = ad.adid,
        title = ad.title,
        city = ad.Location.city,
        // ... 其他需要的属性
    })
    .ToList();

内容的提问来源于stack exchange，提问作者dev