Any way to SQLBulkCopy “insert or update if exists”?

by

I published a nuget package (SqlBulkTools) to solve this problem.

Here’s a code example that would achieve a bulk upsert. 

var bulk = new BulkOperations();
var books = GetBooks();

using (TransactionScope trans = new TransactionScope())
{
    using (SqlConnection conn = new SqlConnection(ConfigurationManager
    .ConnectionStrings["SqlBulkToolsTest"].ConnectionString))
    {
        bulk.Setup<Book>()
            .ForCollection(books)
            .WithTable("Books")
            .AddAllColumns()
            .BulkInsertOrUpdate()
            .MatchTargetOn(x => x.ISBN)
            .Commit(conn);
    }

    trans.Complete();
}

For very large tables, there are options to add table locks and temporarily disable non-clustered indexes. See SqlBulkTools Documentation for more examples.

More Related Contents:

  1. How can I round a value in SQL
  2. How do I update a value in C# and SQL Server? [closed]
  3. SQL Server Char/VarChar DateTime Error [closed]
  4. How to get last inserted id?
  5. What are the pros and cons to keeping SQL in Stored Procs versus Code [closed]
  6. Execute Insert command and return inserted Id in Sql
  7. Adding multiple parameterized variables to a database in c#
  8. SQL Query slow in .NET application but instantaneous in SQL Server Management Studio
  9. What represents a double in sql server?
  10. SQL WHERE clause matching values with trailing spaces
  11. SqlBulkCopy from a List
  12. Get an IDataReader from a typed List
  13. Code to validate SQL Scripts
  14. What’s the fastest way to bulk insert a lot of data in SQL Server (C# client)
  15. SqlConnection.Close() inside using statement
  16. Generate class from database table
  17. ExecuteNonQuery returning -1 when using sql COUNT despite the query string
  18. SqlBulkCopy Insert with Identity Column
  19. What is passing parameters to SQL and why do I need it?
  20. The variable name ‘@’ has already been declared. Variable names must be unique within a query batch or stored procedure
  21. Sql Bulk Copy/Insert in C#
  22. Add WHERE clauses to SQL dynamically / programmatically
  23. How to pass string array in SQL parameter to IN clause in SQL
  24. Is it better to execute many sql commands with one connection, or reconnect every time?
  25. Query validation using C#
  26. SQL Server: Dynamic where-clause
  27. Mapping columns in a DataTable to a SQL table with SqlBulkCopy
  28. Database Error: There is no row at position 0
  29. How to give ADO.NET Parameters
  30. Capturing count from an SQL query

Leave a Comment