Script generation broken for EF 6.4.4 with dotconnect for Oracle
Posted: Wed 08 Sep 2021 07:09
Good morning,
I am using Devart.Data.Oracle.EF6 9.14.1273 with EntityFramework 6.4.4 and see an annoying bug with sql script generation:
When I run
I receive a .sql file like
instead of the expected
the missing code ends up in the Visual Studio Package Management Console. It seems like for some multiline statements only the first line is written to the file. This is especially annoying, if I have multiple of those statements in one migration, since I have to manually reorder them.
The problem occurs with both .Net Framework 4.8 and .Net 5.
Is there a way to circumvent this?
Kind regards
Peter
I am using Devart.Data.Oracle.EF6 9.14.1273 with EntityFramework 6.4.4 and see an annoying bug with sql script generation:
When I run
Code: Select all
Update-Database -Verbose -ProjectName MyProject -ConnectionString "xxx" -ConnectionProviderName "Devart.Data.Oracle" -Script
Code: Select all
ALTER TABLE USER.BOX_VERSIONS
MODIFY CREATION_DATE TIMESTAMP(0) WITH TIME ZONE DEFAULT NULL
/
DECLARE
Code: Select all
ALTER TABLE USER.BOX_VERSIONS
MODIFY CREATION_DATE TIMESTAMP(0) WITH TIME ZONE DEFAULT NULL
EXECUTE IMMEDIATE 'ALTER TABLE USER.BOX_VERSIONS MODIFY CREATION_DATE NOT NULL';
EXCEPTION
WHEN OTHERS THEN
IF SQLCODE <> -1451 AND SQLCODE <> -1442 THEN
RAISE;
END IF;
END;
/
DECLARE
BINARY_VALUE BLOB;
BEGIN
DBMS_LOB.CREATETEMPORARY(BINARY_VALUE, TRUE);
DBMS_LOB.APPEND(BINARY_VALUE, TO_BLOB(CAST('...' AS LONG RAW)));
INSERT INTO USER."__MigrationHistory" ("MigrationId", "ContextKey", "Model", "ProductVersion") VALUES ('202109080628292_Test', 'Qm.Tda.Dal.Migrations.Configuration', BINARY_VALUE, '6.4.4');
END;
The problem occurs with both .Net Framework 4.8 and .Net 5.
Is there a way to circumvent this?
Kind regards
Peter