entity framework and LINQ - Arithmetic operation resulted in an overflow

Question

I'm recieving the error

Arithmetic operation resulted in overflow.

when running this:

using (MyEntities ctx = new MyEntities())
{
    var OraLINQEX1 = from e in ctx.TABLE_A
        select e;
    Console.WriteLine("LINQ to Entities Result");
    foreach (var result in OraLINQEX1)
    {
        //Console.WriteLine(String.Format("ID: {0}    Name: {1}", result.FIELDA,           result.FIELDB));
    }
}

My database is Oracle, I'm using this reference.

I used another table and it worked. My table has many fields. The fields are varchar2 and number without size.

I know the exact record of table that generetes the error, but I don´t know how to get a more detailed message.

Please, help me.

Is the error a SQL exception or is it happening in .NET? Also, are the numbers in the database too large to fit inside the types of the C# properties representing those columns (e. g. if you have an int property in C# representing a numeric column in the db with values > int.MaxValue or < int.MinValue)? — ChaseMedallion
– ChaseMedallion, Commented Sep 8, 2012 at 23:44

Cathy · Accepted Answer · 2012-09-17 11:12:55Z

1

I have the same problem. My exception comes from oracle.dataaccess and I think it happens because the number in the database has no scale, so there are 38 and it cannot be converted to decimal.

answered Sep 17, 2012 at 11:12

Cathy

111 bronze badge

Sign up to request clarification or add additional context in comments.

1 Comment

Nat Ritmeyer Over a year ago

Shouldn't this be a comment on the question rather than an answer?

Collectives™ on Stack Overflow

entity framework and LINQ - Arithmetic operation resulted in an overflow

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related