Devart Forums

Is it possible to use integrated security with the dotConnect driver? (direct mode) Could not find this info in the doc

Thanx we'll give it a go..

Do you know of an alternative way to accomplish the wanted behaviour

When we attempt to use Collection.Contains in EF we get an error that this is not supported by the store. Currently we using version 5.00 of dotConnect.

example:
string[] list=new string[]{"test","test2"};
IQueryableresult = from p in Context.ITEM
where list.Contains(p.NAME)
select p;

Above snippet is not the exact example since i'm at home right now..
The desired effect is that above code will be executed as an ORACLE IN statement.
Please let me know what is the wat to go

Thanx for the info this will increase the performance of my code a lot

The view causing the problem is a view over another view(that is a join of 2 remote tables) in a remote database through a database link.(distributed environment)
eg CREATE OR REPLACE VIEW X
AS SELECT * FROM VIEW@dblink;

If i use a view that is a selection of a remote table over a databaselink everything works fine:
eg:CREATE OR REPLACE VIEW X
AS SELECT * FROM TABLE@dblink;


Can you tell me if the oradirect tool creates a pl/sql block in which the data is retrieved? What i find on the oracle-forum is that execution of view-data using db-links with a cursor on it can cause problems. Is this possible due to how the tool works internally?

Okay some more info. I have an EntityObject with a Primary key PARENT_ID and a bunch of related childs (that object wise refer to the parent). When i perform a add of the parent all the childs fail because the generated parent-id(with a before insert trigger) differs from the expected one)

It looks that the values in the Primary key need to be filled in the Model instead of in the database. Is this assumption correct? (this is how i dow it now- removed the triggers and implemented the logic myself)

okay i will proceed as you indicated (modify mapping afterwards)

when i perform a select on a given view i get: Devart.Data.Oracle.OracleException: ORA-01002: fetch out of sequence

This view is different from other ones in the sense that is a view base on a select where 3 remote tables over a database link are joined

Perfoming a select in sqlplus goes fine..maybe internally in oradirect it is performed in a pl/sql block?(read something obaut cursors causing problems) I also tried performing the select through a stored procedure(and map the result back to an entity but i get the same error)

Last week i ran into a problem that serverside generation of pk-values(id) was not synchronized okay with the client after adding the items..A save of a parent with childs generated a lot of (parent key not found). What i did to resolve this is generate the id's myself in the partial class. (and remove the before insert triggers on the db)

However some values might change because of triggers...what i would do at present time is detach the item and requery it.

My question : is there a way to auto-requery an object?

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.

Thanks for the info.
Do you have any idea when this ( i assume i will be in a next version) will be available?

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)

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

How do i cascade delete child items?(EF provider for Oracle) Do i really have to delete al child items seperately? Is there a way to force the wanted behaviour?