title: How to write good LINQ query for this?
body: <p>I have a LINQ Query. When i run the query it takes so much of time to perform the operation. How can i modify the query to perform good. here is the LINQ query.</p>
  
  <p><strong>Query</strong></p>
  
  <pre><code>var model = (from items in Db.Items
                           where items.ItemNo == DD.ItemNumber
                           select new ViewModel()
                           {
                               INo = items.ItemNo,
                               BTags = (from asd in Db.BibContents where asd.BibId == items.BibId &amp;&amp; asd.TagNo == "245" &amp;&amp; asd.Sfld == "a" select asd.Value).FirstOrDefault(),
                               Sid = (from stat in Db.ItemStatus1 where stat.Id == items.StatusId select stat.Description).FirstOrDefault(),
                               Option = DD.Option
                           }).ToList();
  </code></pre>