问从CosmosDB中获取结果，并将其放在包含指向另一个类的属性的C#类中。

EN

--- Category example on Container Categories
{
    "id": "expert_talks",
    "name": "Expert Talks",
 }

--- Timeline example on Container Timeline
    "id": "30122021170000",
    "type": "PDF",
    "datePublished": "2021-12-29T16:00:00.944Z",
    "title": "The Title2",
    "subTitle": "The Subtitle2",
    "category": "expert_talks",
    "tags": [
        "Alpha",
        "Bravo",
        "Charlie",
        "Delta",
        "Echo",
        "Fox"
    ],
    "file": "https://africau.edu/images/default/sample.pdf"
}

// My models
    public class TimelineItem
    {
        public string Id { get; set; }
        public string Type { get; set; }
        public string Title { get; set; }
        public string SubTitle { get; set; }
        public string File { get; set; }
        public Category Category { get; set; }
        public DateTime DatePublished { get; set; }
        public List<People>? People { get; set; }
        public List<string> Tags { get; set; }
    }
public class Category
    {
        public string Id { get; set; }
        public string Name { get; set; }
    }

// The code that's make the call
public async Task<List<TimelineItem>> GetTimeline()
        {
            string sqlQueryText = $"SELECT * FROM c order by c.id";
            QueryDefinition queryDefinition = new QueryDefinition(sqlQueryText);
            FeedIterator<TimelineItem> queryResultSetIterator = this.timelineContainer.GetItemQueryIterator<TimelineItem>(queryDefinition);
            List<TimelineItem> items = new List<TimelineItem>();
            while (queryResultSetIterator.HasMoreResults)
            {
                FeedResponse<TimelineItem> currentResultSet = await queryResultSetIterator.ReadNextAsync();
                foreach (TimelineItem item in currentResultSet)
                {
                    items.Add(item);
                }
            }
            return items;
        }