• Skip to main content
  • Skip to primary sidebar
  • Skip to footer
  • Home
  • Blog
  • Power Platform
    • Power Apps
    • Power Automate
    • Power BI
    • Power Virtual Agents
  • Dynamics 365
  • Azure
  • About Me
Joe Gill Logo

Joe Gill

Microsoft MVP - Power Platform Consultant

Home » .NET » ASP.NET Dynamic Data and Oracle

ASP.NET Dynamic Data and Oracle

27th April 2010 by Joe Gill Leave a Comment

ASP.NET Dynamic Data and Oracle Joe Gill Dynamics 365 ConsultantI thought some people may be interested in this. I had a go at using ASP.NET Dynamic Data against an Oracle database.

Firstly I installed Oracle Express with its demo HR data. I could see the database and its contents using server explorer in Visual Studio. However I was not able to select Oracle as a data source when I went to add the Entity Model to my project.

Once I installed Progress DataDirect Connect Oracle driver I was able to use that to create my entity model.  If you try this and get the “could not resolve sid” error trying using xe as the sid.

I generated the model and modified the global.asax as normal and ran the project. First impression are great as and in the example below you can see the Region foreign key drop down has been created and populated.

BTW – I used VS 2010 for this not sure about VS 2008

ASP.NET Dynamic Data and Oracle Joe Gill Dynamics 365 Consultant
Share This On Social:
  • Tweet
  • ASP.NET Dynamic Data and Oracle Joe Gill Dynamics 365 Consultant

Filed Under: .NET

Reader Interactions

Leave a Reply Cancel reply

You must be logged in to post a comment.

Primary Sidebar

Popular Categories

  • Power Platform
    • Power Apps
    • Power Automate
    • Power Virtual Agents
  • Azure
    • Logic Apps
  • Dynamics 365
  • .NET
  • AI
  • SQL

More to See

Power Platform Requests – Base Request Capacity

17th December 2020 By Joe Gill

Power Automate Desktop

Power Automate Desktop – UI Flow

26th November 2020 By Joe Gill

extract table from pdf and write as csv file using Power Automate Desktop

Extract Tables from a PDF using Power Automate Desktop

23rd May 2022 By Joe Gill

Dataverse Anonymization

25th April 2022 By Joe Gill

Tweets

Footer

Joe Gill

Microsoft Business Applications MVP – Power Platform, Dynamics 365 and Azure.

An architect with over twenty years experience designing and developing technology solutions. Specializing in the Microsoft technology stack including Power Platform, Dynamics 365 and Azure. Microsoft MVP Profile

Connect on Social

Useful Links

  • Home
  • Blog
  • About Joe Gill
  • Power Platform
  • Dynamics 365
  • Azure

Featured Posts

Power Platform Requests – Base Request Capacity

Power Automate Desktop – UI Flow

Synapse Link for Dataverse – Metadata

Extract Tables from a PDF using Power Automate Desktop

Dataverse Anonymization

Dataverse Metadata in Synapse

© 2022 · Joe Gill