title: Linq - Retrieve a single value in a String
body: <p>I use Asp.net 3.5 and EF 4.</p>
  
  <p>I need find a specific row in my DataBase and display on a label a single value as string.</p>
  
  <p>At the moment I use this code, it is working, so I find a single Object and read its properties.</p>
  
  <pre><code> var myAuthor = (from at in context.CmsAuthors
               where at.AuthorId == myRow.AuthorId
               select at).Single();   
   myAuthorNameLabel.Text = myAuthor.LastName;
  </code></pre>
  
  <p>I would like to know:</p>
  
  <ul>
  <li>If there is another syntax in Linq to achieve the same result.</li>
  <li>How to do it using Lamba?</li>
  <li>Which approach would you suggest me?</li>
  </ul>