Stack Overflow
Stack Overflow

Questions tagged [oracle.manageddataaccess]

53 questions
32
votes
2 answers

FileNotFoundException: Could not load file or assembly 'System.Configuration.ConfigurationManager,

I am trying to connect to oracle database from .net core 3.1 using ado.net here's my code private OracleConnection GetOracleConnection() { string conString = "Data Source=Q550.adr.XXXX.com;Persist Security,Info=True;User…
Sunil Tripathi
  • 526
  • 1
  • 5
  • 12
7
votes
2 answers

options.UseOracle() not available in EF Core

Using EF Core with Oracle.ManagedDataAccess.Core(2.18.3) Not able to invoke the "options.UseOracle" method when trying to add DB context. Compiler throws the error: 'DbContextOptionsBuilder' does not contain a definition for 'UseOracle' and no…
frostwolfer
  • 93
  • 1
  • 1
  • 4
5
votes
1 answer

DataReader returning incorrect .net datatype for database table float column

I have 1 Table in Oracle SQL Developer which containts 1 column as Float.Data reader have should return Decimal for oracle float datatype as per the table given here :…
I Love Stackoverflow
  • 6,738
  • 20
  • 97
  • 216
4
votes
1 answer

Oracle Error: Pooled connection request timed out

Im using Oracle12c with the application written in C# and using Oracle.ManagedDataAccess.dll to handle the DB Connection. A product we have has started to occasionally throw this exception after running fine for…
CathalMF
  • 9,705
  • 6
  • 70
  • 106
3
votes
0 answers

Oracle.ManagedDataAccess 21.4.0 will not install

I have a web application in Visual Studio (VB.net) and I'm trying to install Oracle.ManagedDataAccess 21.4.0 via the Nuget Package Manager. The .NET Target Framework is 4.6.1 and I have System.Text.Json 5.0.2 installed via NuGet. For some reason…
Jason Shoulders
  • 659
  • 1
  • 12
  • 24
3
votes
0 answers

Oracle Managed Data Access - ORA-01017

I have been through a variety of different SO posts and questions trying to find an answer here, but so far I've had no luck, so I'm going to ask to see if anyone has anything newer to help. My situation: I am working on a thick-client application…
s0n1c
  • 78
  • 9
3
votes
0 answers

(ORA-00603: ORACLE server session terminated by fatal) Randomly generated while executing DROP table query

I'm using the latest version of the provider Oracle.ManagedDataAccess targetting .Net Core. When I execute the following SQL statement under Admin user: DROP TABLE "MYUSER"."MYTABLE"; It throws this…
billybob
  • 2,859
  • 6
  • 35
  • 55
3
votes
2 answers

Oracle Managed DataAccess connection object is keeping the connection open

I'm using Oracle.ManagedDataAccess Nuget package version 18.3.0. I tried many things. I tried to dispose everything I can think of, even oracle parameters objects. And wrapped everything inside a using block but to no avail. The only thing that…
Rickless
  • 1,377
  • 3
  • 17
  • 36
2
votes
0 answers

High Memory Usage with Oracle.ManagedDataAccess.Core

I need a little help here. I'm facing a problem now with Oracle.ManagedDataAccess.Core. I have a class written for centralize oracle queries (Clases.Oracle()), which works perfectly, but with one query the memory usage rises up to 1GB, which is not…
Angelo Bernardi
  • 111
  • 7
2
votes
1 answer

Share ManagedDataAccess.Client.OracleConnection connection/session/transaction with DataAccess.Client.OracleConnection

In my application, I am using a Repository class that has a public Oracle.ManagedDataAccess.Client.OracleConnection DbConn property. In another class where I use this repository, there's a particular use case where I need to use OracleBulkCopy's in…
Luis Costa
  • 330
  • 1
  • 14
2
votes
1 answer

Oracle Client and ODP.NET version compatibility

We have upgraded Oracle to 19C and also upgraded the Oracle.ManagedDataAccess package to 19.6. However, when we try to open our application on Oracle database 12 then it is showing error, as some machines still has Oracle 12 (Old) database. can…
Nitin Jain
  • 49
  • 1
  • 7
2
votes
2 answers

Oracle.ManagedDataAccess dbcontext scaffold expected assembly attribute named DesignTimeProviderServicesAttribute error

I'm trying to use dotnet core entity framework dbcontext scaffolding to connect to my oracle database for my dot net core project like this below: dotnet ef dbcontext scaffold "User Id=;Password=;Data…
gpproton
  • 21
  • 2
  • 7
2
votes
1 answer

Oracle.ManagedDataAccess to AWS RDS DB - TCPS: Invalid SSL Wallet (Magic)

I am trying to connect to a Amazon RDS instance via the Oracle.ManagedDataAccess Nuget package using a SSL certificate. I can connect successfully via SQL*Plus using a wallet generated using orapki. Wallet generated by following the AWS…
DaveHanc
  • 136
  • 2
  • 6
1
vote
0 answers

Could not use file or assembly 'Oracle.ManagedDataAccess'

In my application, earlier we were using entityframework of unmanaged dll of 11g Oracle.DataAccess. Now as migration work, we have decided to use managed dll of oracle (oracle.manageddataaccess) and entityframework. I added reference of managed…
Arvind
  • 13
  • 5
1
vote
2 answers

(.net) OracleDataReader falsely returning empty array from json_array() (works in sql developer)

I am trying to fetch a collection of custom objects from an oracle db (v21) from a .net client. Since i cant do any type mapping i want to fetch it as json. Here is the query: select json_array("UDTARR") from sys.typetest This is the result i see…
Paul
  • 5,524
  • 1
  • 22
  • 39
1
2 3 4