Arithmetic overflow Exception in Linq query.

11y2.5kLINQ

Hello,

I know this is the genearl question but I didnot get solution.

I am getting the Arithmetic overflow error converting expression to data type int Exception in below line

ctx.Users.Where(un => un.CorporateEmail == username && un.Password == password).FirstOrDefault();

Can any one suggest me to get out of this?

Thanks.

10 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes11y ago
The code that you've posted is just a LINQ expression.

So what type of variable are you are actually assigning it to?
+1
Dhanasekar11y ago
what is the datatype of CorporateEmail ?
+1
Jignesh Trivedi11y ago
hi,

Is there any calculated filed in User table...?

please provide definition of User table and also some example data...
+1
Manish Kumar Choudhary11y ago
No error in this conduction. Debug the code and find the error. There may be error in you class where you are storing this result set.

Debug the code and check the proper error.
+1
11y ago
In my database CorporateEmail is varchar(50) and Password is also varchar(50).

No int datatype.
+1
Manish Kumar Choudhary11y ago
I think CorporateEmail or Password is of type int in your database so that error is coming. Modify that to string it will work fine.
+1
11y ago
Arithmetic overflow error converting expression to data type int

This above Exception.
+1
Manish Kumar Choudhary11y ago
what error you are getting ?
+1
11y ago
No luck sir.. Any other solution?
+1
Manish Kumar Choudhary11y ago
try this

ctx.Users.Where(un => un.CorporateEmail .Equals("username") && un.Password. Equals("password")).FirstOrDefault();
+1