如何正确从IEnumerable转换为List

本文关键字:List 转换 何正确 IEnumerable | 更新日期: 2023-09-27 18:32:36

我有这个 LINQ

 var questions = _context.Questions
            .Where(q => q.Level.Level == level)
            .Select(q => new QuestionViewModel
            {
                Text = q.Text,
                Id = q.Id,
                IsMultiSelected = q.IsMultiSelected,
                AnswerViewModels = q.Answers
                                       .Select(
                                           a => new AnswerViewModel
                                                    {
                                                        Checked = false,
                                                        Text = a.Text,
                                                        Id = a.Id
                                                    }) as List<AnswerViewModel>
            });
        return questions.ToList();

我得到

Exception Details: System.NotSupportedException: The 'TypeAs' expression with an input of type 'System.Collections.Generic.IEnumerable`1' and a check of type 'System.Collections.Generic.List`1' is not supported. Only entity types and complex types are supported in LINQ to Entities queries.

return questions.ToList();

我不在选择中使用匿名类型。如何解决此错误?

更新

我编写了一些解决方案

    List<QuestionViewModel> result = new List<QuestionViewModel>();
    var questions = from q in _context.Questions
                    where q.Level.Level == level
                    select new QuestionViewModel()
                               {
                                   Text = q.Text,
                                   Id = q.Id,
                                   IsMultiSelected = q.IsMultiSelected,
                                   AnswerViewModels = from a in q.Answers
                                                      select new AnswerViewModel
                                                                 {
                                                                     Text = a.Text,
                                                                     Id = a.Id,
                                                                     Checked = false
                                                                 }
                               };
    var qList = questions.ToList();
    for(int i = 0; i < questions.Count(); i++)
    {
        var q = qList[i]; //question
        var a = q.AnswerViewModels.ToList(); //answers for question
        var answers = new List<AnswerViewModel>(); //List answers
        for(int j = 0; j < a.Count(); j++)
        {
            //add new Answer from IEnumerable<AnswerViewQuestion> to List<...>
            answers.Add(new AnswerViewModel
                            {
                                Checked = false,
                                Id = a[j].Id,
                                Text = a[j].Text
                            });
        }
        result.Add(q);
    }

如何优化?

如何正确从IEnumerable<T>转换为List<T>

问题出在

.Select(a => new AnswerViewModel { ... }) as List<AnswerViewModel>

它应该是

.Select(a => new AnswerViewModel { ... }).ToList()

原因是,将 LINQ 生成的IEnumerable转换为List的正确方法当然是调用 ToList 扩展方法,您在给出的最后一行中已经这样做了。

尝试这样的事情:

var questions = _context.Questions
            .Where(q => q.Level.Level == level)
            .Select(q => new QuestionViewModel
            {
                Text = q.Text,
                Id = q.Id,
                IsMultiSelected = q.IsMultiSelected,
                AnswerViewModels = q.Answers
                                       .Select(
                                           a => new AnswerViewModel
                                                    {
                                                        Checked = false,
                                                        Text = a.Text,
                                                        Id = a.Id
                                                    })
            }).AsEnumerable().Select(x => new QuestionViewModel
              {
                   Text = x.Text,
                   Id = x.Id,
                   IsMultiSelected = x.IsMultiSelected,
                   AnswerViewModels = x.Answers.ToList()
               });
        return questions.ToList();
相关文章: