EF CODEFIRST WITH ORACLE 預存程序

標籤：方案   class   data   需要   out   return   command   codefirst   val   

EF  CODEFIRST WITH ORACLE

解決預存程序一直沒找到解決方案

所以最後也沒辦法還是用了最基本的解決方案

採用Oracle.ManagedDataAccess提供的ADO基礎訪問類，不需要再次額外引用第三方類庫了。

using Oracle.ManagedDataAccess.Client;

public object[] ExecuteProc(string procName, params DbParameter[] parms)        {            MyDbContext dbContext = this.GetDbContext(AccessMode.Write);            using (var conn = new OracleConnection(dbContext.Database.Connection.ConnectionString))            {                List<DbParameter> outParms = parms.Where(p => p.Direction == System.Data.ParameterDirection.Output || p.Direction == System.Data.ParameterDirection.ReturnValue).ToList();                OracleCommand command = new OracleCommand(procName);                command.Connection = conn;                command.CommandType = CommandType.StoredProcedure;                command.Parameters.AddRange(parms);                conn.Open();                command.ExecuteNonQuery();                command.Parameters.Clear();                command.Dispose();                conn.Close();                object[] values = outParms.Select(r => r.Value).ToArray();                return values;            }        }

調用

 BaseRepository resp = new BaseRepository();            var p3 = resp.GetParameterOut("COUNT_ROW", System.Data.DbType.Int32, 4);            object[] o = resp.ExecuteProc("PROC1", p3);            var ss = p3.Value;

 

EF CODEFIRST WITH ORACLE 預存程序