sql timeout using dapper

hi all, im trying to use dapper in asp net core project and register this DapperContext as Transient

im trying to make a request to GetNote endpoint, inside this GetNote endpoint there will be lots of request made to multiple tables, and after some time, i will get an exception from my api like this :

Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding


can anyone help advise what could be the possible issue (im wondering if the Transient is correct)? i increased the Connection Timeout to 1000 already..
Was this page helpful?