MVC3Entity frameworkwebservicedatabase

Question

I run an interface every day which updates the data in database if the record is present of that employee or else inserts in database if employee is new. My requirement is to check if there's any employee who is no longer coming in that interface. The basic method is after getting response from interface i need to make a call to database to bring all employees present in my database and check the response from interface to find which employee is not coming now in interface. Is there any better method?

Nilesh Shah · Answer

There is: add a new column to employee master table - bit datatype before you start the database update process set all columns to 0 as you get records and update table set the row which you update to 1 after finishing the update check all records with 0 in new columns those are the rows you want.

MVC3,Entity framework,webservice,database