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.

[BaraOne]

Hi @alexkeh Q4 has started. Any updates on this? Regards

[alexkeh]

ODP.NET async in managed and core versions will be released with Oracle DB 23c as announced during Oracle CloudWorld. The release won't be in Q4 2022 though. It will be sometime next year. Keep an eye out for when Oracle RTMs DB 23c.

[alexkeh]

If your team wants to try ODP.NET async, sign up to join the Oracle DB 23c beta program. ODP.NET 23c (managed and core) will support .NET async await in for DB 19c and higher.

[will-scc]

Hi @alexkeh, can I confirm the following: is it also the case that Oracle.EntityFrameworkCore does not currently supported .NET async/await but should do in the 23c release and when it does only for databases which are 19c and later?

[alexkeh]

That's correct. ODP.NET 23c will be the first to support async/await. ODP.NET 23c will support only DB 19c and higher.

[say25]

@alexkeh Is there a timeline or place we can follow to see when the 23C driver will leave private beta and/or be officially released?

[alexkeh]

@say25 When we have a public date for the ODP.NET 23c release, I'll announce it on my blog and the Oracle .NET Twitter channel. It's unlikely we'll publish a timeline for pre-production releases as those releases tend to be released when they meet specific quality metrics.

For 23c beta customers, ODP.NET 23c availability will be announced through the beta email updates.

[alexkeh]

ODP.NET Core and Managed ODP.NET 23.2 Dev Release are now available on NuGet Gallery with support for async. You can learn more about using ODP.NET async here.

[say25]

@alexkeh and news on getting a production release published for 23?

[alexkeh]

@say25 First half of 2024.

All DB 23c server and client software will be released in production at the same time.