LINQ to entities exception

I'm trying to pull out an object from a DbSet with a Linq query.

I use the syntax:

Nation nation = nationDB.Nations.Where(c => c.ID == testNation.ID).First();

I get the following exc开发者_如何学JAVAeption:

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

The class Nation has a couple of string fields, one int field (the ID) and a couple of other objects as fields.

What can the problem be?

You need to pull out the integer first because there is no appropriate translation for retrieving the integer from your object Nation within the Linq to Entities scope:

int testId = testNation.ID;
Nation nation = nationDB.Nations.Where(c => c.ID == testId).SingleOrDefault();

If ID is of type int then shouldn't the line be:

 Nation nation = nationDB.Nations.Where(c => c.ID == 1).SingleOrDefault();

Removed the quotes to do an int to int compare.

so if you say " one int field (the ID) " and .Where(c => c.ID == "1") i think you need change to

.Where(c => c.ID == 1)