Ignore duplicate record in csv file on sqlbukcopy via c#

Question

i have table that have one column phoneNO primary key i want to upload csv file via sqlbulkcopy i have error that primary key not insert duplicate value so my question is how to ignore row if it's duplicate and other rows inserts in database

Answer 1

This is a multiple step process which addresses duplicates in the csv files and records which already exist within the database.

1. Create temporary table table w/out phoneNumber primary key and add extra fields if necessary
2. Insert all csv files into temporary table via sqlbulkcopy
3. Once all csv files have been inserted into temporary table, perform select distinct with a where conditional making sure all newly inserted values do not already exist in the destination table.

Creating a temporary table

CREATE TABLE TemporaryTable
([phoneNumber] varchar(13));

Perform Select/Distinct with a where clause excluding all records already found within

Insert YourTableName (phoneNumber)
Select distinct phoneNumber
FROM TemporaryTable
WHERE phoneNumber not in (select phoneNumber
                          from YourTableName)