Hello,
We are migrating a high profile .NET web app to .NET core. We are on Oracle(12c) EBS. All I/O is via stored procs with UDT parms. There are 100's of nested UDTs.
According to a scattering of info on here, twitter, & https://github.com/oracle/dotnet-db-samples/issues/56 UDTs are not yet available for the managed .NET ODP for .NET Core.
- What is the potential availability of this (earliest and latest estimates)?
- What advice do you have for migrating to .NET Core while continuing to use UDTs?
- Would this work:
- Continue (temporarily) to use existing .NET 4 services project that retrieves UDTs via current unmanaged ODP. (so no change)
- Build new .NET web project on .NET Core.
- Build new .NET class library project using .NET Standard. Migrate UDT classes from the .NET 4 services proj and make them POCO's (so trip out all the Oracle-specific references that wont work of course on .NET Standard). Then in the .NET 4 services proj, manually pass the UDT classes to the POCO's, where the POCO's will also be reference/available in .NET Core.
Thanks! Any advice would be appreciated!