none
Visual Studio 2019 & Data Connection & Entity Framework Wizard (Oracle) RRS feed

  • Question

  • I'm trying to do two things with VS2019 and am having some trouble.

    First, I'm trying to create a Data Connection to an Oracle database that I can use when creating all the Entity Framework contexts, etc. I am able to create a connection, but I really need to specify that it uses a different schema in the Oracle database.

    Second, I'm trying to use the Data Connection I created as I go through the Entity Framework Wizard (I need to import the database schema so I can use EF in my code). The problem I am having here is that the Data Connection that I previously created doesn't appear as an option in the combo box for "Which data connection should your application use to connect to the database?"

    So, here are my questions which both need to be solved for me to import my database into EF:

    1. How do I specify the schema when I create the Data Connection (without this, I won't be able to choose tables for the Entity Framework Wizard—there are no objects in the default schema)?
    2. Where is my connection when I'm going through the EF Wizard?

    After I get these two issues solved, then I can try and actually complete the EF Wizard.

    Thanks,
    Jay

    Tuesday, April 16, 2019 11:51 PM

All replies

  • Hi Jay Williams

    Welcome to the MSDN forum.

    Based on your description, I will help you move to an appropriate forum for a better supporting. Thank you for your understanding.

    Sincerely

    May  



    MSDN Community Support Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Wednesday, April 17, 2019 8:09 AM
  • Hi Jay,

    To use Entity Framework to access Oracle, here is an article you can refer to:

    Entity Framework 6, database-first with Oracle.

    Regards,

    Kyle

    Note: This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; Therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Thursday, April 18, 2019 6:20 AM