Hello all,

I have a simple Business Object with a method to return data as follows:

public mmBindingList<VCompStylPrcEntity> GetCompanyStylePrcByCompStylColorAndTerms(int compID, int stylID, string colorDesc, string termsDesc)
        {
            return this.GetEntityList<VCompStylPrcEntity>("CompStylPrcSelectByCompStylColorAndTerms",
                this.CreateParameter("@CompID", compID),
                this.CreateParameter("@StylID", stylID),
                this.CreateParameter("@ColorDesc", colorDesc),
                this.CreateParameter("@TermsDesc", termsDesc));
        }

Now when I execute this method in my test bench with parameters that would return all rows, it takes 30+ seconds to return the data, however, when I run the stored procedure that runs this method with the same parameters in SSMS it takes less than 1 second to return the same data. The number of rows being returned is just over 7,000 so its not a ridiculously large data result.

When I execute the method with parameters to limit the rows returned the method runs in one second to return 232 rows so it appears to be related to the returning of data. The result set only has 12 columns with all coluumns either ints, decimals or varchar(50).

Any ideas as to what this discrepancy in time could be related to.

TIA