The Oracle Managed DataAccess Provider is the .Net Native version of ODP.Net. It doesn't need a prior Oracle Client installation or have any dependency on the OCI library. Applications that reference it may therefore be built 'AnyCPU'.
Questions tagged [odp.net-managed]
110 questions
1
vote
2 answers
C# - Oracle Stored Procedure return RefCursor without rows
My Stored Procedure call does return 7 rows, but not when I call it through Oracle Managed data access.
Code :
string _connectionString =
String.Format("Data Source={0};User Id={1};Password={2};",
tbDataSource.Text,…
AnAnonymous
- 11
- 1
- 4
1
vote
1 answer
EF 5 with oracle edmx StoreGeneratedPattern="Identity" issue
We are using EF5 with Oracle[Oracle.manageddataaccess.client].Whenever I create/refresh edmx.I loose the property StoreGeneratedPattern="Identity". I had to set this manually for each and every Entity.
Is there any way to automate it or any other…
Sat
- 133
- 2
- 12
0
votes
0 answers
ODP.net 4.0, Why extra call is made and how to remove another call to fetch row count
using (OracleConnection oracleConnection = new OracleConnection(dbContext.Database.Connection.ConnectionString))
{
oracleConnection.Open();
OracleCommand oracleCommand = oracleConnection.CreateCommand();
oracleCommand.CommandText =…
bhagwan das Gupta
- 179
- 1
- 1
- 3
0
votes
0 answers
OracleSession handle send to db event
I have asp.net application that use ODP.net
I want to do some adjustment before send every query to db (define OracleSession.clientId for example or perform some logging). I want to have one place for this, but I didn't find any events like…
0
votes
0 answers
ODP.Net Clear schema information
Our web application(dotnet framework 4.7) is running in IIS. Am using ODP.net OracleManagedDataProvider for oracle database.
We have dynamic report page which shows data from views. The problem is whenever we alter the view, we are experiencing the…
Bala
- 149
- 1
- 7
0
votes
0 answers
Why calling the Oracle from ODP.Net decrease the throughput of my asp.net webapi core by 1525%?
I am doing some research in order to increase the performance of my asp.net webapi core (5.0) when working with an oracle (12g) database.
I have made two endpoints for tests purpose in this API :
Raw helloworld api endpoint :
this endpoind will…
Dypso
- 563
- 1
- 5
- 15
0
votes
0 answers
Entity Framework runtime error when parsing edm mappings in web.config
I am getting a runtime System.TypeInitializationException that points to the custom edmMappings that have been inserted into the web.config: