SqlBulkCopy.ColumnOrderHints Property
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
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.SqlBulkCopyColumnOrderHintCollectionPublic ReadOnly Property ColumnOrderHints As SqlBulkCopyColumnOrderHintCollectionProperty 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.