title: What is the best way to load and reuse List<DataRow> objects in MVC controller
body: <p>I am developing a MVC project though I am new in MVC, where I have a function which is loading database values. I am using this function in different places within the same controller. When I have checked the SQL profiler, I found that everytime its running the procedure where I used that function.</p>
  
  <p>My question is what is best way to use the function which will call the procedure in the first time and from next time, it will use the same value.</p>
  
  <p>Thanks in advance</p>
  
  <p>Updated:</p>
  
  <pre><code>public List&lt;DataRow&gt; SalesCount()
  {          
      List&lt;DataRow&gt; lstSales = new List&lt;DataRow&gt;();
      string str_salesClass = adding session value here;    
      return lstSales = SalesRepository.SalesCount(SessionValue);        
  }
  </code></pre>