Best way to Bulk Insert from a C# DataTable

by

If using SQL Server, SqlBulkCopy.WriteToServer(DataTable)

Or also with SQL Server, you can write it to a .csv and use BULK INSERT

If using MySQL, you could write it to a .csv and use LOAD DATA INFILE

If using Oracle, you can use the array binding feature of ODP.NET

If SQLite:

More Related Contents:

  1. Sorting Win Form CheckListbox [closed]
  2. How to detect Windows 64-bit platform with .NET?
  3. How do I get and set Environment variables in C#?
  4. Compression/Decompression string with C#
  5. How to create a simple proxy in C#?
  6. two different DLL with same namespace
  7. datetime.parse and making it work with a specific format
  8. Editing dictionary values in a foreach loop
  9. How to call a VBScript file in a C# application?
  10. Convert bitmaps to one multipage TIFF image in .NET 2.0
  11. How can I create an instance of an arbitrary Array type at runtime?
  12. Best method to obfuscate or secure .Net assemblies [closed]
  13. Compare two Lists for differences
  14. How should you diagnose the error SEHException – External component has thrown an exception
  15. Determine number of pages in a PDF file [closed]
  16. System.ValueType Understanding
  17. How to remove an xml element from file?
  18. How to make my Windows Form app snap to screen edges?
  19. Registry Watcher C#
  20. DataTable to JSON [duplicate]
  21. Difference between the System.Array.CopyTo() and System.Array.Clone()
  22. ClickOnce and IsolatedStorage
  23. Can I use extension methods and LINQ in .NET 2.0 or 3.0?
  24. Reading dll.config (not app.config!) from a plugin module
  25. How to get xpath from an XmlNode instance
  26. Combine Multiple Predicates
  27. How does the “Using” statement translate from C# to VB?
  28. How to get efficient Sql Server deadlock handling in C# with ADO?
  29. “Could not load file or assembly System.Drawing or one of its dependencies” error on .Net 2.0, VS2010 and Windows 8
  30. what’s the use of string.Clone()?

Leave a Comment