I am pretty much trying to do a query for multiple tables from an Oracle 8i database. Using Devart dotconnect to a .net core applicaiton. I am aware the joins were not available back then, but has anyone found a way to do this?
I have tried the solution in this link: Example1 but just like the question i still retrieve null for the second table. My models are exactly the same
I have also tried the 'FromSql' and passing an sql. I am able to run this query in Toad for Oracle and retrieve data from multiple tables, but it does not work in my application.
var listData = _context.Team
.FromSql("select * from Team where order = '178'")
.ToListAsync();
This also returns a json for the firsts table and null for the second table values.
Can this not be achieved with oracle 8i or the problem else where or is there a workaround.