Linq Except Operator to Get NonEmployee And Employee collection

Introduction

There are two set collection of one ResourceBased Collection and other EmployeeBasedCollection. ResourceBased collection is superset and EmployeeBasedCollection is subset. Using the LINQ Except operator i will try to fetch NonEmployeeBasedCollection.

Background

Usually we carry set based operation in SQL query at database level using joins and Except operator in database. What if we got the similar case in code behind or layered architecture where we got two set collections in hand and where we don't want to involve database. In such cases generics and LINQ comes handy. This is what I tried to demonstrated below .

Using the code

The code is self explanatory.

 
 
 
 
protected void Page_Load(object sender, EventArgs e)
    {
        IList<ResourceBase> li=GetJoinAAndB();
        foreach (ResourceBase Ui in li)
        
            Response.Write(Ui.ID);
        
private IList<ResourceBase> GetJoinAAndB()
    {
      List<ResourceBase> resourceBaseSet = new List<ResourceBase>();
        resourceBaseSet.Add(
new ResourceBase(1,"santosh","sanAddress"));
 
 
        resourceBaseSet.Add(
new ResourceBase(2, "santosh", "sanAddress"));
        resourceBaseSet.Add(
new ResourceBase(3, "santosh", "sanAddress"));
List<ResourceBase> employeeBasedSet = new List<ResourceBase>();
        employeeBasedSet.Add(
new ResourceBase(1, "santosh", "sanAddress"));
        employeeBasedSet.Add(
new ResourceBase(4, "santosh", "sanAddress"));
        employeeBasedSet.Add(
new ResourceBase(5, "santosh", "sanAddress"));  
var query=( from a in resourceBaseSet                          
select a ).Except                               
from b in employeeBasedSet                                
from a1 in resourceBaseSet
where b.ID == a1.ID                                
select a1 );
 
return query.ToList();
    }
public class ResourceBase
    {
public ResourceBase(int id, string name, string address)
        {
            ID = id;
            Name = name;
            Address = address;
 
        }
public int ID { get; set; }
public String Name { get; set; }
public String Address { get; set; }
    }