Devart Forums

Hi All,
I am executing the simple select statement. It is taking 2 sec in SQL developer but in dbForge, it is taking 50 sec.

Os version: Windows 10 64 bit
DB :
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
PL/SQL Release 12.1.0.2.0 - Productionword counter VidMate Mobdro

CORE 12.1.0.2.0 Production
TNS for Linux: Version 12.1.0.2.0 - Production
NLSRTL Version 12.1.0.2.0 - Production

Thanks ,

Dear All,
i've probles to make queries when the data tipe is complex

{
"_id" : "DC396F11E04B",
"events" : {
"0 BOOTSTRAP" : true
},
"precondition" : "VirtualParameters.SerialNumber = \"DC396F11E04B\"",
"weight" : NumberInt(0),
"configuratio10.0.0.0.1 192.168.1.254 happymod

{
"type" : "provision",
"name" : "DC396F11E04B",
"args" : null
}
]
}

in this case when i use the find command i've invalid array error

how i can fix it?

The following invalid SQL is being generated by dotConnect for Oracle

SELECT "$it".JJIS_NUMBER AS "Value0", "$it".YOUTH_ID AS "Value"
FROM OYA.YOUTH "$it"
ORDER BY DBMS_LOB.SUBSTR("$it"."Value0"), "Value"
FETCH FIRST :p__TypedProperty_0 ROWS ONLYusps tracking showbox speed test


This leads to the following exception: Devart.Data.Oracle.OracleException (0x80004005): ORA-00904: "$it"."Value0": invalid identifier

To reproduce
1. Clone or download https://github.com/jwobbeoya/ReproDevartBug

2. Create the youth table with the Youth.sql script in the Ddl folder. The schema expected is OYA, but that can be changes if you update the schema in Consts.cs

3. Update appsetting.json with your connection string

4. Starting / Debugging the app with will cause invalid query to be generated

Hey everyone,

I'm trying to make database first approach in asp core 2.2.

My problem is that I can't find anything helpful to generate my model classes from my existing oracle database, I want to do it by anyway I don't care, but all my attempts failed so any help would be much appreciated192.168.0.1 routerlogin 192.168.l.l