Question

What is the meaning of bc.Sqlrowscopied += (sender, eventargs) => { console.Writeline(eventargs.Rowscopied + " loaded ...."); };

Answer 1

The following console application demonstrates how to bulk load data using a connection that is already open. The NotifyAfter property is set so that the event handler is called after every 50 rows copied to the table.

In this example, the connection is first used to read data from a SQL Server table to a SqlDataReader instance. Note that the source data does not have to be located on SQL Server; you can use any data source that can be read to an IDataReader or loaded to a DataTable.