I'm having trouble writing code in c# as i'm a newbie. This is what I need to do, I've got the psuedo/bsuiness logic in my head but I can't seem to translate this into c# code:
Compare TABLE A with TABLE B, does the ID already exist on table B? If it doesn't, then do an insert (get data from table A and it's related tables) into TABLE C and other tables related to TABLE C. Otherwise, if the Id already exists I have to do the above but do an update instead
NB It's not an option for me just replicate full table data from one destination to another, as I have to get only updated data this is based on some criteria (no dates though!) Also database table comparison tools are not an option.
Please can someone provide me with some code for doing this