Entity Framework Core - Knowledge Base (KB)

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

Entity Framework Core - Take(1), Single(), First()... Not Working with Oracle Provider (ORA-00933: SQL command not properly ended)

I'm using ef core(2.2.4) with oracle database...oracleProvider: Oracle.EntityFrameworkCore(2.18.0-beta3)...this code:...IQueryable<KeyInfo> queryable = context .KeyInfos .Where(x => x.MobileNumber == "989191111111") ...

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