Using Devart 9.2.205 not able get result using getresult method it throws error but the same thing using in previously
-
- Posts: 9
- Joined: Tue 07 Mar 2017 13:40
Using Devart 9.2.205 not able get result using getresult method it throws error but the same thing using in previously
System.FormatException was caught
HResult=-2146233033
Message=Input string was not in a correct format.
Source=mscorlib
StackTrace:
at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
at System.Number.ParseInt64(String value, NumberStyles options, NumberFormatInfo numfmt)
at System.Int64.Parse(String s, IFormatProvider provider)
at Devart.Data.Oracle.z.aa(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Common.n.aq(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Common.n.b(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Data.Oracle.z.b(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Data.Oracle.d7.b(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Data.Oracle.OracleDataReader.GetInt32(Int32 i)
at MaterializeACTIVE_REPORTS_CONTEXT(MaterializerScope )
at Devart.Data.Linq.Engine.ObjectReader`1.a()
at Devart.Data.Linq.Engine.ObjectReader`1.a(T& A_0)
at Devart.Data.Linq.Engine.ObjectReader`1.c()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
at G2_BackOffice.Models.ReportsModel.GetExportData(Int64 idFilter, Int64 idLanguage, Decimal idShop) in D:\devart Latest 9.2 version app\G2_BackOffice\G2_BackOffice\G2_BackOffice\Models\ActiveReport\ReportsModel.cs:line 320
InnerException:
HResult=-2146233033
Message=Input string was not in a correct format.
Source=mscorlib
StackTrace:
at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
at System.Number.ParseInt64(String value, NumberStyles options, NumberFormatInfo numfmt)
at System.Int64.Parse(String s, IFormatProvider provider)
at Devart.Data.Oracle.z.aa(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Common.n.aq(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Common.n.b(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Data.Oracle.z.b(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Data.Oracle.d7.b(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Data.Oracle.OracleDataReader.GetInt32(Int32 i)
at MaterializeACTIVE_REPORTS_CONTEXT(MaterializerScope )
at Devart.Data.Linq.Engine.ObjectReader`1.a()
at Devart.Data.Linq.Engine.ObjectReader`1.a(T& A_0)
at Devart.Data.Linq.Engine.ObjectReader`1.c()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
at G2_BackOffice.Models.ReportsModel.GetExportData(Int64 idFilter, Int64 idLanguage, Decimal idShop) in D:\devart Latest 9.2 version app\G2_BackOffice\G2_BackOffice\G2_BackOffice\Models\ActiveReport\ReportsModel.cs:line 320
InnerException:
Re: Using Devart 9.2.205 not able get result using getresult method it throws error but the same thing using in previously
Could you please provide us the full name of the product and its version?
-
- Posts: 9
- Joined: Tue 07 Mar 2017 13:40
Re: Using Devart 9.2.205 not able get result using getresult method it throws error but the same thing using in previously
ADO.NET providers for database dotConnect for Oracle
Devart.Data 5.0.1629.0
Devart.Data.Linq 4.5.1174.0
Devart.Data.Oracle 9.2.172.0 and 9.2.205.0
Devart.Data.Oracle.Entity.EF6 9.2.172.0 and 9.2.205.0
(previously we are using devart 6.0 version. In application have using to mapping with help of system.data dll's
but now when we are upgrade the devart 9.2 version ve using own dll to mapping the tables or rows of the data. Now only we face issue in this type we tried so many ways but we face the same issue)
Scenario is We have calling a package twice in a page first time its never get error works fine later same page click a download link calling the same package using same select with extra data columns it will get error.
We tried another way to create duplicate iqml file call first in one of the iqml(firstdatacontest.iqml) file and another call in duplicate iqml (seconddatacontext.iqml) file its works fine but we are not able to do in our client application
So please can you address me the what's the problem?
Devart.Data 5.0.1629.0
Devart.Data.Linq 4.5.1174.0
Devart.Data.Oracle 9.2.172.0 and 9.2.205.0
Devart.Data.Oracle.Entity.EF6 9.2.172.0 and 9.2.205.0
(previously we are using devart 6.0 version. In application have using to mapping with help of system.data dll's
but now when we are upgrade the devart 9.2 version ve using own dll to mapping the tables or rows of the data. Now only we face issue in this type we tried so many ways but we face the same issue)
Scenario is We have calling a package twice in a page first time its never get error works fine later same page click a download link calling the same package using same select with extra data columns it will get error.
We tried another way to create duplicate iqml file call first in one of the iqml(firstdatacontest.iqml) file and another call in duplicate iqml (seconddatacontext.iqml) file its works fine but we are not able to do in our client application
So please can you address me the what's the problem?
Last edited by bharaniKumar on Wed 08 Mar 2017 06:13, edited 1 time in total.
-
- Posts: 9
- Joined: Tue 07 Mar 2017 13:40
Re: Using Devart 9.2.205 not able get result using getresult method it throws error but the same thing using in previously
ADO.NET providers for database dotConnect for Oraclealexa wrote:Could you please provide us the full name of the product and its version?
Devart.Data 5.0.1629.0
Devart.Data.Linq 4.5.1174.0
Devart.Data.Oracle 9.2.172.0 and 9.2.205.0
Devart.Data.Oracle.Entity.EF6 9.2.172.0 and 9.2.205.0
(previously we are using devart 6.0 version. In application have using to mapping with help of system.data dll's
but now when we are upgrade the devart 9.2 version ve using own dll to mapping the tables or rows of the data. Now only we face issue in this type we tried so many ways but we face the same issue)
Scenario is We have calling a package twice in a page first time its never get error works fine later same page click a download link calling the same package using same select with extra data columns it will get error.
We tried another way to create duplicate iqml file call first in one of the iqml(firstdatacontest.iqml) file and another call in duplicate iqml (seconddatacontext.iqml) file its works fine but we are not able to do in our client application
So please can you address me the what's the problem?
-
- Posts: 9
- Joined: Tue 07 Mar 2017 13:40
Re: Using Devart 9.2.205 not able get result using getresult method it throws error but the same thing using in previously
class Program
{
static void Main(string[] args)
{
try
{
string sErrorCode = string.Empty;
string sMessage = string.Empty;
List<ACTIVE_REPORTS> resultset = new List<ACTIVE_REPORTS>();
List<CUSTOMFILTERS> resultCustomFilters = new List<CUSTOMFILTERS>();
Devart.Data.Linq.IMultipleResults result = null;
Devart.Data.Linq.IMultipleResults resultsets = null;
DataSet dataSetExportData = new DataSet("ExportData");
COMPANYSCMDataContext db = null;
try
{
db = new COMPANYSCMDataContext(ConfigurationManager.ConnectionStrings["COMPANYSCMDataContextConnectionString"].ToString());
result = db.GETEMPLOYEEDETAILS(Convert.ToDecimal(2), null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null,
null, null, Convert.ToDecimal(2105), Convert.ToDecimal(2), string.Empty, string.Empty, "SEARCH_REPORT", 0, 0, null, null, null, null, null, out sErrorCode, out sMessage);
if (!string.IsNullOrWhiteSpace(sErrorCode))
{
}
else
{
resultset = result.GetResult<ACTIVE_REPORTS>().ToList();
resultCustomFilters = result.GetResult<CUSTOMFILTERS>().ToList();
List<SUMMARY_DETAILS> resultSummary = result.GetResult<SUMMARY_DETAILS>().ToList();
}
//Converting list to data table
db = new COMPANYSCMDataContext(ConfigurationManager.ConnectionStrings["COMPANYSCMDataContextConnectionString"].ToString());
resultsets = db.GETEMPLOYEEDETAILS(Convert.ToDecimal(2), null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null,
null, null, Convert.ToDecimal(2105), Convert.ToDecimal(2), string.Empty, string.Empty, "EXPORT", 0, 0, null, null, null, null, null, out sErrorCode, out sMessage);
if (!string.IsNullOrWhiteSpace(sErrorCode))
{
}
else
{
resultset = result.GetResult<ACTIVE_REPORTS>().ToList();
resultCustomFilters = result.GetResult<CUSTOMFILTERS>().ToList();
List<SUMMARY_DETAILS> resultSummary = result.GetResult<SUMMARY_DETAILS>().ToList();
}
}
catch (Exception)
{
throw;
}
}
catch (Exception ex)
{
throw;
}
Console.ReadLine();
}
}
---------------------------------------------------------
<?xml version="1.0" encoding="utf-8"?>
<Database Name="COMPANY_SCM" EntityNamespace="COMPANYSCMContext" ContextNamespace="COMPANYSCMContext" Class="COMPANYSCMDataContext" xmlns:ed="http://devart.com/schemas/EntityDeveloper/1.0" ed:Guid="3ba7fe19-35ce-4d9b-952f-c4d91572f1a6" Provider="Devart.Data.Oracle.Linq.Provider.OracleDataProvider, Devart.Data.Oracle.Linq" Extended="true" xmlns="http://schemas.devart.com/linqconnect/mapping">
<Connection Mode="ConnectionString" ConnectionString="User Id=COMPANY_SCM;Server=company;Persist Security Info=False" Provider="Devart.Data.Oracle" />
<Type Name="ACTIVE_REPORTS" ed:Guid="ece84fd8-c2a5-436e-a039-b262991639a0">
<Column Member="ID" Type="System.Int64" CanBeNull="false" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="34515003-fcc2-484a-a988-9b3f7d1b97e9" />
<Column Member="PayMethod" Type="System.Int32" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="58583ad4-1532-401c-b224-59bfc58d1028" />
<Column Member="AutDateTime" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="176b3923-1edd-4272-9616-d70868af7593" />
<Column Member="State" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="a25918bf-284d-4658-a63a-68ef016237df" />
<Column Member="ShopID" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="bad936a2-25b1-4b02-9b4e-de51b187be51" />
<Column Member="BankID" Type="System.Int32" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="a9d7c6e4-5d20-4d98-b557-cf8e4d68f3c9" />
<Column Member="Approved" Type="System.Int32" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="276b3643-5c6d-4d3c-88c9-f4ff01295b66" />
<Column Member="AuthorizationCode" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="7344cafe-ccae-4b64-8a95-929542d988f2" />
<Column Member="CurrencyCode" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="6e932b24-91b4-4945-a7b0-3df36eca6a1d" />
<Column Member="Country" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="f3c27585-4051-4ab7-8561-0fb371e93d8b" />
<Column Member="AutAmount" Type="System.Decimal" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="fba0db05-e81e-4d43-84fe-c8a1e44b258b" />
<Column Member="EnvironmentCode" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="ecdc52bb-01de-4ea5-9999-8ec495a00380" />
<Column Member="PayType" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="9c295231-60f7-4d72-8629-14351afdd852" />
<Column Member="PMDescription" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="eea556db-ce35-457f-94ad-48004196dadb" />
<Column Member="FDDescription" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="be0a9433-8814-4271-b7ec-ccc5337242de" />
<Column Member="CurrentAmount" Type="System.Decimal" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="5d4fe186-d96e-4a3b-8e11-ce720076e783" />
<Column Member="Balance" Type="System.Decimal" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="74c42655-56cd-47c7-b25f-ff82565c61cb" />
<Column Member="Alert" Type="System.Int32" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="496660b7-5550-4ed9-9401-dc87a079d43d" />
<Column Member="AlertDescription" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="178c2cb8-ce7c-455d-90c1-3c90efdfcd70" />
<Column Member="VBV" Type="System.Int32" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="383c6a2e-7de3-4eb7-bcd8-6b380fb9278a" />
<Column Member="HolderName" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="f46b50ec-c945-4468-97fc-5d652b2cf223" />
<Column Member="HolderEmail" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="0faf02fb-3039-4fc9-82e4-830254c1455b" />
<Column Member="ErrorCode" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="263e90cd-4072-4025-b1cd-3650cce143fc" />
<Column Member="PercentageFee" Type="System.Decimal" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="false" ed:Guid="d780135f-db9b-40f6-9ad2-27a56f852880" />
<Column Member="MovementAmount" Type="System.Decimal" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="false" ed:Guid="78a49e4e-2333-4a54-85bf-a0403e6072c9" />
<Column Member="MovementDateTime" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="33921a29-db42-40a3-bf06-fae457b678a4" />
<Column Member="MovementEnvironment" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="f9166417-c824-4f1a-8461-b89a2b3e32ac" />
<Column Member="CancelledAmount" Type="System.Decimal" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="false" ed:Guid="c1fd2111-6e67-4c57-9463-0cf3bf79fb72" />
<Column Member="CancelledDateTime" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="724f764b-6e88-47d2-b469-e16c2ecfb706" />
<Column Member="CancelledEnv" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="b43699ca-cfc0-45e5-b483-993a4f5e67d0" />
<Column Member="PayTypeDescr" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="12d54a17-0125-4026-99b3-b0fb10e87127" />
<Column Member="DataAuhonicatet" Type="System.DateTime" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="9615f761-b0e1-4c19-b6cf-bb0f85d9bde5" />
<Column Member="VerifyResult" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="3096e000-66ed-4e26-9ce6-2ee885431f0b" />
<Column Member="Event" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="5452213e-5025-499b-b973-31c30c9f539c" />
<Column Member="DateTime" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="false" ed:Guid="50451560-3150-4c58-bb67-8b90d60742dd" />
<Column Member="Amount" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="false" ed:Guid="472aa8b1-fe30-4b7c-9d62-45090f41fb5a" />
<Column Member="FraudResponse" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="9dde1438-477d-48ad-b6a5-9ae0cb265ea9" />
<Column Member="Percentageamount" Type="System.Decimal" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="false" ed:Guid="ff2b43e1-43d0-4a3b-8d71-53d8f6435069" />
<Column Member="IMAGE" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="dfe1b410-51e6-471f-a1c0-d28492350d60" />
<Column Member="MethodID" Type="System.Int32" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="false" ed:Guid="31ac8937-d4e5-4d97-b49b-fd71ab3b56bf" />
<Column Member="EnableAlert" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="9d1cc127-63f9-4172-9830-76c0b3ac7532" />
<Column Member="ChargeBack" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="5ba55e40-a902-47b5-a362-b968ebf71521" />
</Type>
<Type Name="CUSTOMFILTERS" ed:Guid="1df54f77-f09b-4abf-b20d-28bae1cfc0d7">
<Column Member="IDFILTER" Type="System.Int64" CanBeNull="false" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="99559747-2843-451e-bf27-a561b0b2e62f" />
<Column Member="IDFIELD" Type="System.Int64" CanBeNull="false" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="d8800dc9-f6b4-40a7-bf83-ef8fc0b7c025" />
<Column Member="FIELDVALUE" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="57fb3b63-9131-4521-9367-b13c7a38305c" />
<Column Member="IDTRANSACTION" Type="System.Int64" CanBeNull="false" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="375b744f-f6a0-4b54-80e5-4ca5bfa0ee6b" />
<Column Member="FIELDNAME" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="e8083332-5906-450f-a514-8bffc1a734ad" />
<Column Member="FIELDLABEL" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="8c3a1def-0182-455c-a490-cd4af6361dee" />
</Type>
<Type Name="SUMMARY_DETAILS" ed:Guid="c943324e-bbe7-4766-8ec5-d37618f62261">
<Column Member="TotalAutAmount" Type="System.Decimal" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="afbd2d1f-4de5-4059-a9d2-3b75b9bd8d4a" />
<Column Member="TotalBalance" Type="System.Decimal" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="9443e05e-842a-40d7-b4a3-065ab2e0cc59" />
<Column Member="TotalRecords" Type="System.Decimal" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="b7a7b571-bf05-40e7-b586-2a2d46871ea3" />
</Type>
<Function Name="ACTIVE_DATA_COMPANY_EMPLOYEE" Method="PRGETCOMPANYDETAILS" ed:Guid="48da574c-34d0-433a-a0b1-10df0500903b">
<Parameter Name="IDFILTER_IN" Type="System.Decimal" DbType="NUMBER" FixedLength="true" MaxLength="22" />
<Parameter Name="FROMDATE_IN" Type="System.String" DbType="VARCHAR2(4000 CHAR)" />
<Parameter Name="TODATE_IN" Type="System.String" DbType="VARCHAR2(4000 CHAR)" />
<Parameter Name="DATERANGE_IN" Type="System.String" DbType="VARCHAR2(4000 CHAR)" />
<Parameter Name="AUT_AMOUNT_FROM_IN" Type="System.Decimal" DbType="NUMBER" FixedLength="true" MaxLength="22" />
<Parameter Name="MOV_AMOUNT_FROM_IN" Type="System.Decimal" DbType="NUMBER" FixedLength="true" MaxLength="22" />
<Parameter Name="AUT_AMOUNT_TO_IN" Type="System.Decimal" DbType="NUMBER" FixedLength="true" MaxLength="22" />
<Parameter Name="MOV_AMOUNT_TO_IN" Type="System.Decimal" DbType="NUMBER" FixedLength="true" MaxLength="22" />
<Parameter Name="TRANSACTIONTYPE_IN" Type="System.String" DbType="VARCHAR2(4000 CHAR)" />
<Parameter Name="UICCODE_IN" Type="System.String" DbType="VARCHAR2(4000 CHAR)" />
<Parameter Name="BANKTRXID_IN" Type="System.Decimal" DbType="NUMBER" FixedLength="true" MaxLength="22" />
<Parameter Name="APPROVEDTRANSACTION_IN" Type="System.Decimal" DbType="NUMBER" FixedLength="true" MaxLength="22" />
<Parameter Name="SHOPTRXID_IN" Type="System.String" DbType="VARCHAR2(4000 CHAR)" />
<Parameter Name="ERRORCODE_IN" Type="System.String" DbType="VARCHAR2(4000 CHAR)" />
<Parameter Name="AUTHORIZATIONCODE_IN" Type="System.String" DbType="VARCHAR2(4000 CHAR)" />
<Parameter Name="PAYMENTMETHOD_IN" Type="System.Decimal" DbType="NUMBER" FixedLength="true" MaxLength="22" />
<Parameter Name="ALERT_IN" Type="System.Decimal" DbType="NUMBER" FixedLength="true" MaxLength="22" />
<Parameter Name="TRANSACTIONSTATE_IN" Type="System.String" DbType="VARCHAR2(4000 CHAR)" />
<Parameter Name="THREEDLEVEL_IN" Type="System.String" DbType="VARCHAR2(4000 CHAR)" />
<Parameter Name="RED_FRAUDRESPONSE_IN" Type="System.String" DbType="VARCHAR2(4000 CHAR)" />
<Parameter Name="IDSHOP_IN" Type="System.Decimal" DbType="NUMBER" FixedLength="true" MaxLength="22" />
<Parameter Name="IDLANGUAGE_IN" Type="System.Decimal" DbType="NUMBER" FixedLength="true" MaxLength="22" />
<Parameter Name="CUSTOMFIELDSID_IN" Type="System.String" DbType="VARCHAR2(4000 CHAR)" />
<Parameter Name="CUSTOMFIELDSVALUE_IN" Type="System.String" DbType="VARCHAR2(4000 CHAR)" />
<Parameter Name="GETRESULTSFOR_IN" Type="System.String" DbType="VARCHAR2(4000 CHAR)" />
<Parameter Name="ROWNUMFROM_IN" Type="System.Decimal" DbType="NUMBER" FixedLength="true" MaxLength="22" />
<Parameter Name="ROWNUMTO_IN" Type="System.Decimal" DbType="NUMBER" FixedLength="true" MaxLength="22" />
<Parameter Name="CHARGEBACK_IN" Type="System.String" DbType="VARCHAR2(4000 CHAR)" />
<Parameter Name="FRAUD_IN" Type="System.String" DbType="VARCHAR2(4000 CHAR)" />
<Parameter Name="SORTBY_IN" Type="System.String" DbType="VARCHAR2(4000 CHAR)" />
<Parameter Name="SORTDIR_IN" Type="System.String" DbType="VARCHAR2(4000 CHAR)" />
<Parameter Name="ROWFILTERDATE_IN" Type="System.String" DbType="VARCHAR2(4000 CHAR)" />
<Parameter Name="OUT_ERRORCODE" Type="System.String" DbType="VARCHAR2(4000 CHAR)" Direction="Out" />
<Parameter Name="OUT_ERRORMESSAGE" Type="System.String" DbType="VARCHAR2(4000 CHAR)" Direction="Out" />
<ElementType Type="ACTIVE_REPORT" />
<ElementType Type="CUSTOMFILTERS />
<ElementType Type="SUMMARY_DETAILS" />
</Function>
</Database>
{
static void Main(string[] args)
{
try
{
string sErrorCode = string.Empty;
string sMessage = string.Empty;
List<ACTIVE_REPORTS> resultset = new List<ACTIVE_REPORTS>();
List<CUSTOMFILTERS> resultCustomFilters = new List<CUSTOMFILTERS>();
Devart.Data.Linq.IMultipleResults result = null;
Devart.Data.Linq.IMultipleResults resultsets = null;
DataSet dataSetExportData = new DataSet("ExportData");
COMPANYSCMDataContext db = null;
try
{
db = new COMPANYSCMDataContext(ConfigurationManager.ConnectionStrings["COMPANYSCMDataContextConnectionString"].ToString());
result = db.GETEMPLOYEEDETAILS(Convert.ToDecimal(2), null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null,
null, null, Convert.ToDecimal(2105), Convert.ToDecimal(2), string.Empty, string.Empty, "SEARCH_REPORT", 0, 0, null, null, null, null, null, out sErrorCode, out sMessage);
if (!string.IsNullOrWhiteSpace(sErrorCode))
{
}
else
{
resultset = result.GetResult<ACTIVE_REPORTS>().ToList();
resultCustomFilters = result.GetResult<CUSTOMFILTERS>().ToList();
List<SUMMARY_DETAILS> resultSummary = result.GetResult<SUMMARY_DETAILS>().ToList();
}
//Converting list to data table
db = new COMPANYSCMDataContext(ConfigurationManager.ConnectionStrings["COMPANYSCMDataContextConnectionString"].ToString());
resultsets = db.GETEMPLOYEEDETAILS(Convert.ToDecimal(2), null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null,
null, null, Convert.ToDecimal(2105), Convert.ToDecimal(2), string.Empty, string.Empty, "EXPORT", 0, 0, null, null, null, null, null, out sErrorCode, out sMessage);
if (!string.IsNullOrWhiteSpace(sErrorCode))
{
}
else
{
resultset = result.GetResult<ACTIVE_REPORTS>().ToList();
resultCustomFilters = result.GetResult<CUSTOMFILTERS>().ToList();
List<SUMMARY_DETAILS> resultSummary = result.GetResult<SUMMARY_DETAILS>().ToList();
}
}
catch (Exception)
{
throw;
}
}
catch (Exception ex)
{
throw;
}
Console.ReadLine();
}
}
---------------------------------------------------------
<?xml version="1.0" encoding="utf-8"?>
<Database Name="COMPANY_SCM" EntityNamespace="COMPANYSCMContext" ContextNamespace="COMPANYSCMContext" Class="COMPANYSCMDataContext" xmlns:ed="http://devart.com/schemas/EntityDeveloper/1.0" ed:Guid="3ba7fe19-35ce-4d9b-952f-c4d91572f1a6" Provider="Devart.Data.Oracle.Linq.Provider.OracleDataProvider, Devart.Data.Oracle.Linq" Extended="true" xmlns="http://schemas.devart.com/linqconnect/mapping">
<Connection Mode="ConnectionString" ConnectionString="User Id=COMPANY_SCM;Server=company;Persist Security Info=False" Provider="Devart.Data.Oracle" />
<Type Name="ACTIVE_REPORTS" ed:Guid="ece84fd8-c2a5-436e-a039-b262991639a0">
<Column Member="ID" Type="System.Int64" CanBeNull="false" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="34515003-fcc2-484a-a988-9b3f7d1b97e9" />
<Column Member="PayMethod" Type="System.Int32" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="58583ad4-1532-401c-b224-59bfc58d1028" />
<Column Member="AutDateTime" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="176b3923-1edd-4272-9616-d70868af7593" />
<Column Member="State" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="a25918bf-284d-4658-a63a-68ef016237df" />
<Column Member="ShopID" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="bad936a2-25b1-4b02-9b4e-de51b187be51" />
<Column Member="BankID" Type="System.Int32" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="a9d7c6e4-5d20-4d98-b557-cf8e4d68f3c9" />
<Column Member="Approved" Type="System.Int32" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="276b3643-5c6d-4d3c-88c9-f4ff01295b66" />
<Column Member="AuthorizationCode" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="7344cafe-ccae-4b64-8a95-929542d988f2" />
<Column Member="CurrencyCode" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="6e932b24-91b4-4945-a7b0-3df36eca6a1d" />
<Column Member="Country" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="f3c27585-4051-4ab7-8561-0fb371e93d8b" />
<Column Member="AutAmount" Type="System.Decimal" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="fba0db05-e81e-4d43-84fe-c8a1e44b258b" />
<Column Member="EnvironmentCode" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="ecdc52bb-01de-4ea5-9999-8ec495a00380" />
<Column Member="PayType" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="9c295231-60f7-4d72-8629-14351afdd852" />
<Column Member="PMDescription" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="eea556db-ce35-457f-94ad-48004196dadb" />
<Column Member="FDDescription" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="be0a9433-8814-4271-b7ec-ccc5337242de" />
<Column Member="CurrentAmount" Type="System.Decimal" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="5d4fe186-d96e-4a3b-8e11-ce720076e783" />
<Column Member="Balance" Type="System.Decimal" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="74c42655-56cd-47c7-b25f-ff82565c61cb" />
<Column Member="Alert" Type="System.Int32" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="496660b7-5550-4ed9-9401-dc87a079d43d" />
<Column Member="AlertDescription" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="178c2cb8-ce7c-455d-90c1-3c90efdfcd70" />
<Column Member="VBV" Type="System.Int32" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="383c6a2e-7de3-4eb7-bcd8-6b380fb9278a" />
<Column Member="HolderName" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="f46b50ec-c945-4468-97fc-5d652b2cf223" />
<Column Member="HolderEmail" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="0faf02fb-3039-4fc9-82e4-830254c1455b" />
<Column Member="ErrorCode" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="263e90cd-4072-4025-b1cd-3650cce143fc" />
<Column Member="PercentageFee" Type="System.Decimal" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="false" ed:Guid="d780135f-db9b-40f6-9ad2-27a56f852880" />
<Column Member="MovementAmount" Type="System.Decimal" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="false" ed:Guid="78a49e4e-2333-4a54-85bf-a0403e6072c9" />
<Column Member="MovementDateTime" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="33921a29-db42-40a3-bf06-fae457b678a4" />
<Column Member="MovementEnvironment" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="f9166417-c824-4f1a-8461-b89a2b3e32ac" />
<Column Member="CancelledAmount" Type="System.Decimal" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="false" ed:Guid="c1fd2111-6e67-4c57-9463-0cf3bf79fb72" />
<Column Member="CancelledDateTime" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="724f764b-6e88-47d2-b469-e16c2ecfb706" />
<Column Member="CancelledEnv" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="b43699ca-cfc0-45e5-b483-993a4f5e67d0" />
<Column Member="PayTypeDescr" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="12d54a17-0125-4026-99b3-b0fb10e87127" />
<Column Member="DataAuhonicatet" Type="System.DateTime" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="9615f761-b0e1-4c19-b6cf-bb0f85d9bde5" />
<Column Member="VerifyResult" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="3096e000-66ed-4e26-9ce6-2ee885431f0b" />
<Column Member="Event" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="5452213e-5025-499b-b973-31c30c9f539c" />
<Column Member="DateTime" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="false" ed:Guid="50451560-3150-4c58-bb67-8b90d60742dd" />
<Column Member="Amount" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="false" ed:Guid="472aa8b1-fe30-4b7c-9d62-45090f41fb5a" />
<Column Member="FraudResponse" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="9dde1438-477d-48ad-b6a5-9ae0cb265ea9" />
<Column Member="Percentageamount" Type="System.Decimal" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="false" ed:Guid="ff2b43e1-43d0-4a3b-8d71-53d8f6435069" />
<Column Member="IMAGE" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="dfe1b410-51e6-471f-a1c0-d28492350d60" />
<Column Member="MethodID" Type="System.Int32" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="false" ed:Guid="31ac8937-d4e5-4d97-b49b-fd71ab3b56bf" />
<Column Member="EnableAlert" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="9d1cc127-63f9-4172-9830-76c0b3ac7532" />
<Column Member="ChargeBack" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="5ba55e40-a902-47b5-a362-b968ebf71521" />
</Type>
<Type Name="CUSTOMFILTERS" ed:Guid="1df54f77-f09b-4abf-b20d-28bae1cfc0d7">
<Column Member="IDFILTER" Type="System.Int64" CanBeNull="false" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="99559747-2843-451e-bf27-a561b0b2e62f" />
<Column Member="IDFIELD" Type="System.Int64" CanBeNull="false" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="d8800dc9-f6b4-40a7-bf83-ef8fc0b7c025" />
<Column Member="FIELDVALUE" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="57fb3b63-9131-4521-9367-b13c7a38305c" />
<Column Member="IDTRANSACTION" Type="System.Int64" CanBeNull="false" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="375b744f-f6a0-4b54-80e5-4ca5bfa0ee6b" />
<Column Member="FIELDNAME" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="e8083332-5906-450f-a514-8bffc1a734ad" />
<Column Member="FIELDLABEL" Type="System.String" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="8c3a1def-0182-455c-a490-cd4af6361dee" />
</Type>
<Type Name="SUMMARY_DETAILS" ed:Guid="c943324e-bbe7-4766-8ec5-d37618f62261">
<Column Member="TotalAutAmount" Type="System.Decimal" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="afbd2d1f-4de5-4059-a9d2-3b75b9bd8d4a" />
<Column Member="TotalBalance" Type="System.Decimal" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="9443e05e-842a-40d7-b4a3-065ab2e0cc59" />
<Column Member="TotalRecords" Type="System.Decimal" CanBeNull="true" UpdateCheck="Never" ed:ValidateRequired="true" ed:Guid="b7a7b571-bf05-40e7-b586-2a2d46871ea3" />
</Type>
<Function Name="ACTIVE_DATA_COMPANY_EMPLOYEE" Method="PRGETCOMPANYDETAILS" ed:Guid="48da574c-34d0-433a-a0b1-10df0500903b">
<Parameter Name="IDFILTER_IN" Type="System.Decimal" DbType="NUMBER" FixedLength="true" MaxLength="22" />
<Parameter Name="FROMDATE_IN" Type="System.String" DbType="VARCHAR2(4000 CHAR)" />
<Parameter Name="TODATE_IN" Type="System.String" DbType="VARCHAR2(4000 CHAR)" />
<Parameter Name="DATERANGE_IN" Type="System.String" DbType="VARCHAR2(4000 CHAR)" />
<Parameter Name="AUT_AMOUNT_FROM_IN" Type="System.Decimal" DbType="NUMBER" FixedLength="true" MaxLength="22" />
<Parameter Name="MOV_AMOUNT_FROM_IN" Type="System.Decimal" DbType="NUMBER" FixedLength="true" MaxLength="22" />
<Parameter Name="AUT_AMOUNT_TO_IN" Type="System.Decimal" DbType="NUMBER" FixedLength="true" MaxLength="22" />
<Parameter Name="MOV_AMOUNT_TO_IN" Type="System.Decimal" DbType="NUMBER" FixedLength="true" MaxLength="22" />
<Parameter Name="TRANSACTIONTYPE_IN" Type="System.String" DbType="VARCHAR2(4000 CHAR)" />
<Parameter Name="UICCODE_IN" Type="System.String" DbType="VARCHAR2(4000 CHAR)" />
<Parameter Name="BANKTRXID_IN" Type="System.Decimal" DbType="NUMBER" FixedLength="true" MaxLength="22" />
<Parameter Name="APPROVEDTRANSACTION_IN" Type="System.Decimal" DbType="NUMBER" FixedLength="true" MaxLength="22" />
<Parameter Name="SHOPTRXID_IN" Type="System.String" DbType="VARCHAR2(4000 CHAR)" />
<Parameter Name="ERRORCODE_IN" Type="System.String" DbType="VARCHAR2(4000 CHAR)" />
<Parameter Name="AUTHORIZATIONCODE_IN" Type="System.String" DbType="VARCHAR2(4000 CHAR)" />
<Parameter Name="PAYMENTMETHOD_IN" Type="System.Decimal" DbType="NUMBER" FixedLength="true" MaxLength="22" />
<Parameter Name="ALERT_IN" Type="System.Decimal" DbType="NUMBER" FixedLength="true" MaxLength="22" />
<Parameter Name="TRANSACTIONSTATE_IN" Type="System.String" DbType="VARCHAR2(4000 CHAR)" />
<Parameter Name="THREEDLEVEL_IN" Type="System.String" DbType="VARCHAR2(4000 CHAR)" />
<Parameter Name="RED_FRAUDRESPONSE_IN" Type="System.String" DbType="VARCHAR2(4000 CHAR)" />
<Parameter Name="IDSHOP_IN" Type="System.Decimal" DbType="NUMBER" FixedLength="true" MaxLength="22" />
<Parameter Name="IDLANGUAGE_IN" Type="System.Decimal" DbType="NUMBER" FixedLength="true" MaxLength="22" />
<Parameter Name="CUSTOMFIELDSID_IN" Type="System.String" DbType="VARCHAR2(4000 CHAR)" />
<Parameter Name="CUSTOMFIELDSVALUE_IN" Type="System.String" DbType="VARCHAR2(4000 CHAR)" />
<Parameter Name="GETRESULTSFOR_IN" Type="System.String" DbType="VARCHAR2(4000 CHAR)" />
<Parameter Name="ROWNUMFROM_IN" Type="System.Decimal" DbType="NUMBER" FixedLength="true" MaxLength="22" />
<Parameter Name="ROWNUMTO_IN" Type="System.Decimal" DbType="NUMBER" FixedLength="true" MaxLength="22" />
<Parameter Name="CHARGEBACK_IN" Type="System.String" DbType="VARCHAR2(4000 CHAR)" />
<Parameter Name="FRAUD_IN" Type="System.String" DbType="VARCHAR2(4000 CHAR)" />
<Parameter Name="SORTBY_IN" Type="System.String" DbType="VARCHAR2(4000 CHAR)" />
<Parameter Name="SORTDIR_IN" Type="System.String" DbType="VARCHAR2(4000 CHAR)" />
<Parameter Name="ROWFILTERDATE_IN" Type="System.String" DbType="VARCHAR2(4000 CHAR)" />
<Parameter Name="OUT_ERRORCODE" Type="System.String" DbType="VARCHAR2(4000 CHAR)" Direction="Out" />
<Parameter Name="OUT_ERRORMESSAGE" Type="System.String" DbType="VARCHAR2(4000 CHAR)" Direction="Out" />
<ElementType Type="ACTIVE_REPORT" />
<ElementType Type="CUSTOMFILTERS />
<ElementType Type="SUMMARY_DETAILS" />
</Function>
</Database>
Last edited by bharaniKumar on Thu 09 Mar 2017 10:26, edited 2 times in total.
-
- Posts: 9
- Joined: Tue 07 Mar 2017 13:40
Re: Using Devart 9.2.205 not able get result using getresult method it throws error but the same thing using in previously
sample data first call works fine second call throws error
like Input string was not correct format
or
value cannot be null
like Input string was not correct format
or
value cannot be null
Re: Using Devart 9.2.205 not able get result using getresult method it throws error but the same thing using in previously
Could you please try to localize the issue and send us a small complete test project with the corresponding DDL/DML script for reproducing the problem in our environment?
-
- Posts: 9
- Joined: Tue 07 Mar 2017 13:40
Re: Using Devart 9.2.205 not able get result using getresult method it throws error but the same thing using in previously
Hi Shalex,Shalex wrote:Could you please try to localize the issue and send us a small complete test project with the corresponding DDL/DML script for reproducing the problem in our environment?
I will give some sample what we have tried before..........
-
- Posts: 9
- Joined: Tue 07 Mar 2017 13:40
Re: Using Devart 9.2.205 not able get result using getresult method it throws error but the same thing using in previously
Hi Shalex,Shalex wrote:Could you please try to localize the issue and send us a small complete test project with the corresponding DDL/DML script for reproducing the problem in our environment?
I will give some sample what we have tried before..........
Re: Using Devart 9.2.205 not able get result using getresult method it throws error but the same thing using in previously
Please notify here after submitting a small complete test project with the corresponding DDL/DML script for reproducing.bharaniKumar wrote:I will give some sample what we have tried before..........
-
- Posts: 51
- Joined: Mon 09 Apr 2012 09:57
Re: Using Devart 9.2.205 not able get result using getresult method it throws error but the same thing using in previously
We have the same problem with our version (see our post viewtopic.php?f=1&t=33504) :
- Devart.Data 5.0.1408.0
- Devart.Data.Linq 4.5.954.0
- Devart.Data.Oracle 8.5.616.0
- Devart.Data.Oracle.Linq 8.5.616.0 EF1
The problem appears on Linq resquest only.
It's very difficult to find the origin, because in our case, it appears sometimes and not everytimes.
When we have this problem, with put the Linq resquest in a var, and after we execute the instruction .ToList() into another variable.
Exemple - Error :
Exemple - Without error :
- Devart.Data 5.0.1408.0
- Devart.Data.Linq 4.5.954.0
- Devart.Data.Oracle 8.5.616.0
- Devart.Data.Oracle.Linq 8.5.616.0 EF1
The problem appears on Linq resquest only.
It's very difficult to find the origin, because in our case, it appears sometimes and not everytimes.
When we have this problem, with put the Linq resquest in a var, and after we execute the instruction .ToList() into another variable.
Exemple - Error :
Code: Select all
var q = from a in ObjectContext.Toto
join b in ObjectContext.Tata on a.Id equals b.Id
select new CustomObject
{
Id = a.Id,
Code = a.Code,
Date = b.Date
};
Code: Select all
var q1 = from a in ObjectContext.Toto
join b in ObjectContext.Tata on a.Id equals b.Id
select new { A1 = a, B1 = b };
var q2 = from a in q1.ToList()
select new CustomObject
{
Id = a.A1.Id,
Code = a.A1.Code,
Date = a.B1.Date
};
// WORKS !!!
Re: Using Devart 9.2.205 not able get result using getresult method it throws error but the same thing using in previously
Is a stack trace in the described scenario exactly the same like specified at viewtopic.php?f=1&t=33504#p120070? We still cannot reproduce the issue in our environment.
-
- Posts: 51
- Joined: Mon 09 Apr 2012 09:57
Re: Using Devart 9.2.205 not able get result using getresult method it throws error but the same thing using in previously
I think the bug is solved in 9.4 :
LinqConnect support
The bug with running LINQ queries, which invoke .NET methods on client side during materialization of result set, is fixed
The bug with materializing scalar value collection when converting values on the client side is fixed
I have upgraded my application with 9.4 and I cannot reproduce the problem.
LinqConnect support
The bug with running LINQ queries, which invoke .NET methods on client side during materialization of result set, is fixed
The bug with materializing scalar value collection when converting values on the client side is fixed
I have upgraded my application with 9.4 and I cannot reproduce the problem.
Re: Using Devart 9.2.205 not able get result using getresult method it throws error but the same thing using in previously
Thank you for confirming the fix.
-
- Posts: 51
- Joined: Mon 09 Apr 2012 09:57
Re: Using Devart 9.2.205 not able get result using getresult method it throws error but the same thing using in previou
The problem seams to still here !
In december 2017, I upgraded my version of devart to 9.4.299 (A fix was present in this release for LinqConnect issues) but it is still here.
I open Visual studio 2010. I launch my application and all working !
I stop my debugging, I compile/recompile my program again, I relaunch it, and this issue appears.
In my case, the problem is always on a DateTime properties (TIMESTAMP(6) NOT NULL in my Oracle database).
The framework installed is 4.7.02053.
The framework used on my application is 4.5.
I would like to precise too, that this issue appears in production environnement (application installed and download with clickonce).
https://image.noelshack.com/fichiers/20 ... 094335.jpg
In december 2017, I upgraded my version of devart to 9.4.299 (A fix was present in this release for LinqConnect issues) but it is still here.
I open Visual studio 2010. I launch my application and all working !
I stop my debugging, I compile/recompile my program again, I relaunch it, and this issue appears.
In my case, the problem is always on a DateTime properties (TIMESTAMP(6) NOT NULL in my Oracle database).
The framework installed is 4.7.02053.
The framework used on my application is 4.5.
I would like to precise too, that this issue appears in production environnement (application installed and download with clickonce).
https://image.noelshack.com/fichiers/20 ... 094335.jpg