Cannot implicitly convert type 'string' to 'int' using linq c#?

Asked Mar 27 '17 at 06:40

Active Mar 27 '17 at 06:40

Viewed 204 times

i have write this query for getting sum of marks using linq c# "System.NotSupportedException: LINQ to Entities does not recognize the method 'Int32 ToInt32(System.String)' method, and this method cannot be translated into a store expression.".

write this query :

int Marks = 0; 
 public string maths {get;set} 
Marks = db.Users.Where(t => t.userid == t.Markstb.id).Sum(t => Convert.ToInt32(t.Markstb.maths)); // here getting error

any one know how can do that please let me know?

asked Mar 27 '17 at 06:40

coderwill

use `.Sum(t => (int)(t.Markstb.maths ?? "0"));` – Brivvirs Mar 27 '17 at 06:47
no still error getting can not implicitly convert type 'sting' to 'long?' – coderwill Mar 27 '17 at 06:48
now getting like this can not implicitly convert type 'sting' to 'int' – coderwill Mar 27 '17 at 06:53
then add ToList() to Sum in memory. `.ToList().Sum(t => (int)(t.Markstb.maths ?? "0"));` – Brivvirs Mar 27 '17 at 06:56
no still is same error. i m try convert.toint(32) then resolved issue thanks for the help.. – coderwill Mar 27 '17 at 06:57
make sure that `t.Markstb.maths` can be converted to int – Brivvirs Mar 27 '17 at 07:01
@coderwill: can you first show us what the type of `t.Markstb.maths` is? – Willem Van Onsem Mar 27 '17 at 07:03

Cannot implicitly convert type 'string' to 'int' using linq c#?

0 Answers0