If I generate a model from the database ; the selected views(partials) are not generated. For this DB we only have views (i think this worked okay when i used the oradirect trial a while ago).
Views are selectable but code is not generated.
Message is that there is no primary key for a view??? and that it will be excluded.
Using OraDirect.NET
Problem with Views
Since i cannot force the NOT null on a colum(deferred from source tables(datawarehouse)) i added a primary key..I still get the same error: my test-view:
CREATE OR REPLACE FORCE VIEW "TESTV" ("ID", "DATUM",
CONSTRAINT "ID_PK" PRIMARY KEY ("ID") RELY DISABLE) AS
SELECT 1,SYSDATE AS datum FROM DUAL;
please can you provide me with an working view example? Looks like for a view disabled keys are not valid(and this is the only type oracle 9i will allow)
CREATE OR REPLACE FORCE VIEW "TESTV" ("ID", "DATUM",
CONSTRAINT "ID_PK" PRIMARY KEY ("ID") RELY DISABLE) AS
SELECT 1,SYSDATE AS datum FROM DUAL;
please can you provide me with an working view example? Looks like for a view disabled keys are not valid(and this is the only type oracle 9i will allow)
Unfortunately, nothing can be done in current case.
As a temporary workaround you can create a table with primary key in your DB with the same column set as your view has,
add it to your Entity Data Model, and after that remap it manually to your view using XML Editor.
But we are working on the product which will allow to easily solve this and similar problems.
As a temporary workaround you can create a table with primary key in your DB with the same column set as your view has,
add it to your Entity Data Model, and after that remap it manually to your view using XML Editor.
But we are working on the product which will allow to easily solve this and similar problems.
Can you keep me posted on when this will become available? In my project (next timebox) i will have multiple views with only nullable columns and since (oracle 9i)indexes on the view are not used in dotNetConnect i will have to work-around this..I'd prefer not to use a work-around..however if the fix will be longer then let's say a month i will have to.