scarpacci

Hi Gurus, A colleague and I have a process where we want to look at a file we receive from a vendor (XML) and data that is in our db. In order to bypass loading the xml and comparing it once loaded we are loading the db data and xml …

As sknake pointed out it really depends on the amount of data you are dealing with and what platform you are comfortable with. You could pull both data sources into datasets and use LINQ or some other C# method to figure out what does or doesn't exist and insert accordingly. …