LINQ to Entities does not recognize the method 'Int32 ToInt32(System.Object)' method, and this method cannot be translated into a store expression.

Question

0.00/5 (No votes)

See more:

, +

C#

public List<SalaryMonthlyViewModel> getallemployeeSalary()
     {
         var data = (from a in objentity.TblSalaryMonthlies
                     join b in objentity.TblEmployeeRegistrations on a.EmployeeId equals b.EmployeeId

                     select new SalaryMonthlyViewModel
                     {
                         SalaryMonthlyId = a.SalaryMonthlyId,
                         Month = a.Month,
                         Year = a.Year,
                         NetSalary = Convert.ToInt32(a.NetSalary),
                         PresentDay = a.PresentDay,
                         UserName = b.UserName
                     }).ToList();
         return data;
     }

Posted 25-Apr-14 0:39am

Šangeet Šhah

Add a Solution

Comments

phil.o 25-Apr-14 6:41am

What is the definition of SalaryMonthlyViewModel object, especially its NetSalary property: which type is it?

[no name] 25-Apr-14 6:50am

namespace LaxmiTatkal.Model
{
public class SalaryViewModel
{

public int SalaryId { get; set; }
public int Salary { get; set; }

public string Username { get; set; }
}
}

4 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sanket Saxena · Answer 1 · 2014-04-25T01:00:00

Trying to modify your code hope it helps. :)

C#

public List<salarymonthlyviewmodel> getallemployeeSalary()
     {
         var data = (from a in objentity.TblSalaryMonthlies
                     join b in objentity.TblEmployeeRegistrations on a.EmployeeId equals  b.EmployeeId
 
                     select new SalaryMonthlyViewModel
                     {
                         SalaryMonthlyId = a.SalaryMonthlyId,
                         Month = a.Month,
                         Year = a.Year,
                         NetSalary = a.NetSalary,
                         PresentDay = a.PresentDay,
                         UserName = b.UserName
                     }).ToList()// now we have in-memory query
                  .Select(c => new SalaryMonthlyViewModel()
                  {
                         SalaryMonthlyId = a.SalaryMonthlyId,
                         Month = a.Month,
                         Year = a.Year,
                         NetSalary = Convert.ToInt32(a.NetSalary),//This should work
                         PresentDay = a.PresentDay,
                         UserName = b.UserName
                  });
         return data;
     }
</salarymonthlyviewmodel>

gagandeep.pratihar · Answer 2 · 2014-04-25T00:52:00

Solution 1

I think ur NetSalary in table is not of Integer type thats why ur getting that error

Posted 25-Apr-14 0:52am

gagandeep.pratihar

Comments

[no name] 25-Apr-14 7:09am

SalaryMonthlyId int Unchecked
EmployeeId int Unchecked
NetSalary int Checked
Month int Unchecked
Year int Unchecked
PresentDay int Unchecked
IsActive bit Unchecked
IsDelete bit Unchecked
CreatedDate datetime Unchecked
ModifyDate datetime Checked

Raul Iloc · Answer 3 · 2014-04-25T00:56:00

You should create in your SalaryMonthlyViewModel class a property of type string named NetSalaryString and use that property in your LINQ expresion above in place of NetSalary.

The new property will do the convention to int like in the next code:

C#

public class SalaryMonthlyViewModel <br />
{<br />
//...<br />
private _netSallaryString;<br />
public NetSalaryString<br />
{<br />
   get{ return _netSallaryString;}<br />
   set{<br />
      _netSallaryString = value;<br />
       this.NetSalary = Convert.ToInt32(value);<br />
   }<br />
}<br />
//...<br />
}

Pinaki Mukherjee IT · Answer 4 · 2016-10-27T06:15:00

Solution 4

Just stay with Linq query. You need to to change the blow Line

C#

NetSalary = Convert.ToInt32(a.NetSalary),

to

C#

NetSalary = int.Parse(a.NetSalary),

This change may help you

Posted 27-Oct-16 6:15am

Pinaki Mukherjee IT

LINQ to Entities does not recognize the method 'Int32 ToInt32(System.Object)' method, and this method cannot be translated into a store expression.

4 solutions

Solution 3

Solution 1

Solution 2

Solution 4

Add your solution here

Preview 0

LINQ to Entities does not recognize the method 'Int32 ToInt32(System.Object)' method, and this method cannot be translated into a store expression.

4 solutions

Solution 3

Solution 1

Solution 2

Solution 4

Add your solution here

Preview 0

Existing Members

...or Join us