Converting Oracle Data Access to EF6
Posted: Fri 09 Oct 2015 15:33
We have an old WCF web service that I'm attempting to convert to WebApi. It uses the old Oracle Data Access libraries and I'm attempting to convert it to EF6. I can't find much on accessing Oracle ref cursors with EF6.
I've got this function:
And need to convert it to EF6 which would be something like this:
The function being called returns a REF CURSOR.
We are using the DevArt Oracle libraries for EF6.
Any help here?
I've got this function:
Code: Select all
public List<Course> QrySuggestedCourses(int PID)
{
NaData v_NaDataAccess = new NaData();
List<OracleParameter> param = new List<OracleParameter>
{ new OracleParameter {ParameterName = "PID", Value = PID,
OracleDbType = OracleDbType.Varchar2}};
DataSet v_DataSet = v_NaDataAccess.RefCursorFunction("W_SUGGESTED_COURSES_BY_PART", param);
IEnumerable<DataRow> Enum = v_DataSet.Tables[0].Rows.Cast<DataRow>();
List<Course> suggestedCourses = Enum.Select((x) => new Course(x)).ToList();
return suggestedCourses;
}
Code: Select all
public List<Course> GetSuggestedCourses(int PID)
{
var res = _Db.Database.SqlQuery<List<Course>>("begin select W_SUGGESTED_COURSES_BY_PART(" + PID.ToString() + ") from dual end;");
return res.FirstOrDefault();
}
We are using the DevArt Oracle libraries for EF6.
Any help here?