使用 LINQ 从具有嵌套数组的类中获取 Child 和 Parent 属性值-解网

问：

所以另一个 linq 问题。

有没有办法通过 linq 提取子属性和父属性值，只知道最深嵌套子属性的值？

为了扩展我的问题，这就是我想做的：

我有这个，但是一个更大的版本。虽然这里可以理解基本的格式结构。我将对象反序列化为 c# 类：

{
  "id": "ProductCatalogId1",
  "name": "Product Catalog 1",
  "result": {
    "productFamily": [
      {
        "id": "FamilyId1",
        "name": "Family 1",
        "productCategory": [
          {
            "id": "CategoryId1",
            "name": "Category 1",
            "productConstruction": [
              {
                "id": "ConstructionId1",
                "name": "Construction 1",
                "productLine": [
                  {
                    "id": "LineId1",
                    "name": "Line 1",
                    "productModel": [
                      {
                        "id": "pModelId1",
                        "name": "pModel 1",
                        "customerModel": [
                          {
                            "id": "cModelId1",
                            "name": "cModel 1"
                          }
                        ]
                      },
                      {
                        "id": "pModelId2",
                        "name": "pModel 2",
                        "customerModel": [
                          {
                            "id": "cModelId2",
                            "name": "cModel 2"
                          }
                        ]
                      }]
                    }]
                }]
            }]
        }]
    }
}

与上述结构相关的类：

public class Productcatalog
{
    public string id { get; set; }
    public string name { get; set; }
    public StructureResult result { get; set; }
}

public class StructureResult
{
    public Productfamily[] productFamily { get; set; }
}

public class Productfamily
{
    public string id { get; set; }
    public string name { get; set; }
    public Productcategory[] productCategory { get; set; }
    public FulfilsKeyTechnology[] FulfilsKeyTechnology { get; set; }
}

public class Productcategory
{
    public string id { get; set; }
    public string name { get; set; }
    public Productconstruction[] productConstruction { get; set; }
}

public class Productconstruction
{
    public string id { get; set; }
    public string name { get; set; }
    public Productline[] productLine { get; set; }
}

public class Productline
{
    public string id { get; set; }
    public string name { get; set; }
    public Productmodel[] productModel { get; set; }
}

public class Productmodel
{
    public string id { get; set; }
    public string name { get; set; }
    public Customermodel[] customerModel { get; set; }
}

public class Customermodel
{
    public string id { get; set; }
    public string name { get; set; }
}

我想做的是在最后得到一个看起来像这样的列表，从具有相同属性的类序列化，即：

[   
  {
    "productConstructionId":"ConstructionId1",
    "productConstructionName":"Construction 1",
    "productLineId":"LineId1",
    "productLineName":"Line 1",
    "customerModelId":"cModelId1",
    "customerModelName":"cModel 1"
  },
  {
    "productConstructionId":"ConstructionId1",
    "productConstructionName":"Construction 1",
    "productLineId":"LineId1",
    "productLineName":"Line 1",
    "customerModelId":"cModelId2",
    "customerModelName":"cModel 2"
  }
]

与上述结构相关的类：

public class ModelList
{
    public string productConstructionId {get; set;}
    public string productConstructionName {get; set;}
    public string productLineId {get; set;}
    public string productLineName {get; set;}
    public string customerModelId {get; set;}
    public string customerModelName {get; set;}
}

在这种情况下，也许 linq 甚至不是最佳实践？

C# Linq .Net-Core 嵌套列表

var jsonDeserialized = JsonConvert.DeserializeObject<Data>(json);

var list = new List<ModelList>();
foreach (var pf in jsonDeserialized.Result.ProductFamily)
{
    foreach (var pct in pf.ProductCategory)
    {
        foreach (var pcn in pct.ProductConstruction)
        {
            foreach (var pl in pcn.ProductLine)
            {
                foreach (var pm in pl.ProductModel)
                {
                    foreach (var cm in pm.CustomerModel)
                    {
                        var item = new ModelList
                        {
                            ProductFamilyId = pf.Id,
                            ProducFamilyName = pf.Name,
                            ProductCategoryId = pct.Id,
                            ProductCategoryName = pct.Name,
                            ProductConstructionId = pcn.Id,
                            ProductConstructionName = pcn.Name,
                            ProductLineId = pl.Id,
                            ProductLineName = pl.Name,
                            CustomerModelId = cm.Id,
                            CustomerModelName = cm.Name
                        };
                            list.Add(item);
                    }
                }
            }
        }
    }
}

输出

[
  {
    "ProductFamilyId": "FamilyId1",
    "ProducFamilyName": "Family 1",
    "ProductCategoryId": "CategoryId1",
    "ProductCategoryName": "Category 1",
    "ProductConstructionId": "ConstructionId1",
    "ProductConstructionName": "Construction 1",
    "ProductLineId": "LineId1",
    "ProductLineName": "Line 1",
    "CustomerModelId": "cModelId1",
    "CustomerModelName": "cModel 1"
  },
  {
    "ProductFamilyId": "FamilyId1",
    "ProducFamilyName": "Family 1",
    "ProductCategoryId": "CategoryId1",
    "ProductCategoryName": "Category 1",
    "ProductConstructionId": "ConstructionId1",
    "ProductConstructionName": "Construction 1",
    "ProductLineId": "LineId1",
    "ProductLineName": "Line 1",
    "CustomerModelId": "cModelId2",
    "CustomerModelName": "cModel 2"
  }
]

类

public class ModelList
{
    public string ProductFamilyId { get; set; }
    public string ProducFamilyName { get; set; }
    public string ProductCategoryId { get; set; }
    public string ProductCategoryName { get; set; }
    public string ProductConstructionId { get; set; }
    public string ProductConstructionName { get; set; }
    public string ProductLineId { get; set; }
    public string ProductLineName { get; set; }
    public string CustomerModelId { get; set; }
    public string CustomerModelName { get; set; }
}

public partial class Data
{
    [JsonProperty("id")]
    public string Id { get; set; }

    [JsonProperty("name")]
    public string Name { get; set; }

    [JsonProperty("result")]
    public Result Result { get; set; }
}

public partial class Result
{
    [JsonProperty("productFamily")]
    public ProductFamily[] ProductFamily { get; set; }
}

public partial class ProductFamily
{
    [JsonProperty("id")]
    public string Id { get; set; }

    [JsonProperty("name")]
    public string Name { get; set; }

    [JsonProperty("productCategory")]
    public ProductCategory[] ProductCategory { get; set; }
}

public partial class ProductCategory
{
    [JsonProperty("id")]
    public string Id { get; set; }

    [JsonProperty("name")]
    public string Name { get; set; }

    [JsonProperty("productConstruction")]
    public ProductConstruction[] ProductConstruction { get; set; }
}

public partial class ProductConstruction
{
    [JsonProperty("id")]
    public string Id { get; set; }

    [JsonProperty("name")]
    public string Name { get; set; }

    [JsonProperty("productLine")]
    public ProductLine[] ProductLine { get; set; }
}

public partial class ProductLine
{
    [JsonProperty("id")]
    public string Id { get; set; }

    [JsonProperty("name")]
    public string Name { get; set; }

    [JsonProperty("productModel")]
    public ProductModel[] ProductModel { get; set; }
}

public partial class ProductModel
{
    [JsonProperty("id")]
    public string Id { get; set; }

    [JsonProperty("name")]
    public string Name { get; set; }

    [JsonProperty("customerModel")]
    public CustomerModel[] CustomerModel { get; set; }
}

public partial class CustomerModel
{
    [JsonProperty("id")]
    public string Id { get; set; }

    [JsonProperty("name")]
    public string Name { get; set; }
}

感谢您抽出宝贵时间并愿意帮助@Serge。看看你的例子，我注意到你错过了一个细节。对不起，不够清楚。:)您错过的细节是，我已经知道最深层次的“customerModelId”。我只想要与该孩子身份证相关的信息和家长信息。我做了类似的事情，所以我知道可以用这种方式完成。:)我希望有一种更好的方法来使用 Linq 而不是一堆嵌套的 foreache。

0赞 Serge 11/6/2021

@John感谢您的反馈。然后你应该知道 linq 将查询转换为 foreach 循环，并且直接执行此操作的性能更高。

上一个：C# 如何调用内部列表构造函数以定义容量

下一个：CSharp 使用另一个列表及其嵌套列表筛选具有 LINQ 查询的列表

使用 LINQ 从具有嵌套数组的类中获取 Child 和 Parent 属性值

Get Child and Parent property values from class with nested arrays using LINQ

评论

评论