SqlBulkCopy Tutorial SqlBulkCopy - WriteToServer

using (SqlBulkCopy bulkCopy = new SqlBulkCopy(connectionString))
{
    bulkCopy.DestinationTableName = "TheDestinationTable";
    
    // CALL WriteToServer method.
    bulkCopy.WriteToServer(dt);
}

using (var sqlBulk = new SqlBulkCopy(connection))
{
    // Make a change to one of the rows in the DataTable.
    DataRow row = dt.Rows[0];
    row.BeginEdit();
    row["Name"] = "AAA";
    row.EndEdit();
    sqlBulk.DestinationTableName = "Customers";
    
    // CALL WriteToServer method.
    sqlBulk.WriteToServer(dt, DataRowState.Unchanged);
}

using (var connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServer()))
{
    connection.Open();

    // Get data from the source table as a SqlDataReader.
    SqlCommand commandSourceData = new SqlCommand(
        "SELECT * FROM Customers_Archive;", connection);

    SqlDataReader reader =
        commandSourceData.ExecuteReader();

    using (var dConnection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServer()))
    {
        dConnection.Open();
        using (var sqlBulk = new SqlBulkCopy(dConnection))
        {
            sqlBulk.DestinationTableName = "Customers";
            try
            {
                // Write from the source to the destination.
                sqlBulk.WriteToServer(reader);
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
            }
            finally
            {
                reader.Close();
            }
        }
    }
}

using (var sqlBulk = new SqlBulkCopy(connection))
{
    DataRow[] dataRows = dt.Select();
    sqlBulk.DestinationTableName = "Customers";
    
    // CALL WriteToServer method.
    sqlBulk.WriteToServer(dataRows);
}