Page 1 of 1

Exception while creating migration sql file

Posted: Mon 22 Nov 2021 07:46
by gger
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)

Re: Exception while creating migration sql file

Posted: Mon 22 Nov 2021 14:21
by Shalex
Thank you for your report. We will notify you when the issue is fixed.

Re: Exception while creating migration sql file

Posted: Wed 01 Dec 2021 14:48
by Shalex
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.

Re: Exception while creating migration sql file

Posted: Thu 27 Jan 2022 17:06
by Shalex
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.