Cannot implicitly convert type 'System.Linq.IQueryable<int>' to 'int?'

Question

Hi this is my code

var cityList = from country in doc.Element("result").Element("cities").Descendants("city")
                         select new
                         {
                             Name = country.Element("name").Value,
                             Code = country.Element("code").Value,
                             CountryCode = int.Parse(country.Element("countrycode").Value)
                         };


        foreach(var citee in cityList)
        {
        City city = new City();

        city.CountryID = from cnt in db.Countries where cnt.DOTWInternalID == citee.CountryCode select cnt.ID;
        }

Im getting an error on the second query as the title of this post, i tried converting to int, to nullable int nothing worked? help me guys

Thanks,

Answer 1

As the error message says, your Linq query returns an System.Linq.IQueryable (for all intents and purposes a collection of ints). If you'd like to get one of them, you can either call First or ElementAt(n) to get the n'th element.

Answer 2

it will return an iQueryable, you will need to do something like using the First

cit.CountryID = db.Countries.First(a=>a.DOTWInternalID == citee.CountryCode).ID

Answer 3

IQueryable is not a single int - but a query that can represent a collection.

Answer 4

Here is the problem and solution

from cnt in db.Countries where cnt.DOTWInternalID == citee.CountryCode select cnt.ID part. If you omit the ID then it returns a Generic IEnumerable with Country(hoping that you have Country class) class. So what you have to do is first return the select criteria and select the first row then the ID field. Same like shown below.

cit.CountryID = (from cnt in db.Countries where cnt.DOTWInternalID == citee.CountryCode   select cnt).First<Country>().ID;

This will solve your problem.