Entity Framework 6 - Knowledge Base (KB)
18 results in tag: odp.net
Is Microsoft Entity Framework compatible with Oracle?
Is it possible to use Microsoft Entity Framework with Oracle database?
asked by Xerx
Cannot see Oracle Data Provider for .NET in Visual Studio 2012 RC
I am porting a web application to Entity Framework 4.5. My main goal is to support both MSSQL and Oracle databases and be able to tell the ORM which data source to target programmatically (in the Global.asax). The SQL and Oracle schemas are obviously fun...
asked by Piddu
Deploying and Configuring ODP.NET to work without installation with Entity Framework
How do you deploy and configure ODP.NET to work without installation with Entity Framework?...A. How to deploy and configure Oracle.DataAccess.Client?...B. How to deploy and configure Oracle.ManagedDataAccess.Client?...C. What do you need to do in order t...
asked by Danny Varod
Cant Map SYS_REFCURSOR in Entity Framework
I am trying to access a Stored procedure on Oracle 11g through Entity Framework. I can access stored procedures which returns scalars and those returns correct value. But when using ...SYS_REFCURSOR for returning a result set, the OUT parameter is not det...
asked by Aneesh Mohan
Entity Framework 6 (5) connection to Oracle
I am attempting to write a Data Access library for our suite of applications that use Oracle in .net. We currently use NHibernate and are thinking of migrating away as it appears to not be supported all that well....I am working with Visual Studio 2013 a...
asked by SoftwareSavant
Oracle.ManagedDataAccess.EntityFramework - ORA-01918: user 'dbo' does not exist
I am trying to implemente code First Migrations with Oracle.ManagedDataAccess 6.121.1.0 provider, but with no success at all....As I am receiving a ORA-code, I am assuming that the connection are been opened successfully. But the Migrations are failing be...
asked by Thiago Lunardi
ODP.net 12c release 3: How to config Number(1,0) to be mapped to bool in some cases and int16 in some cases
Problem...I have a table like this:...MyModel MyShortField Number(1,0) MyBoolField Number(1,0) ...I want ...MyBoolField... to store only 0 and 1 but I want ...MyShortField... to store 1-9. So, in the edmx, I set ...MyBoolField... to ...Boolean... and ...M...
asked by Moozz
EF + ODP.NET + CLOB = Value Cannot be Null - Parameter name: byteArray?
Our project recently updated to the newer Oracle.ManagedDataAccess DLL's (v 4.121.2.0) and this error has been cropping up intermittently. We've fixed it a few times without really knowing what we did to fix it....I'm fairly certain it's caused by CLOB f...
asked by Tom Halladay
Oracle ODP.Net With Entity Framework 6 - TypeInitializationException - CreateConnection()
I have created to apps, first with ODP.Net and without Entity - works great.... static void Main(string[] args) { OracleConnection con = new OracleConnection(); //using connection string attributes to connect to Oracle Database...
asked by BLuM
How to use Oracle Entity Framework with no config file
Is it possible to create a code-first Entity Framework model that connects to an existing database using ODP.Net without having any settings in the app.config file?...I have tried many different things....Currently I am setting DbConfiguration:... seal...
asked by Stephen Drew
Managed Oracle Client with Oracle Advanced Security Options
On October 14th, Oracle release the latest version of their Oracle Managed Client which was described to support Network Data Encryption....http://www.oracle.com/technetwork/topics/dotnet/tech-info/odac12cr4ds-2704217.pdf...https://www.nuget.org/packages/...
asked by Pierluc SS
ODP.Net Managed Driver - ORA-12704: character set mismatch in generated code
I am currently using the Oracle Managed Driver (v12.1.2400) as my Entity Framework driver, and am currently seeing a ...ORA-12704: character set mismatch... error during execution....The LINQ->SQL code I am using is as follows:...from c in CUSTOMER.AsNoTr...
asked by Nick
How to Add/Activate "Oracle.ManagedDataAccess.Client" in the EF 6 provider config file?
I am learning to make ASP.Net MVC Web application using VS2013 following ...these video series.... When I got the following error:...No Entity Framework provider found for the ADO.NET provider with invariant name 'Oracle.ManagedDataAccess.Client'. Make ...
asked by Ian
ORA 00936 error calling a PL/SQL stored procedure from a c# web service
I need some help calling a stored procedure designed to add sequence number to each row added by an Api POST method....At the moment I get this error message: "ExceptionMessage": "ORA-20001: Get Next Sequence Failed.. -936 ORA-00936: missing expression\nO...
asked by Julian H
Cannot drag tables from model browser into edmx design surface
I am using ODP.NET. I have added an ADO.NET model to the project. That way, an edmx file was created. I chose "create from database" and after I selected the tables and click finish, edmx design surface appeared empty, however, the model browser window sh...
asked by jstuardo
ODP.NET 12c problems with Oracle 11g
I'm developing an Entity Framework application using Oracle 12c and ODP.NET Managed Drivers 12c with Entity Framework 6....All the application is working fine in Oracle 12c version, but we have a customer wich uses Oracle 11g version. In this customer I a...
asked by Lucas Neves
ORA-00955: name is already used by an existing object; When using Oracle.ManagedDataAccess and EntityFramework
I am having a hard time working with EF and Oracle. Earlier, I have developed an app that use EF and Oracle and have ran well. I installed the ODAC in local computer (GAC) that contains Oracle.ManagedDataAccess and Oracle.ManagedDataAccess.EntityFramework...
asked by grayfieldmm
Update model from database crashed
I use ODP.NET tool and Oracle.ManagerDataAccess library to connect from C# app to Oracle DB. I want to update .edmx model. I use Update Wizard for that. First, I choose data connection and when I click next, instead "Choose Your Database Objects and Setti...
asked by Dmytro Tysko
Page 1 of 1
