Devart dotConnect for oracle,

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
Posts: 9
Joined: Tue 07 Mar 2017 13:40

Devart dotConnect for oracle,

Post by bharaniKumar » Mon 17 Apr 2017 13:35

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.

[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

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

Devart Team
Posts: 7964
Joined: Thu 14 Aug 2008 12:44

Re: Devart dotConnect for oracle,

Post by Shalex » Tue 18 Apr 2017 08:17

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.

Post Reply