Stored proc in .net dataset class vs studio management
<p>Morning all. Got myself a simple query which returns ten rows in SQL Server Management Studio. I call the stored proc by right clicking it and feeding in the parameters.</p>

<p>The results are returned immediately. </p>

<p>In .NET we have set up a dataset class, added a table adapter whose select is this same procedure. I pass in the very same parameters and the execution times out after the standard 30 seconds.  It continues to run immediately when called in sql server management studio.</p>

<p>Any ideas why the execution time is seemingly infinite in the .net dataset class.</p>

<p>The query is very simple.</p>
