title: Select single row with LINQ TO SQL
body: <p>I start deal with LINQ To SQL and I try solve this primitive problem.
  I have very simple table with two columns.</p>
  
  <ul>
  <li>Nick - key, unique</li>
  <li>Password</li>
  </ul>
  
  <p>I would like delete row with some nick value.</p>
  
  <p>I use this method:</p>
  
  <pre><code>    public void DeleteSpiritUser(string nick)
      {
          var user = from u in _dc.Spirit_Users where u.Nick == nick select u;
  
          using (var scope = new TransactionScope())
          {
              _dc.Spirit_Users.DeleteOnSubmit(user.First());
  
              try
              {
                  _dc.SubmitChanges();
              }
              catch (Exception exception)
              {
                  throw exception;
              }
              scope.Complete();
          }
      }
  </code></pre>
  
  <p>Problem is that I must use user.First() if I want one single row, I would like select with LINQ only one row know IEnumerable, because Nick is unique.</p>