How to use the Except in C# [closed]

by

You could use Enumerable.Except on these fields:

var sendIdentityFields = from s in sendTable.AsEnumerable()
                         select new
                         {
                             BUS = s.Field<int>("BUS"),
                             IDENT = s.Field<int>("IDENT"),
                             STATION = s.Field<int>("STATION"),
                             REF1 = s.Field<string>("REF1"),
                             REF2 = s.Field<string>("REF2"),
                             REF3 = s.Field<string>("REF3"),
                             REF4 = s.Field<string>("REF4"),
                             REF5 = s.Field<string>("REF5"),
                             REF6 = s.Field<string>("REF6"),
                             REF7 = s.Field<string>("REF7"),
                             REF8 = s.Field<string>("REF8")
                         };
var receivedIdentityFields = from r in sendTable.AsEnumerable()
                         select new
                         {
                             BUS = r.Field<int>("BUS"),
                             IDENT = r.Field<int>("IDENT"),
                             STATION = r.Field<int>("STATION"),
                             REF1 = r.Field<string>("REF1"),
                             REF2 = r.Field<string>("REF2"),
                             REF3 = r.Field<string>("REF3"),
                             REF4 = r.Field<string>("REF4"),
                             REF5 = r.Field<string>("REF5"),
                             REF6 = r.Field<string>("REF6"),
                             REF7 = r.Field<string>("REF7"),
                             REF8 = r.Field<string>("REF8")
                         };
var sendButNotReceived = sendIdentityFields.Except(receivedIdentityFields);

Of course this selects just the anonymous type with these fields and not DataRows. If you need to select the DataRows of sendTable you need to join them with this result on the same fields.

More Related Contents:

  1. How to have nested query with LINQ
  2. LINQ query on a DataTable
  3. Join/Where with LINQ and Lambda
  4. Preserving order with LINQ
  5. Deserializing JSON to .NET object using Newtonsoft (or LINQ to JSON maybe?)
  6. How to create LINQ Expression Tree to select an anonymous type
  7. Use LINQ to get items in one List, that are not in another List
  8. Order of LINQ extension methods does not affect performance?
  9. Where IN clause in LINQ [duplicate]
  10. How to combine more than two generic lists in C# Zip?
  11. Query an XDocument for elements by name at any depth
  12. Establish a link between two lists in linq to entities where clause
  13. What is the point of Lookup?
  14. LINQ, Where() vs FindAll()
  15. Swap two items in List
  16. How do I get the index of the highest value in an array using LINQ?
  17. Exception using CopyToDataTable with “new {..}” LINQ query
  18. How to group by on 2 child entities and get total of both this child entities?
  19. Is the Linq Count() faster or slower than List.Count or Array.Length?
  20. Custom Method in LINQ to SQL query
  21. How to get first record in each group using Linq
  22. String.IsNullOrWhiteSpace in LINQ Expression
  23. How to search Hierarchical Data with Linq
  24. How/Can I use linq to xml to query huge xml files with reasonable memory consumption?
  25. AutoMapper for Func’s between selector types
  26. linq: order by random
  27. Transform IEnumerable asynchronously by awaiting each task
  28. Select distinct rows from datatable in Linq
  29. Map two lists into a dictionary in C#
  30. How to check if all list items have the same value and return it, or return an “otherValue” if they don’t?

Leave a Comment