Oracle.EntityFrameworkCore update statement and checking rows affected

[SierraNL]

When creating an update the following SQL is generated:

DECLARE
v_RowCount INTEGER;
BEGIN
UPDATE "MyTable" SET "Processed" = :p0, "Updated" = :p1
WHERE "Id" = :p2 AND "Type" = :p3 AND "MessageId" = :p4;
v_RowCount := SQL%ROWCOUNT;
OPEN :cur1 FOR SELECT v_RowCount FROM DUAL;
 
END;

This code is not efficient because it requires context switching and setting up a new cursor.

is there no other way within the framework that can process the return value of the UPDATE statement?

[alexkeh]

If Microsoft introduces a SaveChanges API in EF Core that doesn't require returning the number of rows to the database, then neither Oracle nor any other provider writer would have to retrieve this info.

[SierraNL]

Ok clear, but isn't it possible to return the SQL%ROWCOUNT without the cursor?

[alexkeh]

Good idea! We'll review whether this idea works. Thanks for the suggestion.

[alexkeh]

@SierraNL I've created a formal enhancement request (33050516) within Oracle's bug/ER tracking system to have a developer try this out.