Select distinct rows from datatable in Linq

by

If it’s not a typed dataset, then you probably want to do something like this, using the Linq-to-DataSet extension methods:

var distinctValues = dsValues.AsEnumerable()
                        .Select(row => new {
                            attribute1_name = row.Field<string>("attribute1_name"),
                            attribute2_name = row.Field<string>("attribute2_name")
                         })
                        .Distinct();

Make sure you have a using System.Data; statement at the beginning of your code in order to enable the Linq-to-Dataset extension methods.

Hope this helps!

More Related Contents:

  1. How to flatten nested objects with linq expression
  2. Difference between Lookup() and Dictionary(Of list())
  3. VB.NET equivalent to C# var keyword [duplicate]
  4. Convert DateTime to Date string “dd/mm/yyyy”
  5. Is there a good LINQ way to do a cartesian product?
  6. Create a list from two object lists with linq
  7. How can I conditionally apply a Linq operator?
  8. LINQ Contains Case Insensitive
  9. “A lambda expression with a statement body cannot be converted to an expression tree”
  10. With block equivalent in C#?
  11. What is the use of Enumerable.Zip extension method in Linq?
  12. Entity Framework/Linq EXpression converting from string to int
  13. Mixing C# & VB In The Same Project
  14. Differences between IQueryable, List, IEnumerator?
  15. Linq join iquery, how to use defaultifempty
  16. How to convert an expression tree to a partial SQL query?
  17. How to convert linq results to HashSet or HashedSet
  18. Unable to create a constant value – only primitive types
  19. Check for any element that exists in two collections
  20. Convert list to dictionary using linq and not worrying about duplicates
  21. Getting odd/even part of a sequence with LINQ
  22. How does LINQ expression syntax work with Include() for eager loading
  23. C# Is there a LINQ to HTML, or some other good .Net HTML manipulation API?
  24. What does this C# code with an “arrow” mean and how is it called?
  25. Dynamic query with OR conditions in Entity Framework
  26. What are the most important functional differences between C# and VB.NET?
  27. Finding symmetric difference with LINQ
  28. How do I compose Linq Expressions? ie Func
  29. Is it possible to perform joins across different databases using LINQ?
  30. How to merge two lists using LINQ?

Leave a Comment