Convert DataTable to Generic List in C#

by

You could actually shorten it down considerably. You can think of the Select() extension method as a type converter. The conversion could then be written as this:

List<Cards> target = dt.AsEnumerable()
    .Select(row => new Cards
    {
        // assuming column 0's type is Nullable<long>
        CardID = row.Field<long?>(0).GetValueOrDefault(),
        CardName = String.IsNullOrEmpty(row.Field<string>(1))
            ? "not found"
            : row.Field<string>(1),
    }).ToList();

More Related Contents:

  1. Get All instead of FirstOrDefault
  2. Retrieving Property name from lambda expression
  3. Convert generic List/Enumerable to DataTable?
  4. Combining two expressions (Expression)
  5. How do you convert a DataTable into a generic list?
  6. How can I get every nth item from a List?
  7. convert a list of objects from one type to another using lambda expression
  8. Func with out parameter
  9. Sorting a list using Lambda/Linq to objects
  10. Combination of List
  11. How do I invoke an extension method using reflection?
  12. Mutating the expression tree of a predicate to target another type
  13. Can I specify my explicit type comparator inline?
  14. Convert DataTable to generic List?
  15. What is the Efficiency and Performance of LINQ and Lambda Expression in .Net?
  16. Multiple Order By with LINQ [duplicate]
  17. lambda expressions in immediate window for VS2015
  18. Is it Linq or Lambda?
  19. C# Pass Lambda Expression as Method Parameter
  20. Cannot use a lambda expression as an argument to a dynamically dispatched operation without first casting it to a delegate or expression tree type
  21. Local variable and expression trees
  22. How to merge a list of lists with same type of items to a single list of items?
  23. How to check for nulls in a deep lambda expression? [duplicate]
  24. convert this LINQ expression into Lambda
  25. Access the value of a member expression
  26. List complex sorting
  27. How do I dynamically create an Expression predicate?
  28. Convert DataTable to List
  29. Linq – Top value from each group
  30. Linq query or Lambda expression?

Leave a Comment