SqlBulkCopy from a List

by

With FastMember, you can do this without ever needing to go via DataTable (which, in my tests, more-than-doubles the performance):

using(var bcp = new SqlBulkCopy(connection))
using(var reader = ObjectReader.Create(data, "Id", "Name", "Description"))
{
    bcp.DestinationTableName = "SomeTable";
    bcp.WriteToServer(reader);
}

Note that ObjectReader can also work with non-generic sources, and it is not necessary to specify the member-names in advance (although you probably want to use the ColumnMappings aspect of SqlBulkCopy if you don’t specify them in the ObjectReader itself).

More Related Contents:

  1. ExecuteNonQuery returning -1 when using sql COUNT despite the query string
  2. Add WHERE clauses to SQL dynamically / programmatically
  3. How to give ADO.NET Parameters
  4. SQL Server Char/VarChar DateTime Error [closed]
  5. How can I add user-supplied input to an SQL statement?
  6. ExecuteReader requires an open and available Connection. The connection’s current state is Connecting
  7. How to get last inserted id?
  8. What are the pros and cons to keeping SQL in Stored Procs versus Code [closed]
  9. What represents a double in sql server?
  10. SQL WHERE clause matching values with trailing spaces
  11. SqlConnection SqlCommand SqlDataReader IDisposable
  12. How to retrieve data from a SQL Server database in C#?
  13. Use of SqlParameter in SQL LIKE clause not working
  14. Any way to SQLBulkCopy “insert or update if exists”?
  15. How can I retrieve a list of parameters from a stored procedure in SQL Server
  16. Multi threading C# application with SQL Server database calls
  17. What’s the fastest way to bulk insert a lot of data in SQL Server (C# client)
  18. How to keep single SQL Server connection instance open for multiple request in C#?
  19. How to use SqlCommand to CREATE DATABASE with parameterized db name?
  20. Using SqlDataAdapter to insert a row
  21. How to pass string array in SQL parameter to IN clause in SQL
  22. Check if a SQL table exists
  23. Query validation using C#
  24. Unable to connect to localDB in VS2012 – “A network-related or instance-specific error occurred while establishing a connection to SQL Server…”
  25. Why does the SqlParameter name/value constructor treat 0 as null?
  26. How do I connect to a SQL database from C#?
  27. Database Error: There is no row at position 0
  28. Passing array to a SQL Server Stored Procedure
  29. Bulk Insert Sql Server millions of record
  30. Capturing count from an SQL query

Leave a Comment