title: C# lambda Join & Update
body: <p>I use entity framework.
  The class List is</p>
  <pre><code>class List
  {
  public string cid { get; set; }
  public string type{ get; set; }
  public string memo{ get; set; }
  public DateTime sdate{ get; set; }
  }
  </code></pre>
  <p>and count about 50.</p>
  <p>I want join the table about members.
  members's columns are:
  id,cid,name,address</p>
  <pre><code>var result =
  thelist.Where(w =&gt; !string.IsNullOrWhiteSpace(type)).Join(db.members,list =&gt; list.cid,member =&gt; member,(list,member) =&gt; list).ToList();
  </code></pre>
  <p>-&gt; Not sure to work.</p>
  <p>I want get the list record that cid in table members.
  and update list's memo with members's name.</p>
  <p>Can I do that by using lambda ??</p>