Update model from Oracle database does not see columns

Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
Post Reply
vdobzinski
Posts: 4
Joined: Fri 05 Mar 2010 11:18
Location: Vilnius

Update model from Oracle database does not see columns

Post by vdobzinski » Fri 10 Nov 2017 07:35

We have a problem where we cannot see columns of views/tables that are granted from another user.

Tables/views are in schema main_schema. We are trying to access them from user user_schema (all views/tables are granted with select privilege).

Connected to DB, created table TBL with one column named columnA.
Created an editionable view on the table (Edition based redefinition is enabled in our schemas).
Granted the view to user_schema (the user we are connecting with).
Checked if we can reach the view with a query - all is good.

create table tbl(columnA number);
create editionable view tbl_v as select columnA from tbl;
grant select on tbl_v to user_schema;
select * from main_schema.tbl_v;

Oracle version used: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

We are using Entity Developer with Devart.dotConnect for Oracle in asp.net mvc application:
Devart version 8.5.535

We connect with Entity Developer to Oracle DB as user_schema user and try to "Update Model From Database..."

We can select view tbl_v from the list of main_schema objects
TBL_V (Added)

Then we add this view to Model.
But storage editor does not see any columns in this object

Shalex
Site Admin
Posts: 8245
Joined: Thu 14 Aug 2008 12:44

Re: Update model from Oracle database does not see columns

Post by Shalex » Tue 14 Nov 2017 13:09

We cannot reproduce the issue with the newest (9.5.381) build of dotConnect for Oracle. Please upgrade.

If this doesn't help, specify:
1) are you using a standalone Entity Developer or the one embedded in Visual Studio (VS version?)?
2) is your connection OCI (via Oracle Client) or Direct?
3) set primary key for columnA in TBL (then redo: create a view and grant select). Does this make any difference?

vdobzinski
Posts: 4
Joined: Fri 05 Mar 2010 11:18
Location: Vilnius

Re: Update model from Oracle database does not see columns

Post by vdobzinski » Mon 04 Dec 2017 12:19

We are using:
1) Embedded entity developer with Visual Studio 2013 Professional;
2) OCI mode (Oracle client 11.1 version);
3) primary key does not help in our situation.

Shalex
Site Admin
Posts: 8245
Joined: Thu 14 Aug 2008 12:44

Re: Update model from Oracle database does not see columns

Post by Shalex » Thu 07 Dec 2017 19:41

We are investigating your case.

Shalex
Site Admin
Posts: 8245
Joined: Thu 14 Aug 2008 12:44

Re: Update model from Oracle database does not see columns

Post by Shalex » Mon 11 Dec 2017 19:48

We still cannot reproduce the issue.

1. Upgrade to the newest (9.5.399) build of dotConnect for Oracle.
2. Please try connecting in the Direct Mode. Does this make any difference?

Post Reply