How can I use SqlBulkCopy to avoid inserting duplicates?

When there is no primary key, how can SqlBulkCopy prevent duplicate entries from being inserted?

I'd upload the data into a staging table then deal with duplicates afterwards on copy to the final table....For example, you can create a (non-unique) index on the staging table to deal with the "key"

How can I put data into a table in a non-default database schema using SqlBulkCopy?

I need to insert data into a table in a schema named ...Staging... using ...SqlBulkCopy.......It appears the API only allows you to set the target table name by using the ...DestinationTableName... property....How do I accomplish this? Is it possible?

ASP.Net SqlBulkCopy is used to insert a constant value into a column.

I assume your ...dr... is a reader of some kind. How is it populated? It may be possible to select a default value into a column and map ...that.... Something like this (sql syntax)...select EXCELCOLUMN1, EXCELCOLUMN2, 'ConstantValueFromPage' as EXCELCUSTOM from sheet1 ...Then have:...bulkCopy.ColumnMappings.Add("TABLECOLUMN...

When using SqlBulkCopy to insert into a sql variant column, how do I specify the column type?

I'm using SqlBulkCopy to insert/update from a .net DataTable object to a SQL Server table that includes a sql_variant column. However SqlBulkCopy insists on storing DateTime values put into that column as sql type 'datetime' when what I need is 'datetime2'. ...My DataTable is defined like this:...DataTable dataTable = new DataTable(); dataTable.C...

Inserting unique id for file uploaded to database using SqlBulkCopy

That depends. if ...ProdID... is an ...identity... field in the database, the database will fill it for you when you perform the bulk copy....If it's not, you will need to fill it yourself and pass the three columns to ...SqlBulkCopy..., instead of just the two.

How to get auto-increment values after inserting records using SqlBulkCopy via c#

I am using ...SqlBulkCopy... class to insert bulk records but i want that newly generated ...auto-increment... values(primary key plays Foreign key in child table) because with the help of that values i am going to play with child tables(Foreign key) making insert....Please follow the below example to get the clear picture,...Source table: Create t...

Precision Lost while Bulk Inserting records into SQL using SqlBulkCopy

Make the column in the ...DataTable... as ...decimal... rather than ...double...… I strongly suspect this will make the problem disappear.

Insert Dictionary elements into SQL table as rows using IDatareader and SqlBulkCopy

I need to improve dramatically the execution time of a process wich currently is just like this:...private Dictionary<int, SingleElement> elements_buffer; // ... Create and load values into "elements_buffer" // (string, Datetime, double) string query = "INSERT INTO Tests.dbo.test_table " + "(element_name,element_init,element_width) VALUES"; ...

How Can i Validate datatable's Data before inserting it using SqlBulkCopy

I'm importing 3 thousands rows from Excel Sheet using ExcelDataReader to Datatable....How can i validate these rows before inserting them into database using SqlBulkCopy.Writetoserver()....Questions:...1.... How to compare my datatable to the TableScheme of one of the SQL Server Tables....2.... Can i Validate FK Constraints and PK Duplications befo...

SqlBulkCopy inserts when inside a transaction prevents any other writes on a table

In my web app users can insert lots of data at once, to improve performance I am using the SqlBulkCopy class. It runs multiple times for a single operation inserting into two different tables. If the user cancels the operation or it fails then I need the data to roll back so I wrap everything in a transaction using Isolation level Snapshot....It wa...