title: How do I query only a single item from a database using LINQ?
body: <p>I would like to get a LINQ-to-SQL query that returns only one item, not a collection of them?</p>
  
  <p>For example, I have a list of products with a particular name.  There are no products with duplicate names in the database, so I want to be able to query and return just that instance of that product.  </p>
  
  <pre><code>Products product = from p in _productContext.Products 
                     where p.name.Equals("BrownShoes") 
                     select p;
  </code></pre>
  
  <p>How do I do something like that?</p>