title: Converting sql query to linq new in linq
body: <p>As i am new to linq can you please help me converting below sql query to linq.  </p>
  
  <pre><code>Select o.* from [Order] o Left Join TransactionsTable yo on o.Id = yo.OrderId                           
  Where yo.OrderId is null and Convert(date,o.CreatedOnUtc) = 
  Convert(date,getutcdate()) and  o.OrderStatusId = 1
  </code></pre>