title: Linq Entity Framework update query
body: <p>I want to convert a SQL query to an ADO.NET Entity Framework LINQ query. I'm working with MySQL.</p>
  
  <p>SQL:</p>
  
  <pre><code>Update Not As n 
  Inner Join user As a 
  On a.UserId = n.Not_UserId  
  Set Not_Checked='0' 
  Where n.Not_Checked='1' 
  And n.Not_UserId='" + Not_UserId + "'
  </code></pre>
  
  <p>LINQ: </p>
  
  <pre><code>var n5 = from u in db.user
           join n in db.not
           on u.UserId equals n.Not_UserId
           where n.Not_Checked==1 &amp;&amp; n.Not_UserId==4
           select new
           {
                 u,
                 n
           };
  </code></pre>
  
  <p>I want to update the value of <code>n</code>. I've tried <code>n5.n</code> but it didn't work. How to update <code>n</code> using LINQ EF?</p>