Tortuga.Chain Namespace
Tortuga.Chain.CommandBuilders Namespace
Tortuga.Chain.Metadata Namespace

SqlServerInsertBulk..::..WithStreaming Method

Enables streaming.

Namespace:  Tortuga.Chain.SqlServer.CommandBuilders
Assembly:  Tortuga.Chain.SqlServer.MDS (in Tortuga.Chain.SqlServer.MDS.dll)

Syntax


public SqlServerInsertBulk WithStreaming()
Public Function WithStreaming As SqlServerInsertBulk
public:
SqlServerInsertBulk^ WithStreaming()

Return Value

SqlServerInsertBulk.

Remarks


When EnableStreaming is true, SqlBulkCopy reads from an IDataReader object using SequentialAccess, optimizing memory usage by using the IDataReader streaming capabilities. When it’s set to false, the SqlBulkCopy class loads all the data returned by the IDataReader object into memory before sending it to SQL Server or SQL Azure.