How to compare datatable in entity C#?

Question

1.00/5 (1 vote)

See more:

How to compare different database same column?

What I have tried:

var t1= dbcontext.entities.Person(branchcode,countrycode).tolist();
//db change code
var t1= dbcontext.entities.Student(branchcode,countryclde).tolist();

varcommon=t1.Intersect(t2);

Posted 14-Nov-18 1:18am

StudentSC

Updated 14-Nov-18 1:32am

v2

Add a Solution

Comments

F-ES Sitecore 14-Nov-18 7:51am

If your question is how to connect "dbcontext" to a different database then you can pass the connection string to the target database when you create the class

dbcontext = new DbContext("connection string here")

2 solutions

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)

Aydin Homay · Answer 1 · 2018-11-14T01:29:00

Hi,

If your lists t1, and t2 are a list of strings then it is so easy you can do it in this way:

var t1= dbcontext.entities.Student(branchcode,countrycode).tolist();
//db change code
var t1= dbcontext.entities.Student(branchcode,countryclde).tolist();

IEnumerable<string> differenceQuery =  
          t1.Except(t2);

if not it is better to first override the equals method or change your linq query in order to be more precise.

Another example can be found in :
How to: Find the Set Difference Between Two Lists (LINQ) (C#)

Go here more complex example.

If this did not solve your problem then please leave a comment and I will assist you by improving my solution until your problem gets solved.

Cheers,
AH

Slacker007 · Answer 2 · 2018-11-14T01:33:00

This is something I have used in the past to compare two entities, regardless of database, as long as they have the same column names and table names.

It returns the columns with values that are different (i.e. old vs. new values)

Note: plenty of examples of this on the internet, with different variation, etc.

C#

 public static List<PropertyInfo> CompareTo<T>(this T entityA, T entityB ) where T : class 
{
    var propertyInfoDifferences = new  List<PropertyInfo>();

    if(entityA == null || entityB == null) return propertyInfoDifferences;
    if (entityA.GetType().Name != entityB.GetType().Name) return propertyInfoDifferences;

    var properties = entityA.GetType().GetProperties();

    foreach (var propertyInfo in properties)
    {
        if (propertyInfo == null) continue;

        var entityAProperty = entityA.GetType().GetProperty(propertyInfo.Name);
        var entityBProperty = entityB.GetType().GetProperty(propertyInfo.Name);

        if(entityAProperty == null || entityBProperty == null) continue;

        var entityAPropertyValue = entityAProperty.GetValue(entityA);
        var entityBPropertyValue = entityBProperty.GetValue(entityB);

        if (entityAPropertyValue == null && entityBPropertyValue == null) continue;

        string entityAStringValue = null;
        string entityBStringValue = null;

        if (entityAPropertyValue != null)
        {
            entityAStringValue = entityAPropertyValue.ToString();
        }

        if (entityBPropertyValue != null)
        {
            entityBStringValue = entityBPropertyValue.ToString();
        }

        if (entityAStringValue != entityBStringValue)
        {
            propertyInfoDifferences.Add(propertyInfo);
        }
    }

    return propertyInfoDifferences;
}

Implementation could be something like this:

C#

List<PropertyInfo> propertyDiffs = entityA.CompareTo(entityB);

How to compare datatable in entity C#?

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0