void Oracle.EntityFrameworkCore.Scaffolding.Internal.OracleDatabaseModelFactory.GetColumnsCombined(DbConnection connection, string tableFilter, DatabaseModel databaseModel, Func<string, string> schemaFilter, List paramList, string databaseCollation) Fails with an exception when being called from EF Core Power Tools.
Using Oracle Data Tools Extension in Visual Studio 2022 17.14.6 and getting the exception
Table list error:
System.InvalidOperationException: Sequence contains no matching element
at void System.Linq.ThrowHelper.ThrowNoMatchException()
at TSource System.Linq.Enumerable.Single(IEnumerable source, Func<TSource, bool> predicate)
at void Oracle.EntityFrameworkCore.Scaffolding.Internal.OracleDatabaseModelFactory.GetColumnsCombined(DbConnection connection, string tableFilter, DatabaseModel databaseModel, Func<string, string> schemaFilter, List paramList, string databaseCollation)
at void Oracle.EntityFrameworkCore.Scaffolding.Internal.OracleDatabaseModelFactory.GetTablesCombined(DbConnection connection, Func<string, string, string> tableFilter, DatabaseModel databaseModel, Func<string, string> schemaFilter, List paramList)
at DatabaseModel Oracle.EntityFrameworkCore.Scaffolding.Internal.OracleDatabaseModelFactory.Create(DbConnection connection, IEnumerable tables, IEnumerable schemas) x 3
at DatabaseModel RevEng.Core.TableListBuilder.GetDatabaseModel() in D:/a/EFCorePowerTools/EFCorePowerTools/src/Core/RevEng.Core.80/TableListBuilder.cs:line 132
at List RevEng.Core.TableListBuilder.GetTableModels() in D:/a/EFCorePowerTools/EFCorePowerTools/src/Core/RevEng.Core.80/TableListBuilder.cs:line 43
at async Task EfReveng.Program.Main(string[] args) in D:/a/EFCorePowerTools/EFCorePowerTools/src/Core/efreveng80/Program.cs:line 60
I initially opened an issue on the EFCPT GitHub site and they closed it and referred me to Oracle support: https://github.com/ErikEJ/EFCorePowerTools/issues/3007
This Reverse Engineering Process was working on my computer 4/15/25 - 6/1/2025 timeframe. Probably before I upgraded to ODT 23.8.0 and Oracle.EntityFrameworkCore 8.23.80