Page 1 of 1

Devart dotConnect for oracle,

Posted: Mon 17 Apr 2017 13:35
by bharaniKumar
Using Devart 9.2.205
But opened another one calling the same package in different pages.
If calls first page works fine.. again its calls another page its not works well, mismatch mapping occurs.


[Function(Name=@"Package")]
[Devart.Data.Linq.Mapping.ResultType(typeof(Class1Context), 7)]
[Devart.Data.Linq.Mapping.ResultType(typeof(Class2Context), 8)]
[Devart.Data.Linq.Mapping.ResultType(typeof(Class3Context), 9)]
public Devart.Data.Linq.IMultipleResults SampleTest([Parameter(Name="IDFILTER_IN", DbType="NUMBER")] System.Nullable<decimal> IDFILTER_IN, [Parameter(Name="FROMDATE_IN", DbType="VARCHAR2(4000 CHAR)")] string FROMDATE_IN, [Parameter(Name="TODATE_IN", DbType="VARCHAR2(4000 CHAR)")] string TODATE_IN, [Parameter(Name="DATERANGE_IN", DbType="VARCHAR2(4000 CHAR)")] string DATERANGE_IN, [Parameter(Name="OUT_ERRORCODE", DbType="VARCHAR2(4000 CHAR)")] out string OUT_ERRORCODE, [Parameter(Name="OUT_ERRORMESSAGE", DbType="VARCHAR2(4000 CHAR)")] out string OUT_ERRORMESSAGE)
{
IExecuteResult _SampleTestResult = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), IDFILTER_IN, FROMDATE_IN, TODATE_IN, DATERANGE_IN, (string)null, (string)null);
OUT_ERRORCODE = ((string)(_SampleTestResult.GetParameterValue(5)));
OUT_ERRORMESSAGE = ((string)(_SampleTestResult.GetParameterValue(6)));
return ((Devart.Data.Linq.IMultipleResults)(_SampleTestResult.ReturnValue));
}

all the classes have plenty of properties
Class1Context
Class2Context
Class3Context

List<Class1Context> resultset = result.GetResult<Class1Context>().ToList(); // mismatch mapping occur
List<Class1Context> resultCustomFilters = result.GetResult<Class2Context>().ToList();
List<Class1Context> resultSummary = result.GetResult<Class3Context>().ToList();

Re: Devart dotConnect for oracle,

Posted: Tue 18 Apr 2017 08:17
by Shalex
1. Please send us a small test project with the corresponding DDL/DML script for reproducing the issue in our environment.

2. Specify the full stack trace of the error with all inner exceptions.