ExecuteReader in EntityFramework Takes 15 seconds to provide output But stored procedure returns response within 1 seconds

Asked Mar 20 '23 at 10:16

Active Mar 20 '23 at 10:16

Viewed 10 times

I have a API method which calls stored procedure to returns 3 dataset. I have used ExecuteReader to get the results from stored procedure !

Problem : Stored procedures returns data within 1 seconds, but the executeReader takes 15 t0 20 seconds to yield the output. May i know what is the problem here?

asked Mar 20 '23 at 10:16

Geethan Regunathan

ExecuteReader in EntityFramework Takes 15 seconds to provide output But stored procedure returns response within 1 seconds

0 Answers0