I'm executing a stored procedure that returns 15000 rows. I get that into a dataset using entity framework.
When i execute the stored procedure in ssms(sql server 2012) the execution time is 2 secs. However from .net code it is 56 secs not acceptable. This time is just for db call to fill dataset.
I tried setting isolation level to read committed for command object - no difference. in db it is read committed snapshot. I have no access to sql profiler because of policies in place.
is there any other way to solve this? Thanks for your time.