如何将LINQ查询结果转换为列表并返回通用列表? [英] How to convert LINQ query result to list and return generic List?

问题描述

我使用了通用ORM列表 例子.

I used generic ORM list example.

这是我的桌子.

Person table

Guid
Name
LastName

这是我的struct类.

and this is my struct class.

 public struct PersonItem   // database and class field names are the same
    {
        public Guid   Guid{ get; set; } 
        public string Name { get; set; }
        public string LastName { get; set; }
    }


  public struct PersonItems
    {
        public PersonItems()
        {
            Items = new List<PersonItem>();
        }

        public List<PersonItem> Items { get; set; }
    }

我使用的是这样，没问题，但是我总是不得不写字段的

I'm using such and no problem but I always have to write field's

public PersonItems GetPersons()
        {
            var query = (from p in _DbEntities.t_Crew
                         select p).ToList();

            if (query != null)
            {
                foreach (var item in query)
                {
                    _PersonItems.Items.Add(new PersonItem
                        {
                            Guid = item.Guid,
                            Name = item.Name,
                            LastName = item.LastName

                        });
                }
            }

            return _PersonItems;

        }   


   public PersonItems GetPersons()
    {
        PersonItems personItems = new PersonItems();

        var query = from p in _DbEntities.t_Person
                    select p; >> this here query I need to convert linq query result to list

       personItems = query.ToList();
       return personItems ;
    }

error

无法将类型System.Collections.Generic.List'隐式转换为PersonData.PersonItems'.

Cannot implicitly convert type System.Collections.Generic.List' to PersonData.PersonItems'.

推荐答案

尝试一下

 public PersonItems GetPersons()
    {
        PersonItems personItems = new PersonItems();

        var query = (from p in _DbEntities.t_Person
                    select new PersonItems 
                    {
                        test = p.SomeName,
                        //Other Stuff
                        //...
                    }).ToList();
       return query;
    }

这篇关于如何将LINQ查询结果转换为列表并返回通用列表?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！