Fill object array inside of LINQ Query

Question

How to fill Object Array inside a LINQ Query

Here is my data model

public class Test
    {
        public string Link { get; set; }
        public string Title { get; set; }
        public string Description { get; set; }
        public Item[] Items { get; set; }
    }

 public class Item
    {
        public string Title { get; set; }
        public string Link { get; set; }
        public string Guid { get; set; }
        public DateTime PublishDate { get; set; }
        public string Description { get; set; }
    }

And here is the Query

var data = from feed in feedXml.Descendants("channel")
                        select new Rss
                        {
                            Title = feed.Element("title").Value,
                            Link = feed.Element("link").Value,
                            Description = feed.Element("description").Value,
                            Items = // here i have to fill the array of items
                        };

UPDATE xml formate

<channel>
  .....  
  <item>.....</item>
  <item>.....</item>
  <item>.....</item>
</channel>
<channel>
  .....  
  <item>.....</item>
  <item>.....</item>
  <item>.....</item>
</channel>
<channel>
  .....  
  <item>.....</item>
  <item>.....</item>
  <item>.....</item>
</channel>

provide your xml file format.

Selman Genç
– Selman Genç

2014-02-07 00:03:47 +00:00
Commented Feb 7, 2014 at 0:03 — Selman Genç
– Selman Genç, Commented Feb 7, 2014 at 0:03

Selman Genç · Accepted Answer · 2014-02-07 00:44:33Z

6

You just need to make another query inside of your query. For example if channel element contains item elements then you can do:

Items = feed.Elements("item")
           .Select(x => new Item { // set property values })
           .ToArray()

Update: It seems you are reading a RSS file, so your query should be something like this:

var data = from feed in feedXml.Descendants("channel")
            select new Rss
            {
                Title = (string) feed.Element("title"),
                Link = (string) feed.Element("link"),
                Description = (string) feed.Element("description"),
                Items = feed.Elements("item")
                    .Select(
                        x =>
                            new Item
                            {
                                Title = (string) x.Element("title"),
                                Link = (string) x.Element("link"),
                                Description = (string) x.Element("description"),
                                Guid = (string) x.Element("guid"),
                                PublishDate = (DateTime) x.Element("pubDate")
                            })
                    .ToArray()

            };

Also I have used explicit cast instead of trying to access Value property directly to prevent NullReferenceException.

edited Feb 7, 2014 at 0:44

answered Feb 7, 2014 at 0:06

Selman Genç

102k15 gold badges126 silver badges193 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Selman Genç Over a year ago

@AhmadAbbasi actually I mean the item element's format.But that's ok see my update, if the element names are wrong you can change it.At least you must have an idea now :)

Collectives™ on Stack Overflow

Fill object array inside of LINQ Query

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related