Loading

How could I check if those records exists in SQL ?

Abdalla Omran

I have a list which is holidng several properties like date time , url, id and so on

before i import this list into DB i want to check if those records are already existing in DB

// here is the list
GetListofProducts = GetAllProdcuts();
// after that i am importing the list into a DB
ImportIntoDB();
// but before that i want to check if the records in this list are already exist in DB

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Rajanikant Hawaldar6y ago
Accepted answer
https://forums.asp.net/t/1880640.aspx?Prevent+Duplicate+entries+in+SQL+Bulk+Copy