Exception while creating migration sql file

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
gger
Posts: 2
Joined: Fri 13 Jul 2018 05:54

Exception while creating migration sql file

Post by gger » Mon 22 Nov 2021 07:46

Hi,
I'm getting exception while creating migration script using such command:
dotnet ef migrations script --startup-project MyApp --context MyAppContext --idempotent --no-transactions --output "MyApp.sql"

Exception first occured after upgrading project to .NET 6 and to newest devart library.

Project references
<ItemGroup>
<PackageReference Include="Microsoft.EntityFrameworkCore" Version="5.0.12" />
<PackageReference Include="Devart.Data.Oracle" Version="9.14.1382" />
<PackageReference Include="Devart.Data.Oracle.EFCore" Version="9.14.1382" />
<PackageReference Include="Microsoft.EntityFrameworkCore.Design" Version="5.0.12">
<PrivateAssets>all</PrivateAssets>
<IncludeAssets>runtime; build; native; contentfiles; analyzers; buildtransitive</IncludeAssets>
</PackageReference>
<PackageReference Include="Microsoft.EntityFrameworkCore.Relational" Version="5.0.12" />
</ItemGroup>

Exception
System.ArgumentNullException: Value cannot be null. (Parameter 'source')
at System.Linq.ThrowHelper.ThrowArgumentNullException(ExceptionArgument argument)
at System.Linq.Enumerable.Select[TSource,TResult](IEnumerable`1 source, Func`2 selector)
at Devart.Common.Entity.Migrations.f.a(DropForeignKeyOperation A_0)
at Devart.Common.Entity.Migrations.f.b(MigrationOperation A_0)
at Devart.Common.Entity.Migrations.f.a(IEnumerable`1 A_0)
at Devart.Common.Entity.Migrations.g.a(IEnumerable`1 A_0, da A_1)
at Devart.Data.Oracle.Entity.Migrations.OracleEntityMigrationSqlGenerator.Generate(IReadOnlyList`1 migrationOperations, IModel model, MigrationsSqlGenerationOptions options)
at Microsoft.EntityFrameworkCore.Migrations.Internal.Migrator.GenerateUpSql(Migration migration, MigrationsSqlGenerationOptions options)
at Devart.Common.Entity.Migrations.d.a(Migration A_0, MigrationsSqlGenerationOptions A_1)
at Microsoft.EntityFrameworkCore.Migrations.Internal.Migrator.GenerateScript(String fromMigration, String toMigration, MigrationsSqlGenerationOptions options)
at Devart.Common.Entity.Migrations.d.GenerateScript(String fromMigration, String toMigration, MigrationsSqlGenerationOptions options)
at Microsoft.EntityFrameworkCore.Design.Internal.MigrationsOperations.ScriptMigration(String fromMigration, String toMigration, MigrationsSqlGenerationOptions options, String contextType)
at Microsoft.EntityFrameworkCore.Design.OperationExecutor.ScriptMigrationImpl(String fromMigration, String toMigration, Boolean idempotent, Boolean noTransactions, String contextType)
at Microsoft.EntityFrameworkCore.Design.OperationExecutor.ScriptMigration.<>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)

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Exception while creating migration sql file

Post by Shalex » Mon 22 Nov 2021 14:21

Thank you for your report. We will notify you when the issue is fixed.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Exception while creating migration sql file

Post by Shalex » Wed 01 Dec 2021 14:48

The bug with generating the "Value cannot be null" error when adding or dropping FK via Code-First Migrations in EF Core is fixed. We will notify you when a new public build of dotConnect for Oracle is available for download.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Exception while creating migration sql file

Post by Shalex » Thu 27 Jan 2022 17:06

The bug with generating the "Value cannot be null" error when dropping indexes via Code-First Migrations in EF Core is fixed in dotConnect for Oracle v9.16.1434.

Post Reply