title: Difference between First, FirstOrDefault and singleOrDefault keywords in ORM
body: <p>eI need to select a particular single data element from first row ordered descending by date.  Please specify the differences between the following keywords.</p>
  
  <ul>
  <li>First</li>
  <li>FirstOrDefault</li>
  <li>singleOrDefault </li>
  </ul>
  
  <p>Also need the precedence/order and usage rules of placing Orderby, where &amp; select in Linq ORM Query. It would be much helpful if answer could be clear &amp; descriptive.</p>
  
  <p>Thanks in advance</p>