Geek asks and answers

Fill an array of objects inside a LINQ query

How to fill Object Arrayinside aLINQ 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 request

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>
+3
source share
1 answer

You just need to make another request inside your request. For example, if an element channelcontains itemelements, you can do:

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

Update. It seems you are reading the file RSS, so your request should look 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()

            };

I also used an explicit conversion instead of trying to access a property Valueto prevent NullReferenceException.

+5
source

More articles:


All Articles