Share via


SqlBulkCopy.ColumnOrderHints Property

Definition

Returns a collection of SqlBulkCopyColumnOrderHint items. Column order hints describe the sort order of columns in the clustered index of the destination table.

public:
 property Microsoft::Data::SqlClient::SqlBulkCopyColumnOrderHintCollection ^ ColumnOrderHints { Microsoft::Data::SqlClient::SqlBulkCopyColumnOrderHintCollection ^ get(); };
public Microsoft.Data.SqlClient.SqlBulkCopyColumnOrderHintCollection ColumnOrderHints { get; }
member this.ColumnOrderHints : Microsoft.Data.SqlClient.SqlBulkCopyColumnOrderHintCollection
Public ReadOnly Property ColumnOrderHints As SqlBulkCopyColumnOrderHintCollection

Property Value

A collection of column order hints. By default, it is an empty collection.

Remarks

SqlBulkCopy's performance is improved if the data being imported is sorted according to the clustered index on the table, if any. If the data is sorted in an order that differs from the order of a clustered index key or if there is no clustered index on the table, the order hint is ignored.

Applies to