Devart Forums

I get an exception when trying to create a list/array from a IQueryAble resultset using dotconnect.

Sourcecode:

var result = entities.SLCAVEs.Where(t => t.PERSONID.HasValue && t.PERSONID.Value.Equals(personId));
Console.WriteLine(result.Count());
var list = result.ToArray();

The result-object contains 28 elements.

Stacktrace:
Unhandled Exception: System.FormatException: Input string was not in a correct format.
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 Devart.Data.Oracle.ag.aa(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Common.l.aq(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Common.l.b(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Data.Oracle.ag.b(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Data.Oracle.OracleDataReader.GetInt32(Int32 i)
at Devart.Data.Oracle.Entity.ai.b(Int32 A_0)
at Devart.Common.Entity.cd.GetValue(Int32 ordinal)
at System.Data.Entity.Core.Common.Internal.Materialization.Shaper.ErrorHandlingValueReader`1.GetUntypedValueDefault(DbDataReader reader, Int32 ordinal)
at System.Data.Entity.Core.Common.Internal.Materialization.Shaper.ErrorHandlingValueReader`1.GetValue(DbDataReader reader, Int32 ordinal)
at lambda_method(Closure , Shaper )
at System.Data.Entity.Core.Common.Internal.Materialization.Coordinator`1.ReadNextElement(Shaper shaper)
at System.Data.Entity.Core.Common.Internal.Materialization.Shaper`1.SimpleEnumerator.MoveNext()
at System.Data.Entity.Internal.LazyEnumerator`1.MoveNext()
at System.Linq.Buffer`1..ctor(IEnumerable`1 source)
at System.Linq.Enumerable.ToArray[TSource](IEnumerable`1 source)

Please send us a small complete test project with the corresponding DDL/DML script for reproducing the issue. In case of >2MB attachment, we recommend either using some file exchange server (send us the corresponding link) or uploading a test project to our FTP server (the credentials will be provided by email request).

Please, I have the same problem in my application.
I'am working with : Devart.Data (5.0.1408.0), Devart.Data.Linq (4.5.954.0), Devart.Data.Oracle(8.5.616.0), Devart.Data.Oracle.Entity (8.5.616.6), Devart.Data.Oracle.Linq (4.5.954.0).

Sometimes, it's occurred when I executed a LinqToOracle request into an IQueryable, and just after that, I want to use this IQueryable by doing a LinqToObject request.
At the end, I launch a IQueryable.ToList() I have this exception :

à System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
à System.Number.ParseDecimal(String value, NumberStyles options, NumberFormatInfo numfmt)
à System.Decimal.Parse(String s, IFormatProvider provider)
à Devart.Data.Oracle.ag.ab(Byte[] A_0, Int32 A_1, Int32 A_2)
à Devart.Common.l.j(Byte[] A_0, Int32 A_1, Int32 A_2)
à Devart.Data.Oracle.ag.j(Byte[] A_0, Int32 A_1, Int32 A_2)
à Devart.Data.Oracle.OracleDataReader.GetDecimal(Int32 i)
à MaterializeLgnColise(MaterializerScope )
à Devart.Data.Linq.Engine.ObjectReader`1.a()
à Devart.Data.Linq.Engine.ObjectReader`1.a(T& A_0)
à Devart.Data.Linq.Engine.ObjectReader`1.c()
à System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
à System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)

Please try to localize the issue and send us a small complete test project with the corresponding DDL/DML script for reproducing the issue.

In case of >2MB attachment, we recommend either using some file exchange server (send us the corresponding link) or uploading a test project to our FTP server (the credentials will be provided by email request).

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.

Thank you for confirming the fix.