I was granted access to a table and a view from sysadm, for my account Adm_GT, and was trying to Scaffold DBContext using Oracle EntityFramework Core 6.0.8 using PMC as below
Scaffold-DbContext "User Id=Adm_GT;Password=<PASS_321>;Data Source=DBPROD;" Oracle.EntityFrameworkCore -OutputDir Models\GT -ContextDir Data -Schemas sysadm -Tables sysadm.ps_KS_Adm_GT_VW, sysadm.ps_KS_Adm_LUPDT -DataAnnotations -NoOnConfiguring -Context GTDbContext
Builds runs successfully, but no models are created showing the message:
Unable to find a schema in the database matching the selected schema 'sysadm'.
Unable to find a table in the database matching the selected table 'sysadm.ps_KS_Adm_GT_VW'.
Unable to find a table in the database matching the selected table 'sysadm.ps_KS_Adm_LUPDT'.
Does Oracle EntityFramework Core support scaffolding views and tables from different schema?
knowing that I can access these from Oracle Sql Developer, only using SQL queries.