Databases
StackOverflow2013
Postsdbo
POLINQ to Entities does not recognize the method 'System.String ToString(Int32)' method, and this method cannot be translated into a store expression
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POLINQ to Entities does not recognize the method 'System.String ToString(Int32)' method, and this method cannot be translated into a store expression
    primarykey
    data
    text
    <p>Using MVC3 VS2010 and SQL Server 2008 Express I am trying to filter based on two SQL Server tables and display the result. One table is clients table and the other is agent. They have in common ClientAgentID in the clients table and ID in the Agents table. An agent logs and should be able to see the clients assigned to the agent. If you have any ideas on the best way to do this please help me. So far I am trying to filter in the clients controller and here is what I have but the message is I am getting is in the title.</p> <pre><code> public ActionResult Index() { //This displays all the clients not filtered by the Agent ID number //var clientItems = db.MVCInternetApplicationPkg; //return View(clientItems.ToList()); //Trying to filter by the agent name given in the login page then finding //the agent ID var getAgentID = from a in db.AgentsPkg where a.AgentLogin == User.Identity.Name select a.ID; var clientItems = from r in db.MVCInternetApplicationPkg where Convert.ToString(r.ClientAgentID) == Convert.ToString(getAgentID) select r; //THIS IS THE LINE OF CODE THAT SHOWS THE ERROR MESSAGE return View(clientItems.ToList()); } </code></pre> <p>This is my first MVC project after the Music Store so am willing to learn and accept any help or advice. Cheers</p> <p>Here is the solution that I used in the end. Any feed back on if this is a good approach would be appreciated</p> <pre><code> public ActionResult Index() { var innerJoint = from agents in db.AgentsPkg where agents.AgentLogin == User.Identity.Name join clients in db.MVCInternetApplicationPkg on agents.ID equals clients.ClientAgentID select clients; return View(innerJoint.ToList()); } </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USWillNZ
    1. USWillNZ
    plurals
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POLINQ to Entities does not recognize the method 'System.String ToString(Int32)' method, and this method cannot be translated into a store expression
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    2. VO
      singulars
      1. POLINQ to Entities does not recognize the method 'System.String ToString(Int32)' method, and this method cannot be translated into a store expression
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    3. VO
      singulars
      1. POLINQ to Entities does not recognize the method 'System.String ToString(Int32)' method, and this method cannot be translated into a store expression
      1. This table or related slice is empty.
      1. VTUpMod
    1. COpossible duplicate of [LINQ to Entities does not recognize the method 'Int32](http://stackoverflow.com/questions/3316615/linq-to-entities-does-not-recognize-the-method-int32)
      singulars
      1. POLINQ to Entities does not recognize the method 'System.String ToString(Int32)' method, and this method cannot be translated into a store expression
      1. USJP Alioto
    2. COIs there a foreign key defined between AgentsPkg and MVCInternetApplicationPkg?
      singulars
      1. POLINQ to Entities does not recognize the method 'System.String ToString(Int32)' method, and this method cannot be translated into a store expression
      1. USMerenzo
    3. CO@Merenzo There is a foreign Key defined in the SQL Data base but no where in the MVC does it reference a foreign key
      singulars
      1. POLINQ to Entities does not recognize the method 'System.String ToString(Int32)' method, and this method cannot be translated into a store expression
      1. USWillNZ
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload