Entity Framework 6 - Knowledge Base (KB)

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 ...

"the provider did not return a providermanifesttoken" using Oracle MangedDataAccess with EF 6 Code First

I have an web application that was using oracle 11g, EF 5 code first and system.data.oracleclient....So now, It was upgraded to EF 6 and Oracle Managed Data Access. ...The ODP .Net is installed. This error happens only when I am using TNS in connection st...

Calling Oracle stored procedure using Entity Framework with output parameter?

I have a simple Oracle stored procedure that gets three parameters passed in, and has one output parameter:...CREATE OR REPLACE PROCEDURE RA.RA_REGISTERASSET ( INPROJECTNAME IN VARCHAR2 ,INCOUNTRYCODE IN VARCHAR2 ,INLOCATION IN VARCHAR2 ,O...

How to connect to Oracle DB using TNS alias with Entity Framework 6?

In my setup I have a .NET application built with Visual Studio 2015 trying to access data on an Oracle 12c database using Entity Framework 6....Here's what I did to acchieve that:...I followed ...a tutorial at oracle.com... on how to use nuget to install ...

Issue with Oracle stored procedure returning SYS_REFCURSOR and Entity Framework Model

I have an Oracle database (11.2 server-side with 12.1 client bits) with loads of stored procedures that return a SYS_REFCURSOR object type....I tried to import this set of procedures through the Add new ADO.NET Entity Data Model wizard within Visual Studi...

Oracle ManagedDataAccess GetDecimal specified cast is not valid

I am using EF6 Oracle.ManagedDataAccess v18.3.0, database first concept (edmx). The problem is that Oracle table stores Number that has higher precision (38 digits), that the default Decimal C# data type to which the oracle Number is mapped. Decimal has p...