Devart Forums

Posted: **Thu 06 Sep 2012 14:56**

I'm using dotConnect for SQLite 4.1.58.
I got following error:

Arithmetic operation resulted in an overflow.

at MaterializeFigure(MaterializerScope )
   at Devart.Data.Linq.Engine.ObjectReader`1.a()
   at Devart.Data.Linq.Engine.EntityReader`3.a()
   at Devart.Data.Linq.Engine.ObjectReader`1.a(T& A_0)
   at Devart.Data.Linq.Engine.ObjectReader`1.g()
   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)

with simple query:

Code: Select all

from fq in DB.FigureQuestions
where fq.Id_question == idQuestion
select fq.Figures).ToList<Figure>();

It occurs only in SQLite (with dotConnect for MySql it works correctly, with older versions 3.x it works properly as well).

I sent you sample project for reproducing this problem through your contact form.

(Tested also with today released version 4.2.27. Same exception thrown.)

Posted: **Fri 07 Sep 2012 10:26**

Thank you for the sample project. We have reproduced this issue. We will investigate it and inform you about the results as soon as possible.

Posted: **Tue 11 Sep 2012 15:52**

We have analyzed the test project. The problem is that the 'add_text' column of the 'exam_figure' table is mapped to a property of the 'sbyte?' type, but a row in the table has the value larger than 127 in its 'add_text' cell. Thus, the error occurs when trying to assign this value to the 'sbyte?' AddText property of an ExamFigure object.

To resolve the issue, you can either map the AddText property to, e.g., Int32, or ensure that the table contains only proper 'sbyte' values.

Posted: **Thu 13 Sep 2012 07:15**

Oh, of course. My fault

Thank you for finding out the problem and my apologies for wasting your time.

Devart Forums

Arithmetic operation resulted in an overflow

Arithmetic operation resulted in an overflow

Re: Arithmetic operation resulted in an overflow

Re: Arithmetic operation resulted in an overflow

Re: Arithmetic operation resulted in an overflow