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
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..