using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); using (SqlBulkCopy bulkCopy = new SqlBulkCopy(connection)) { bulkCopy.DestinationTableName = "MyTable"; using (StreamReader reader = new StreamReader(filePath)) { using (CsvReader csv = new CsvReader(reader, CultureInfo.InvariantCulture)) { DataTable dataTable = new DataTable(); dataTable.Load(csv.Reader); bulkCopy.WriteToServer(dataTable); } } } }
using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); using (SqlBulkCopy bulkCopy = new SqlBulkCopy(connection)) { bulkCopy.DestinationTableName = "DestinationTable"; bulkCopy.EnableStreaming = true; bulkCopy.SqlRowsCopied += (sender, e) => Console.WriteLine("{0} rows copied", e.RowsCopied); using (SqlCommand command = new SqlCommand("SELECT * FROM SourceTable;", connection)) { using (SqlDataReader reader = command.ExecuteReader()) { bulkCopy.WriteToServer(reader); } } } }These examples use the System.Data.SqlClient package library.