title: Inner join with LINQ
body: <p>I'm new to LINQ, can someone help me how to convert below query to LINQ:</p>
  
  <pre><code>select c.cityname, c.cityid from country cn
  inner join [State] st on cn.stateid = st.stateid
  inner join [city] c on c.cityid = st.cityid where 
  cn.countrid = 'cn001' order by c.cityname
  </code></pre>