EF Core 3.1 Scaffolding ORA-01795: maximum number of expressions in a list is 1000

[[email protected]]

Hi, When scaffolding with ef core 3.1 using Devart.Data.Oracle.EFCore 9.11.980 i get the following exception:

Devart.Data.Oracle.OracleException (0x80004005): ORA-01795: maximum number of expressions in a list is 1000
at Devart.Data.Oracle.dl.a(au A_0, Int32 A_1)
at Devart.Data.Oracle.dl.a(Int32 A_0, bt A_1)
at Devart.Data.Oracle.OracleCommand.InternalExecute(CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)
at Devart.Common.Entity.Design.b.a(DatabaseModel A_0, DbConnection A_1, cn A_2, Dictionary`2 A_3, String A_4, Boolean A_5)
at Devart.Common.Entity.Design.b.a(DatabaseModel A_0, DbConnection A_1, Dictionary`2 A_2)
at Devart.Common.Entity.Design.a.a(DbConnection A_0, a A_1)
at Devart.Common.Entity.Design.a.a(String A_0, a A_1)
at Devart.Common.Entity.Design.a.a(String A_0, DatabaseModelFactoryOptions A_1)
at Microsoft.EntityFrameworkCore.Scaffolding.Internal.ReverseEngineerScaffolder.ScaffoldModel(String connectionString, DatabaseModelFactoryOptions databaseOptions, ModelReverseEngineerOptions modelOptions, ModelCodeGenerationOptions codeOptions)
at Microsoft.EntityFrameworkCore.Design.Internal.DatabaseOperations.ScaffoldContext(String provider, String connectionString, String outputDir, String outputContextDir, String dbContextClassName, IEnumerable`1 schemas, IEnumerable`1 tables, Boolean useDataAnnotations, Boolean overwriteFiles, Boolean useDatabaseNames)
at Microsoft.EntityFrameworkCore.Design.OperationExecutor.ScaffoldContextImpl(String provider, String connectionString, String outputDir, String outputDbContextDir, String dbContextClassName, IEnumerable`1 schemaFilters, IEnumerable`1 tableFilters, Boolean useDataAnnotations, Boolean overwriteFiles, Boolean useDatabaseNames)
at Microsoft.EntityFrameworkCore.Design.OperationExecutor.ScaffoldContext.<>c__DisplayClass0_0.<.ctor>b__0()
at Microsoft.EntityFrameworkCore.Design.OperationExecutor.OperationBase.<>c__DisplayClass3_0`1.<Execute>b__0()
at Microsoft.EntityFrameworkCore.Design.OperationExecutor.OperationBase.Execute(Action action)
ORA-01795: maximum number of expressions in a list is 1000


I don't event know what database object throws this error. How can i know which object throws this error? Can you please have a look?

Thanks

[Shalex]

The bug with using Scaffold-DbContext in EF Core and EDM Wizard in EF with more than 1000 tables/views is fixed.

The internal build with the fix is available at https://download.devart.com/nuget_oracle_9_11_1010.zip.

[[email protected]]

When will it be available at nuget.org?

Thanks

[Shalex]

We are planning to release the new public build next week.

[Shalex]

New build of dotConnect for Oracle 9.11.1034 is available for download: viewtopic.php?f=1&t=41287.