Not sure if this is the right place.. But I am getting an error when attempting to add a table in EF core, that has a materialized view in a different schema by the same name (mview container_name = table_name of table being added)
the circled part of the query (I got this from doing verbose logging on the db scaffolding command) is causing TRAFFIC.ASSOCIATE to be excluded, because there exists a materialized view IMPORT.ASSOCIATE.
could this not be changed to table_name not in(select container_name from all_mviews where owner <> t.owner)
I added a text file containing my scaffolding command along with the verbose logging. It's failing because TRAFFIC.ASSOCIATE isnt included in Oracle.EntityFrameworkCore's list of tables, so it gets the error “Sequence contains no matching elements”
commandPlusVerboseLog.txt