Return list using select new in LINQ

by

Method can not return anonymous type. It has to be same as the type defined in method return type. Check the signature of GetProjectForCombo and see what return type you have specified.

Create a class ProjectInfo with required properties and then in new expression create object of ProjectInfo type.

class ProjectInfo
{
   public string Name {get; set; }
   public long Id {get; set; }
}

public List<ProjectInfo> GetProjectForCombo()
{
    using (MyDataContext db = new MyDataContext (DBHelper.GetConnectionString()))
    {
        var query = from pro in db.Projects
                    select new ProjectInfo(){ Name = pro.ProjectName, Id = pro.ProjectId };

        return query.ToList();
    }
}

More Related Contents:

  1. How to have nested query with LINQ
  2. Convert DateTime to Date string “dd/mm/yyyy”
  3. Check whether an array is a subset of another
  4. Is there a good LINQ way to do a cartesian product?
  5. Create a list from two object lists with linq
  6. How can I conditionally apply a Linq operator?
  7. LINQ to SQL – Left Outer Join with multiple join conditions
  8. LINQ Contains Case Insensitive
  9. “A lambda expression with a statement body cannot be converted to an expression tree”
  10. Proper Linq where clauses
  11. What is the use of Enumerable.Zip extension method in Linq?
  12. Entity Framework/Linq EXpression converting from string to int
  13. How can I return an anonymous type from a method?
  14. How can I sort a string of text followed by a number using LINQ
  15. Generic All Controls Method
  16. Differences between IQueryable, List, IEnumerator?
  17. Linq join iquery, how to use defaultifempty
  18. How to convert an expression tree to a partial SQL query?
  19. How to convert linq results to HashSet or HashedSet
  20. Why does the Linq Cast helper not work with the implicit cast operator?
  21. Custom Method in LINQ to SQL query
  22. How to get first record in each group using Linq
  23. String.IsNullOrWhiteSpace in LINQ Expression
  24. How to search Hierarchical Data with Linq
  25. How/Can I use linq to xml to query huge xml files with reasonable memory consumption?
  26. AutoMapper for Func’s between selector types
  27. Linq OrderBy against specific values
  28. What is the best way to check two List lists for equality in C#
  29. Linq access property by variable
  30. LINQ Query to Convert string to datetime

Leave a Comment