将单个记录的最佳匹配集放入c#中的组代表中

我们正在使用代码优先实体开发业务应用程序框架，我正在寻找以下问题的解决方案如果可能的话，不在数据库中。

我们有一个持久性模型，看起来类似于以下内容：

public abstract class DataCode
{
   public long Id { get; set; }
   public string Code { get; set; }
   public string Description { get; set; }
}
public class Option : DataCode
{
   // a bunch of stuff that describes an Option
}
public class Model : DataCode
{
   // a bunch of stuff that describes a product model
}
public class Version
{
   public long Id { get; set; }
   // a bunch of stuff that describes a version of the product model
}
public class ModelOptionVersion
{
   public Model ThisModel { get; set; }
   public Option WithThisOption { get; set; }
   public Version UsingThisVersion { get; set; }
   // a bunch of stuff that is important to track 
   // at the intersection of these three properties
}

除了用户希望使用"族代码"answers"公用代码"应用特性值之外，其他操作都很好。为了支持这一点，我认为以下类将起作用：

public abstract class CodeGroup
{
   public virtual ICollection<DataCode> DataCodes { get; set; }
}
public class Family : CodeGroup, DataCode
{
   public Family(ICollection<Model> Models)
   {
      base:DataCodes = Models;
   }
}
public class CommonCode : CodeGroup, DataCode
{
   public Family(ICollection<Option> Options)
   {
      base:DataCodes = Options;
   }
}

这对于将FamilyCode和CommonCode以及一些逻辑扩展到单独的ModelOptionVersion记录(foreach Model in Family...(来说都是很好的。然而，困扰我的是如何将一组ModelOptionVersion记录最匹配回为FamilyCode或CommonCode代表。

如果这是福特(不是(，数据可能看起来是这样的：

Family    | Model
Trucks    | F-150
Trucks    | F-250
Trucks    | F-350
SuperDuty | F-250
SuperDuty | F-350
CommonCode     | Option
Gas Engines    | 4.6l V-8 Gas
Gas Engines    | 5.4l V-8 Gas
Diesel Engines | 6.4l V-8 Diesel
Diesel Engines | 7.3l V-8 Diesel
Diesel Engines | 6.0l V-8 Diesel
Model | Option          | Version
F-150 | 4.6l V-8 Gas    | 2015
F-150 | 4.6l V-8 Gas    | 2016
F-150 | 5.4l V-8 Gas    | 2015
F-150 | 5.4l V-8 Gas    | 2016
F-250 | 5.4l V-8 Gas    | 2015
F-250 | 5.4l V-8 Gas    | 2016
F-350 | 5.4l V-8 Gas    | 2015
F-350 | 5.4l V-8 Gas    | 2016
F-250 | 6.4l V-8 Diesel | 2015
F-250 | 6.4l V-8 Diesel | 2016
F-350 | 6.4l V-8 Diesel | 2015
F-350 | 6.4l V-8 Diesel | 2016

用户希望根据"柴油发动机超负荷"或"2016燃气发动机卡车"来定价。他们不仅想在创造价格记录时看到这种情况，而且想在以后回头看的时候看到这种情况。因此，我需要一种方法，不仅扩展FamilyCode和DataCode成员，而且将它们汇总起来。但从数据来看，数据的来源并不一定显而易见。此外，该系统应该足够智能，当有人说"这只适用于F-250和F-350"时，系统会说"使用SuperDuty"。

在我看来，我需要某种最佳匹配的解决方案，也许是一些轻量级的模糊逻辑。是否存在用于此的.NET库？我必须从头开始制作吗？我怎样才能做到这一点？

var desiredModels = // some collection of Models
var familyCodesByFamily = (
    from familyCode in db.FamilyCodes
    group familyCode by familyCode.Family into family
    select family);
var applicableFamilies = (
    from family in familyCodesByFamily
    where desiredModels.All(dm => family.Any(f=> f.Model == dm))
    select family.Key).ToList();

var incorrectFamilies = 
    (from familyCode in db.FamilyCodes
    where !desiredModels.Contains(familyCode.Model)
    select familyCode.Family).Distinct();
var correctFamilies =
    (from familyCode in db.FamilyCodes
    where !incorrectFamilies.Contains(familyCode.Model)
    select familyCode.Family).Distinct().ToList();

var fuzzyFamilies = (
    from family in familyCodesByFamily
    let coverage = desiredModels.Average(dm => family.Any(f => f.Model == dm) ? 1.0 : 0.0)
    let fit = family.Average(f => desiredModels.Contains(f.Model) ? 1.0 : 0.0)
    orderby coverage descending, fit descending
    select family.Key)
    .Take(resultCount)
    .ToList();