Implement Async versions of Ado.Net methods

[Giorgi]

Ado.Net classes such as DbCommand, DbConnection have async methods that aren't truly async and just execute the non-async versions and return their result. It would be nice if ODP.NET had a real implementation of those methods (the same way other database providers have) and was truly async.

[alexkeh]

@Giorgi This is a feature the dev team is working on. I'll have better visibility to when we can deliver this feature in the second half of this year. You can ask me then.

[iinuwa]

Hello @alexkeh, is there an update on this request?

[alexkeh]

Ping me back in a couple of months. We're busy shipping the next 21c release right now. Once done, we'll have more visibility which release we'll be able to slot async in as we continue to make progress.

[luboid]

Is there progress on the issue

[alexkeh]

@luboid
We're making progress, but I don't have a public timeline to share just yet. There's a wide range of dates possible depending on how the testing goes. It won't be with our next major ODP.NET release at the end of the year. That one will have .NET 6 and EF Core 6 support. Once that release goes out, I should be able to provide a time range for release.

[ksantoso]

Hi @alexkeh , is there any update on the estimated timeline for this async release?

[alexkeh]

@ksantoso ODP.NET async is planned for release around the end of this year. It's part of our next major release.

[iinuwa]

To confirm, that's around Q4 2022?

[alexkeh]

CY Q4 2022 seems most likely at this time.

[ricardodemauro]

Hi @alexkeh.

Just checking. Is it still planned for CY Q4 2022?

Thanks,

[alexkeh]

It's looking like the release will be past Q4 this year. ODP.NET async will be released alongside Oracle's next major DB release and that release is not looking like it will make it by the end of the year.