Arithmetic overflow Exception in Linq query.

Question

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.

Vulpes · Answer

The code that you've posted is just a LINQ expression. So what type of variable are you are actually assigning it to?

Dhanasekar · Answer

what is the datatype of CorporateEmail ?

Jignesh Trivedi · Answer

hi Is there any calculated filed in User table...? please provide definition of User table and also some example data...

Manish Kumar Choudhary · Answer

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.

Dipesh Tare · Answer

In my database CorporateEmail is varchar(50) and Password is also varchar(50). No int datatype.

Manish Kumar Choudhary · Answer

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.

Dipesh Tare · Answer

Arithmetic overflow error converting expression to data type int This above Exception.

Manish Kumar Choudhary · Answer

what error you are getting ?

Dipesh Tare · Answer

No luck sir.. Any other solution?

Manish Kumar Choudhary · Answer

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