C
C#•2y ago
joy

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
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..
4 Replies
TheRanger
TheRanger•2y ago
1000 milli seconds?
joy
joy•2y ago
it's in second.. i saw this microsoft article defined 30 in seconds..
TheRanger
TheRanger•2y ago
maybe you can't connect to your database?
joy
joy•2y ago
i suddenly can get the api result after i remove the parallel async (using Task.WhenAll and now i use normal for loop instead) implemented inside my GetNote api, previously i change to use parallel async because the api return a result in a long time but im not sure why the Task.WhenAll causes the sql timeout issue..
Want results from more Discord servers?
Add your server
More Posts
How to make Random Password Generator [Answered]i just wirte this and cant continue pls helpget value from parallel for loop using Task.WhenAllhi all, im trying to implement a parallel for loop because of some timeout issue (the normal loop wiHow to use relative path in referenced project within same solution?I made a project for a simple Person object. In this project, I include a resources directory that cCan't read Json in WPFI don't think I understand this error. It requires an array? but how? Should I make a loop? ```cs c sharp property validation if value is nullhi all, im trying to do a properties validation if a value for my property for example **userName** File names for generic classI usually name my generic classes like Foo`1.cs. I believe Microsoft used to do that too, but looks Microsoft.Data.SqlClient.SqlException (0x80131904) Invalid object name 'Stand.Identity.Role'.What's wrong here? I do not understand what's going on... ```cs public class Context : DbContext { I can't JSON to List ;_; [Answered]```The JSON value could not be converted to System.Collections.Generic.List`1[Card]. Path: $ | LineNMVC + Blazor Proper approachWhat is the proper approach for working with MVC and Blazor nowadays? Earlier I stumbled upon peopleHow to pack dependencies with dotnet pack for a nupkg?Hi I am trying to include all dependency dlls when I do a dotnet pack in the cli for my nuget packag