SqlBulkCopy Tutorial - Knowledge Base (KB)

How does SqlBulkCopy circumnavigate foreign key constraints?

I used SqlBulkCopy to insert a collection of rows into a table. I forgot to set an integer value on the rows. The missing column is used to reference another table and this is enforced with a foreign key constraint....For every row inserted, the final int...

Foreign key column allows 0 in SQL Server from bulk insert

I have a column that checks FK constraints on a column and allows NULL. However, it is allowing 0 as a value even though there is no row for ID of 0 in the primary table. ...This insert happens on a bulk insert with .NET. However, if I change the value t...