ansaurus

Question

How would I use LINQ2XML in this scenario?

Answer 1

+5 A:

I would start out by breaking this down into smaller pieces. First, I would massage the time layouts into a more workable form, grouped by the layout key, with the valid start time and valid end time associated with each other:

var timeLayouts =
    from tempvalue in XMLDoc.Descendants("time-layout")
    let tempStartTimes = tempvalue.Elements("start-valid-time").
            Select((x, i) => new { Index = i, ValidDateTime = (DateTime)x })
    let tempEndTimes = tempvalue.Elements("end-valid-time").
            Select((x, i) => new { Index = i, ValidDateTime = (DateTime)x })
    select new
    {
        LayoutKey = tempvalue.Element("layout-key").Value,
        ValidTimeRanges =
            from s in tempStartTimes
            from e in tempEndTimes
            where s.Index == e.Index
            select new 
            { 
                Index = s.Index, 
                ValidStartDateTime = s.ValidDateTime, 
                ValidEndDateTime = e.ValidDateTime 
            }
    };

Then, I would massage the parameters in much the same way:

var parameters =
    from tempvalue in XMLDoc.Descendants("temperature")
    select new
    {
        TemperatureType = (string) tempvalue.Attribute("type"),
        TimeLayout = (string) tempvalue.Attribute("time-layout"),
        Temperatures = tempvalue.Elements("value").Select((x, i) =>
            new { Index = i, Temperature = (int)x })
    };

From there, it's not so hard to get your maximums and minimums:

var maximums =
    from p in parameters
    where p.TemperatureType == "maximum"
    from tl in timeLayouts
    where tl.LayoutKey == p.TimeLayout
    from tr in tl.ValidTimeRanges
    from t in p.Temperatures
    where tr.Index == t.Index
    select new { tr.ValidStartDateTime, tr.ValidEndDateTime, 
        t.Temperature };

var minimums =
    from p in parameters
    where p.TemperatureType == "minimum"
    from tl in timeLayouts
    where tl.LayoutKey == p.TimeLayout
    from tr in tl.ValidTimeRanges
    from t in p.Temperatures
    where tr.Index == t.Index
    select new { tr.ValidStartDateTime, tr.ValidEndDateTime, 
        t.Temperature };

You could go some other ways with this, if you wanted to simplify some of the representations (you could flatten out the layouts and parameters into something more "tabular", for example), it would just require a few tweaks.

casperOne 2009-02-12 18:34:16

Thank you so much! I've been pulling my hair out trying to figure this out, reading books, code examples, etc. and nothing was suitable to my scenario. Your timeLayouts query will serve me well for pretty much the entire SOAP service.

M4dRefluX 2009-02-12 18:54:29

@M4dRefluX: No problem. If you have any questions about the specifics, feel free to ask.

casperOne 2009-02-12 18:58:59

ansaurus

tags:

views:

answers:

How would I use LINQ2XML in this scenario?

related questions