Issue:
When trying to query a view (not a materialised view) in EF Core with Oracle, it returns 0 results with no errors.
Query:
For example, run the below query, which just selects 1
for each row of the view. This is using SqlQueryRaw
so I can be clear the issue is not with the mapping.
var results = Context.Database.SqlQueryRaw<int>("SELECT 1 FROM MY_VIEW").ToList();
Expected:
I expect a list of 1
s for each row the view returns.
Actual:
The list returns 0 results, with no errors.
Version:
DotNet: 9.0
Oracle.EntityFrameworkCore: 9.23.90