pirrippu
✅ SQL Command Timeout does not work with async calls
Cheesus crust.
The problem is with MySql.Data, I tried using Pomelo as some suggested in other forums. But going back to your reply, yes, I do have cancellationToken and a command timeout. The problem was that if my client didn't configure a proper timeout, the query will run indefinitely because the cancellation does not work. So the command timeout is there as a final catch for this kind of scenario. And do note that this query is expected to run for more than few seconds due to the nature of the schema and that the query is there for the sake of example.
CommandTimeout
and CancellationToken
s are indeed working.The problem is with MySql.Data, I tried using Pomelo as some suggested in other forums. But going back to your reply, yes, I do have cancellationToken and a command timeout. The problem was that if my client didn't configure a proper timeout, the query will run indefinitely because the cancellation does not work. So the command timeout is there as a final catch for this kind of scenario. And do note that this query is expected to run for more than few seconds due to the nature of the schema and that the query is there for the sake of example.
25 replies
❔ Strategy for plugin architecture dependency injection
I see, thank you! But what you said above makes a good point, I'll do something similar.
Won't hurt me if I make an intermediate and separate
IServiceCollection
for DbContext
and other IOptions
I need for plugin configuration33 replies