Difference between two list<object> linq

Question

0.00/5 (No votes)

See more:

i have a two list of Client Class

C#

public class Client 
{
    public int ClientID { get; set; }
    public string ClientName { get; set; }
    public string companyName { get; set; }
    public string companyLocation { get; set; }
}

first list for NewClient
and second for oldClient

i need Three list
Newly Added clients
Deleted Clients
Common Clients

i tried following way but i want result on ClientID and Company Name
how i can add another condition so i can get difference based on these two values

I'm Getting Added and Deleted Values
but i'm not getting Common Clients

What I have tried:

i tried with

C#

List<Client> lstOld_Client = new List<Client>();
           List<Client> lstNew_Client = new List<Client>();


           Client C1 = new Client() { ClientName = "A", ClientID = 1, CompanyLocation = "Pune", CompanyName = "C1" };
           Client C2 = new Client() { ClientName = "A", ClientID = 1, CompanyLocation = "Pune", CompanyName = "C2" };

           lstNew_Client.Add(C1);
           lstNew_Client.Add(C2);

           lstOld_Client.Add(C1);

           var Added = lstNew_Client.Where(a => !lstOld_Client.Any(x => x.ClientID == a.ClientID && x.CompanyName == a.CompanyName)).ToList();
           var deleted = lstOld_Client.Where(a => !lstNew_Client.Any(x => x.ClientID == a.ClientID && x.CompanyName == a.CompanyName)).ToList();

           var commonElements = lstNew_Client.Where(a => lstOld_Client.Any(x => x.ClientID == a.ClientID && x.ClientName == a.ClientName)).ToList();

           var OldTemplete = lstOld_Client.Where(a => commonElements.Any(x => x.ClientID == a.ClientID && x.ClientName == a.ClientName)).FirstOrDefault();
           var NewTemplete = lstNew_Client.Where(a => commonElements.Any(x => x.ClientID == a.ClientID && x.ClientName == a.ClientName)).FirstOrDefault();

Posted 26-Apr-16 18:38pm

kedar001

Updated 19-Aug-18 21:32pm

v5

Add a Solution

Comments

George Jonsson 27-Apr-16 0:47am

Shouldn't
commonElements = NewClient.Where(a => oldClient.Any(x => x.ClientID== a.ClientID)).ToList();
be
commonElements = CommonClient.Where(a => oldClient.Any(x => x.ClientID== a.ClientID)).ToList();

That said, try
commonElements = CommonClient.Where(a => oldClient.Any(x => x.ClientID == a.ClientID && x.companyName == a.companyName)).ToList();
(assuming your LINQ works ok otherwise)

kedar001 27-Apr-16 2:16am

please check my Updated "What I have tried"

I'm getting Correct result for Added And Deleted ,but not able to get that common
i'm expecting "C1" in common

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Karthik_Mahalingam · Accepted Answer · 2016-04-26T18:50:00

Solution 1

C#

Common = NewClient.Where(n => oldClient.Any(o => o.ClientID == n.ClientID)).ToList();
        Deleted = oldClient.Where(o => !NewClient.Any(n => n.ClientID == o.ClientID)).ToList();
        NewlyAdded = NewClient.Where(n => !oldClient.Any(o => o.ClientID == n.ClientID)).ToList();

Posted 26-Apr-16 18:50pm

Karthik_Mahalingam

Comments

kedar001 27-Apr-16 1:37am

please check my Updated "What I have tried"

I'm getting Correct result for Added And Deleted ,but not able to get that common
i'm expecting "C1" in common

Karthik_Mahalingam 27-Apr-16 1:49am

getting 'A' twice
why you are checking with client name & company name..
ID is unique right?

kedar001 27-Apr-16 2:02am

No,these are records for Company having different Client

Karthik_Mahalingam 27-Apr-16 2:17am

ok fine. what you are expecting in commonElements list?
as per the query and logic it will return 2 items.

kedar001 27-Apr-16 2:21am

I'm Expecting "C1" in common as we have added C1 in both list old and New

Karthik_Mahalingam 27-Apr-16 2:35am

use this

  var commonElements = lstNew_Client.Where(a =>
                lstOld_Client.Any(x =>
                    x.ClientID == a.ClientID && x.ClientName == a.ClientName && x.CompanyName == a.CompanyName)).ToList();

take care of the spelling of the properties in the Class

kedar001 22-Jun-18 3:12am

please check below Code to get Common,Deleted and New values From list based on one Property Value.

i'am getting Correct Result if i try in demo application with Same value but
not in Application with Same value

Common = lstNewData.Where(n => lstOldData.Any(o => o.GetType().GetProperty(KeyField).GetValue(o, null) == n.GetType().GetProperty(KeyField).GetValue(n, null))).ToList();

Deleted = lstOldData.Where(o => !lstNewData.Any(n => n.GetType().GetProperty(KeyField).GetValue(n, null) == o.GetType().GetProperty(KeyField).GetValue(o, null))).ToList();

NewlyAdded = lstNewData.Where(n => !lstOldData.Any(o => o.GetType().GetProperty(KeyField).GetValue(o, null) == n.GetType().GetProperty(KeyField).GetValue(n, null))).ToList();

Karthik_Mahalingam 4-Jul-18 8:41am

sorry for the late reply,
is the issue solved?

kedar001 10-Jul-18 1:05am

thanks for the reply :)
yes. issue solved

Karthik_Mahalingam 10-Jul-18 4:41am

cool

DJPops 20-Aug-18 3:32am

can we find the updated records by comparing list1 with list2 based on id

ex .
List1
Id = 10
Name = "Mumbai"

List2
id = 10,
Name = "Pune"

resut must be List1 record

i.e
Id = 10
Name = Mumbai

This mean list1 rows column value is updated

Karthik_Mahalingam 21-Aug-18 6:29am

yes