title: Transition from COM context error in WPF when fetching large amount of data from SQL
body: <p>I am working on <code>wpf</code> application.  This application is used to show the reports.  For this I have two tabs: one tab to select the columns from <code>listview</code> and other filters, the second tab shows the result from <code>sql</code> table.  Here for dynamic query I am making a query on server side and pass this in stored procedure as parameter there I am executing it using execute method. </p>
  
  <p><strong>Problem :</strong></p>
  
  <p>It works fine if I select some columns out of total 170, but when I select all columns in list view and try to go on other tab it remains on the same tab and throws the exception:</p>
  
  <pre><code>The CLR has been unable to transition from COM context 0xc40048 to COM context
  0xc401b8 for 60 seconds. 
  </code></pre>
  
  <p>there is thousands of rows fetch for this.</p>
  
  <p><em><strong>Question :</em></strong></p>
  
  <p><em>1.)how i can make execution fast for query.</em></p>
  
  <p><em>2.)Steps to make table more fast for fatching data.</em></p>