0

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.

Improve this question
5
  • need alittle more to go on, like class structure, select only shows 1 table... Commented Aug 2, 2017 at 4:31
  • @mvermef the example in the link is just like my class structure, that is what i used to create the class structure. the FromSql has 3 tables, the snippet i had is to show how i implement that Commented Aug 2, 2017 at 15:56
  • keep in mind that your SELECT is only 1 table. Secondly EF Core doesn't implement lazy loading yet, at least not in 1.1 and I don't think it will in 2.0's initial release either. Commented Aug 4, 2017 at 4:36
  • as far as I can tell they aren't supporting EFC either... .net standard 1.3 is all that is available which means full .net stack with OracleCommands... devart.com/dotconnect/oracle/docs/… on top of that devart.com/dotconnect/oracle/compatibility.html 8i isn't supported for EF without oracle9+ ( 9.2.0.4) Commented Aug 4, 2017 at 5:01
  • not trying to be Debbie downer here but I think you are stuck with versioning issues at this point, Oracle doesn't even support .NET Core, at least not yet. Commented Aug 4, 2017 at 5:03
Related questions
2
Ado.Net entity framework, linq: select multiples tables
1
entity framework query, how to select more than 1 table?
2
Selecting data from multiple tables in MVC
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.