0
As I do in a connection to the Oracle database, show all tables. made a connection and I have over 500 tables in the bank and only shows 74, that the three I need to mount the POC that I’m doing, I’m not able to map them.
see the tables that appear. As they are in alphabetical order, the tables I want, start with POC and note that in the letter P has no:
0
I solved it. After a lot of stirring, I saw that in the connection, opening it, there is a tab called Filters. In it, among some options, there is one that we can add and remove schemas. I added the desired schema and now I could map the three tables I needed.
Browser other questions tagged c# asp.net-mvc entity-framework oracle
You are not signed in. Login or sign up in order to post.
Do you want to put the 500 in an Entity model? Did you try to do it right on the design, add, new item, date, Entity data model? Then create the connection and choose the tables.
– Ricardo
No, as I said only three that do not appear in the list. Only 3 tables I want to map.
– pnet
It depends on the user you used to log in. The 500 tables are all in the same user schema?
– Leonel Sanches da Silva
Yes, before I ran the Entity, the connection showed all of them and after I installed the ODAC and ran the connection inside the Entity, it no longer appears. Before also did not appear, then appeared an option of New Query and something else, I do not remember more of the rest and I put and appeared all. Now that option is no longer available to me.
– pnet
Each user exchange requires you to make a new connection.
– Leonel Sanches da Silva
But I haven’t switched users. here in the company, for developers, it’s just a user and a scheme for everyone and we’re over 15.
– pnet
What I could see is the following. It(connection) shows a schema that does not exist. It created the schema name, the same user name, like this. User: ts_system and schema ts. And in the connection it looks like this: user: ts_system and schema: ts_system. I made a select within the connection to bring the table I want with the connection scheme and came nothing. I swapped the schema (in select) and managed to display the table data.
– pnet