ansaurus

Question

Group by name and Include duplicate data in linq to xml c#

Answer 1

+1 A:

var resultsRubric =     
    from el1 in xd.Descendants("Rubric")
    where el1.Value.Equals(rubricSearchValue)
    select el1.Parent;

OR

var resultsReadCode =     
    from el1 in xd.Descendants("ReadCode")
    where el1.Value.Equals(readCodeSearchValue)
    select el1.Parent;

OR

var resultsRubric =     
    from el1 in xd.Descendants("Test")
    where el1.FirstChild("Rubric").Value.Equals(rubricSearchValue) || el1.FirstChild("ReadCode").Value.Equals(readCodeSearchValue)
    select el1.Parent;

With all three of those code snippets you can simply use a variable to list which Rubric or ReadCode you are looking for and it will return a list of the Test elements that contain the needed codes. From there you can go ahead and sort them in whichever way best appeals to you. Hope this helped a little bit.

Adkins 2010-09-27 11:35:23

@Adkins: What is readCodeSearchValue? Thanks for answering.

Cesar Lopez 2010-09-27 11:42:59

That is just a variable that would hold the value that you are looking for.

Adkins 2010-09-27 12:16:49

Answer 2

+1 A:

I might be misunderstanding you, but is this what you look for?

var set = xd.Descendants("Microbiology");
var results = set.GroupBy(p => p.ReadCode).Select(g => new {Code = g.Key, Tests = g.OrderByDescending(t => t.Date)});

Hope that gets you closer

danijels 2010-09-27 12:02:33

I love it when so much code turns out to be redundant :)

danijels 2010-09-28 09:31:17

Answer 3

+1 A:

I think it might be something like this you want to do:

    static void Main(string[] args)
    {
        var xd = XDocument.Parse(xml);
        if (xd != null)
        {
            var tests = xd.Descendants("Test");

            var groupedResult = (from test in tests
                         select new Microbiology
                         {
                             Date = test.Element("Date").Value,
                             ReadCode = test.Element("ReadCode").Value,
                             Heading = test.Element("Rubric").Value
                         }).
                         OrderByDescending(y => y.Date).
                         GroupBy(y => y.ReadCode);
            var result = from item in groupedResult
                         select new Microbiology
                         {
                             ReadCode = item.First().ReadCode,
                             Date = item.First().Date,
                             Heading = item.First().Heading,
                             SubMicro = item.Skip(1).ToList()
                         };
            foreach (var res in result)
            {
                Console.WriteLine(res.Heading);
                foreach(var item in res.SubMicro)
                Console.WriteLine(item.ReadCode + " " + item.Date);
            }
        }
        Console.ReadLine();
    }

What I do is the following: 1. Take all tests node. 2. Order them by date since that what you want. 3. Group them byt ReadCode so you get them grouped. 4. Select your result from the grouped result, and set SubMicro to the remaining list of elements (the skip(1) part, remove skip(1) if you want all the elements in the list.). Hope it helps.

mastoj 2010-09-27 12:13:00

you could probably optimize the code to make it shorter, but that's the first take on it.

mastoj 2010-09-27 12:13:33

Using linq I think it would make far more sense to just get the group that you want to work with from the start rather than reordering and regrouping a bunch of times. Simply throw a linq query that grabs the elements that have the ReadCode that is desired and then order by date, etc. etc.

Adkins 2010-09-27 12:18:29

See the new update, updated while you commented :). But I still think the groupedResult and result should be separated.

mastoj 2010-09-27 12:20:09

ansaurus

tags:

views:

answers:

Group by name and Include duplicate data in linq to xml c#

related questions