Radzen apps can connect to Oracle databases starting from 12c version. All you need to do is specify the connection string. Radzen will discover the schema and create an OData service which will expose the tables as OData entities.
- The OData services that Radzen generates requires .NET Core 2.2. As a result Radzen will not create a Oracle data source unless .NET Core 2.2 is installed.
This tutorial will show you how to connect to a Oracle database, read, add, update and delete data.
Quick video - CRUD pages from Oracle data source
Make sure you have installed .NET Core. Follow the installation instructions.
How to build the application
- Step 1: Create and configure the application
- Step 2: Add the Oracle data source
- Step 3: Automatically generate CRUD pages
Create a new Radzen application by following the first step from the quickstart guide.
In this step we create a data source that connects to a Oracle database.
- Open the application that you created in the previous step for editing.
- Click data to go to the My DataSources screen.
- Click new to add a new data source.
- Select Oracle as data source type.
- Pick a Name for your data source.
- Enter the Oracle connection info - server, database name, user and password.
- Click Next.
- Radzen will connect to the database and infer all tables and views. By default all tables are checked and you can choose/uncheck tables and/or table properties and views needed for your application.
- Check the Generate pages for CRUD operations check-box.Radzen can create pages only for tables with primary keys. For views only read page will be created.
- Radzen will open Edit and Add pages by default in dialogs. Uncheck the check-box if you want to have navigation instead.
- Check the Enable optimistic concurrency check-box if you want to enable automatically optimistic concurrency.
- Click Finish.
You can now run the application to verify that you have full CRUD support.