title: Chain Lambda Linq
body: <pre><code>public class Translation
  {
    public string LanguageCode { get; set; }
    public string Value { get; set; }
  }            
  
  public class tblEnumJobFunction
  {
   public string strEnum { get; set; }          
   public List&lt;Translation&gt; mlgValue { get; set; } //mlgValue-&gt;MultiLingualValue
  }
  </code></pre>
  
  <p>I have a <code>List&lt;tblEnumJobFunction&gt; JobFunctionList</code> with some data. </p>
  
  <p>Example Data:</p>
  
  <pre><code>JobFunctionList[0].strEnum="ENUM_Manager";
  JobFunctionList[0].mlgValue[0].LanguageCode ="EN";
  JobFunctionList[0].mlgValue[0].Value="Manager";
  
  JobFunctionList[0].mlgValue[1].LanguageCode ="DE";
  JobFunctionList[0].mlgValue[1].Value="Geschäftsführer";
  
  JobFunctionList[1].strEnum="ENUM_Student";
  JobFunctionList[1].mlgValue[0].LanguageCode ="EN";
  JobFunctionList[1].mlgValue[0].Value="Student";
  
  JobFunctionList[1].mlgValue[1].LanguageCode ="DE";
  JobFunctionList[1].mlgValue[1].Value="Schüler";
  </code></pre>
  
  <p>I can filter this list with LINQ by given country Code and happy with it.</p>
  
  <p>The Question is how can I write equivalent below query syntax by lambda with the List/Collection extensions?</p>
  
  <p>It is a cascade/chain query; looking into a list that is inside another list.</p>
  
  <p>This query syntax is working OK.</p>
  
  <pre><code>string CountryCode ="EN"; 
  var Query = from jobfunction in JobFunctionList
  from translation in jobfunction.mlgValue
   where translation.LanguageCode == CountryCode //'EN'
   select translation;
  </code></pre>
  
  <p>The Result is;</p>
  
  <pre><code>List&lt;string&gt; JobList;
  
  foreach (var translationitem in Query)
  {
      JobList.Add(translationitem .Value);
  }
  </code></pre>
  
  <p>now I have </p>
  
  <pre><code>JobList[0]="Manager";
  JobList[1]="Student";
  
  For CountryCode="DE" I have;
  JobList[0]="Geschäftsführer";
  JobList[1]="Schüler";
  </code></pre>
  
  <p>Is there any way to write above query syntax with lambda similiar to this one?</p>
  
  <pre><code>JobFunctionList.Select(a=&gt;a.mlgValue).Where(b=&gt;b....)...
  </code></pre>