Good afternoon,
I have a stored procedure that takes about 1minute and half, more or less, to execute (it's importing data and calculating something), i need to increase the timeout, how can i do this?
best regards
Good afternoon,
I have a stored procedure that takes about 1minute and half, more or less, to execute (it's importing data and calculating something), i need to increase the timeout, how can i do this?
best regards
Try setting CommandTimeout for the DbContext Database:
public partial class SampleContext
{
partial void OnModelBuilding(ModelBuilder builder)
{
Database.SetCommandTimeout(150000);
}
}
Sorry for the long reply.
unfortunately it didn't work the reason is in this link https://medium.com/aspnetcore/increase-the-timeout-of-asp-net-core-application-9a7b4f6deebf. Also the web.config did work.