I am trying to insert data into a table with a primary key having default value of newsequentialid() using SqlBulkCopy.
Prior to insert the data by examining DataReader object I see that all PK values are Guid.Empty(represented by 0000-000…) .
However when I try insert the data the SQlBulkCopy tries to insert PK with Guid.Empty values and I get unique identifier conflicts for PK column.
Is there a way to exclude Pk from insert or tell SQLBulkCopy not insert data in column with UniqueIdentifier property? I have tried all SqlBulkCopyOptions Enumerations with no success.