Best way to compare Data in tables
Posted on 2011-09-14
I need to compare Data in a table with new information downloaded from a server.
This means the follwoing:
1. I download data from the webserver.
2. Read the data.
3. Before inserting, compare first. If the data is equal, then skip, if there is a change, then update and store the old value in a different table.
I have about 90 Columns in each table, this means that i dont want to make 90 if else statements.
I am using Linq To SQL
I need a way to do this dynamically.