C＃lambda - 两个列表中内部列表的差异（除外）(C# lambda - Differences (Except) of inner lists inside two lists)

 我有两个'Table'1 ---- N'Columns列表。 第一个列表包含必须实现的默认架构。 第二个列表包含用户定义的模式。 我需要将第二个列表与第一个列表进行比较，检索架构不匹配的表，以及缺失/未知列的列表。 
 
 请考虑以下示例： 
 
public class Table
{
  public string Name {get;set;}
  public IList<Column> Columns {get;set;}
  public Table()
  {
    Columns = new List<Column>();
  }
}
public class Column
{
  public string Name {get;set;}
}
//...
var Default1 = new Table() { Name = "Table1" };
Default1.Columns.Add(new Column() { Name = "X1" });
Default1.Columns.Add(new Column() { Name = "X2" });
var Default2 = new Table() { Name = "Table2" };
Default2.Columns.Add(new Column() { Name = "Y1" });
Default2.Columns.Add(new Column() { Name = "Y2" });

var DefaultSchema = new List<Table>() { Default1, Default2 };

var T1 = new Table() { Name = "Table1" };
T1.Columns.Add(new Column() { Name = "X1" });
var T2 = new Table() { Name = "Table2" };
T2.Columns.Add(new Column() { Name = "Y2" });

var MyTables = new List<Table>() { T1, T2};

/*
var DiffTables = DefaultSchema.Join(??).Select(x => x.Columns).Except(?? MyTables.Select(y => y.Columns) ...
*/
 
 预期结果： 
 
var DiffTables =
 {
  {
    Name = "Table1",
    Columns =
    {
      Name = "X2" //Missing from DefaultSchema.Table1
    }
  },
  {
    Name = "Table2",
    Columns =
    {
      Name = "Y1" //Missing from DefaultSchema.Table2
    }
  }
 }
 
 有没有办法用lamdba表达式，或者只是由master +嵌套的foreach执行此操作？ 
 
 谢谢！ 

I have two lists of 'Table' 1 ----N 'Columns. The first list holds the default schema that must be achieved. The second list holds the schema defined by the user. I need to compare the second list against the first one, retrieving the tables where the schema mismatches, also the list of columns missing/unknown.
 
Consider the following example:
 
public class Table
{
  public string Name {get;set;}
  public IList<Column> Columns {get;set;}
  public Table()
  {
    Columns = new List<Column>();
  }
}
public class Column
{
  public string Name {get;set;}
}
//...
var Default1 = new Table() { Name = "Table1" };
Default1.Columns.Add(new Column() { Name = "X1" });
Default1.Columns.Add(new Column() { Name = "X2" });
var Default2 = new Table() { Name = "Table2" };
Default2.Columns.Add(new Column() { Name = "Y1" });
Default2.Columns.Add(new Column() { Name = "Y2" });

var DefaultSchema = new List<Table>() { Default1, Default2 };

var T1 = new Table() { Name = "Table1" };
T1.Columns.Add(new Column() { Name = "X1" });
var T2 = new Table() { Name = "Table2" };
T2.Columns.Add(new Column() { Name = "Y2" });

var MyTables = new List<Table>() { T1, T2};

/*
var DiffTables = DefaultSchema.Join(??).Select(x => x.Columns).Except(?? MyTables.Select(y => y.Columns) ...
*/
 
Expected result:
 
var DiffTables =
 {
  {
    Name = "Table1",
    Columns =
    {
      Name = "X2" //Missing from DefaultSchema.Table1
    }
  },
  {
    Name = "Table2",
    Columns =
    {
      Name = "Y1" //Missing from DefaultSchema.Table2
    }
  }
 }
 
Is there any way of doing this with a lamdba expression, or just by a master+nested foreach?
 
Thanks!

原文：https://stackoverflow.com/questions/34889101