I'm writing a C# code with dotConnect for Oracle.
There is a stored procedure with cursor.
At first, I created datacontext following this link.
http://www.devart.com/dotconnect/oracle ... _linq.html
Then, I added only one stored procedure.
DataContext Class was generated.
mmm.. This is my code.
Code: Select all
EDatacontext dc;
dc = new EDatacontext();
dc.Connection.Open();
OracleParameter p;
p = new OracleParameter("v_cursor", OracleDbType.RefCursor);
OracleDataAdapter oda = new OracleDataAdapter();
DataSet ds = new DataSet();
System.Data.Linq.ISingleResult sr = dc.DsGetUserinfo(p.Value, "demo01", "companyid");
oda.Fill(ds, (OracleRefCursor)p.Value);
Can anybody show a example code?
I want call stored procedure with datacontext. not using OracleCommand.
Thank you.