CSharp - Intersect for DataRow

Introduction

The Intersect operator produces a sequence of DataRow objects that is the intersection of two sequences of DataRow objects.

Prototypes

public static IEnumerable<T> Intersect<T> (
  this IEnumerable<T> first,
  IEnumerable<T> second,
  IEqualityComparer<T> comparer);

The Intersect Operator with and Without the Comparer Object

Demo

using System;
using System.Linq;
using System.Collections;
using System.Collections.Generic;
using System.Data;

class Program/*from w ww  . j  a va 2s.  c o  m*/
{
    static void Main(string[] args)
    {
        Student[] students = {
        new Student { Id = 1, Name = "Joe Ruby" },
        new Student { Id = 7, Name = "Apache Python" },
        new Student { Id = 13, Name = "Scala Sinclair" },
        new Student { Id = 72, Name = "Django SQL" }
      };

        Student[] students2 = {
        new Student { Id = 5, Name = "Abe Html" },
        new Student { Id = 7, Name = "Apache Python" },
        new Student { Id = 29, Name = "Future Man" },
        new Student { Id = 72, Name = "Django SQL" }
      };

        DataTable dt1 = GetDataTable(students);
        IEnumerable<DataRow> seq1 = dt1.AsEnumerable();
        DataTable dt2 = GetDataTable(students2);
        IEnumerable<DataRow> seq2 = dt2.AsEnumerable();

        IEnumerable<DataRow> intersect =
          seq1.Intersect(seq2, System.Data.DataRowComparer.Default);

        Console.WriteLine("{0}Results of Intersect() with comparer{0}",
          System.Environment.NewLine);

        OutputDataTableHeader(dt1, 15);

        foreach (DataRow dataRow in intersect)
        {
            Console.WriteLine("{0,-15}{1,-15}",
              dataRow.Field<int>(0),
              dataRow.Field<string>(1));
        }

        intersect = seq1.Intersect(seq2);

        Console.WriteLine("{0}Results of Intersect() without comparer{0}",
          System.Environment.NewLine);

        OutputDataTableHeader(dt1, 15);

        foreach (DataRow dataRow in intersect)
        {
            Console.WriteLine("{0,-15}{1,-15}",
              dataRow.Field<int>(0),
        dataRow.Field<string>(1));
        }
    }
    static void OutputDataTableHeader(DataTable dt, int columnWidth)
    {
        string format = string.Format("{0}0,-{1}{2}", "{", columnWidth, "}");

        //  Display the column headings.
        foreach (DataColumn column in dt.Columns)
        {
            Console.Write(format, column.ColumnName);
        }
        Console.WriteLine();
        foreach (DataColumn column in dt.Columns)
        {
            for (int i = 0; i < columnWidth; i++)
            {
                Console.Write("=");
            }
        }
        Console.WriteLine();
    }
    static DataTable GetDataTable(Student[] students)
    {
        DataTable table = new DataTable();

        table.Columns.Add("Id", typeof(Int32));
        table.Columns.Add("Name", typeof(string));

        foreach (Student student in students)
        {
            table.Rows.Add(student.Id, student.Name);
        }

        return (table);
    }
}

class Student
{
    public int Id;
    public string Name;
}

Result

• Previous
• Next