FirebirdSQL / NETProvider

Firebird ADO.NET Data Provider
https://www.firebirdsql.org/en/net-provider/
Other
158 stars 65 forks source link

EnableRetryOnFailure not provided for this driver #1186

Closed victorvilella closed 1 month ago

victorvilella commented 1 month ago

My App has connection with multiple databases with same structure (tables, stored procedures, triggers, etc).

When FB connection is lost I can't easily rebuild my connection pool. When it occurs the only way to resolve this problem is restart entire application.

Looking in my project, I did not found EnableRetryOnFailure() on OnConfiguring() method inside my context.

I'm using .NET Core 8 with EFCore 8.

Did I missed some detail? Thanks in advance.

cincuranet commented 1 month ago

You did not miss it. There's no retry strategy implementation shipped inside EF Core provider for Firebird. If you feel like implementing one, consider creating a PR.

BTW you don't have to restart entire application, just retrying the operation is (should be) enough.

victorvilella commented 1 month ago

Alright. I'll try to make a PR about this feature someday.

Thanks.