CRUD pages not generated for Oracle 12c tables with IDENTITY

Radzen Studio Blazor Server
1

Just noticed the Radzen / Oracle EF does not generate CRUD pages for Oracle 12c tables that have an IDENTITY column.

2

Are those tables having a primary key constraint? This is a mandatory requirement for CRUD page generation.

1 Like
3

OK, got it to work and generate CRUD pages today.
Table definition from Oracle is:

CREATE TABLE QuickBudget(
    ID NUMBER(9,0) GENERATED ALWAYS AS IDENTITY MINVALUE 1 MAXVALUE 99999999 INCREMENT BY 1 START WITH 1 nocache NOCYCLE primary key,
    USERNAME        VARCHAR2(50 BYTE),
    BUDGET_SET      VARCHAR2(10 BYTE),
    CATEGORY_NAME   VARCHAR2(50 BYTE),
    ACCOUNT_MASK    CHAR(20 BYTE)
)

This is nice because I want the database to take care of generating the key field ID values.

Thank you.