CODEWITHSUNDEEP
c#linqlinq-to-xml
user603007
user603007

Reputation: 11794

Unable to cast object of type 'WhereSelectEnumerableIterator

I am trying to cast my xml result to an IQueryable which gives this error:

An unhandled exception of type 'System.InvalidCastException' occurred in weatherxml.exe

Additional information: Unable to cast object of type 'WhereSelectEnumerableIterator`2[System.Linq.IGrouping`2[System.String,System.Xml.Linq.XElement],System.Linq.IGrouping`2[System.String,System.Xml.Linq.XElement]]' to type 'System.Linq.IQueryable`1[weatherxml.Station]'.

How can I convert this to get the right stations conversion? see code below:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Xml;
using System.Xml.Linq;

namespace weatherxml
{
    class Program
    {
        static void Main(string[] args)
        {
            string xmlData = @"<Observations><Observation><Station>ADELONG POST OFFICE</Station><DateTime>2010-09-02T00:00:00</DateTime><Temperature>19.212989033764689</Temperature></Observation><Observation><Station>ADELONG POST OFFICE</Station><DateTime>2010-09-01T00:00:00</DateTime><Temperature>28.529448969536205</Temperature></Observation><Observation><Station>ALBURY AIRPORT</Station><DateTime>2010-09-01T00:00:00</DateTime><Temperature>34.687027630716109</Temperature></Observation><Observation><Station>ALBURY AIRPORT AWS</Station><DateTime>2010-09-01T00:00:00</DateTime><Temperature>28.131385570453197</Temperature></Observation></Observations>";
            XDocument weatherData = XDocument.Parse(xmlData);

            var query = from item in weatherData.Descendants("Observation")
                        group item by (string)item.Element("Station")
                            into g
                            select g;

            foreach (var q in query)
            {
                var maxDate = q.Max(o => DateTime.Parse((string)o.Element("DateTime")));
                var latestObservation = q.FirstOrDefault(o => DateTime.Parse((string)o.Element("DateTime")) == maxDate);
                var newStation = new Station();
                newStation.Name = q.Key;
                newStation.MostRecentDate = maxDate;
                newStation.LastTemperature = Decimal.Parse((string)latestObservation.Element("Temperature"));

            }

            var stations=(IQueryable<Station>)query;


            Console.ReadLine();
        }
    }

    public class Station
    {
        public string Name { get; set; }
        public DateTime MostRecentDate { get; set; }
        public decimal LastTemperature { get; set; }

    }
}

Upvotes: 4

Views: 13236

Answers (1)

MarcinJuraszek
MarcinJuraszek

Reputation: 125650

You should integrate your foreach into LINQ query:

var query = from item in weatherData.Descendants("Observation")
            group item by (string)item.Element("Station") into g
            let maxDate = g.Max(o => (DateTime)o.Element("DateTime"))
            let latestObservation = g.FirstOrDefault(o => (DateTime)o.Element("DateTime") == maxDate)
            select new Station()
            {
                Name = g.Key,
                MostRecentDate = maxDate,
                LastTemperature = (decimal)latestObservation.Element("Temperature")
            }

But it will give you IEnumerable<Station> not IQueryable<>. You can get IQueryable<Station> by calling AsQueryable() method, but that really doesn't make any sense here.

Also, you can cast XElement to DateTime and Decimal directly, instead of casting to string first and then calling Parse method.

Upvotes: 2

Related Questions