how to add tables from diffrent schema in Ado Entity Data Mode with ORACEL

Question

using ADO.net EDM, how do you add a tables from diffrent schema into the edmx, the userid has access to all the schema, but since the table i want is under diffrent userid schema than the one i used for DB connection

Answer 1

Hi,

You can add tables from different schemas in EF, but you can't use different users. The user that you use to update your model needs to have access to all the schemas in question.

---

--Rune

Answer 2

Hi OK24,

I am writing to check the status of the issue on your side. Would you mind letting us know the result of the suggestions?

If you need further assistance, please feel free to let me know. I will be more than happy to be of assistance.

Have a nice day.

---

Alan Chen[MSFT]
MSDN Community Support | Feedback to us
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.