SqlBulkCopyColumnMappingCollection.cs 5.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164
  1. //------------------------------------------------------------------------------
  2. // <copyright file="SqlBulkCopyMappingCollection.cs" company="Microsoft">
  3. // Copyright (c) Microsoft Corporation. All rights reserved.
  4. // </copyright>
  5. // <owner current="true" primary="true">[....]</owner>
  6. // <owner current="true" primary="false">[....]</owner>
  7. //------------------------------------------------------------------------------
  8. // todo: rename the file
  9. // Caution! ndp\fx\src\data\netmodule\sources needs to follow this name change
  10. namespace System.Data.SqlClient
  11. {
  12. using System;
  13. using System.Data;
  14. using System.Data.Common;
  15. using System.ComponentModel;
  16. using System.Collections;
  17. using System.Diagnostics;
  18. public sealed class SqlBulkCopyColumnMappingCollection : CollectionBase {
  19. private enum MappingSchema {
  20. Undefined = 0,
  21. NamesNames = 1,
  22. NemesOrdinals = 2,
  23. OrdinalsNames = 3,
  24. OrdinalsOrdinals = 4,
  25. }
  26. private bool _readOnly;
  27. private MappingSchema _mappingSchema = MappingSchema.Undefined;
  28. internal SqlBulkCopyColumnMappingCollection() {
  29. }
  30. public SqlBulkCopyColumnMapping this [int index] {
  31. get {
  32. return (SqlBulkCopyColumnMapping)this.List[index];
  33. }
  34. }
  35. internal bool ReadOnly {
  36. get {
  37. return _readOnly;
  38. }
  39. set {
  40. _readOnly = value;
  41. }
  42. }
  43. public SqlBulkCopyColumnMapping Add(SqlBulkCopyColumnMapping bulkCopyColumnMapping) {
  44. AssertWriteAccess();
  45. Debug.Assert(ADP.IsEmpty(bulkCopyColumnMapping.SourceColumn) || bulkCopyColumnMapping._internalSourceColumnOrdinal == -1, "BulkLoadAmbigousSourceColumn");
  46. if (((ADP.IsEmpty(bulkCopyColumnMapping.SourceColumn)) && (bulkCopyColumnMapping.SourceOrdinal == -1))
  47. || ((ADP.IsEmpty(bulkCopyColumnMapping.DestinationColumn))&&(bulkCopyColumnMapping.DestinationOrdinal == -1))) {
  48. throw SQL.BulkLoadNonMatchingColumnMapping();
  49. }
  50. InnerList.Add(bulkCopyColumnMapping);
  51. return bulkCopyColumnMapping;
  52. }
  53. public SqlBulkCopyColumnMapping Add(string sourceColumn, string destinationColumn) {
  54. AssertWriteAccess();
  55. SqlBulkCopyColumnMapping column = new SqlBulkCopyColumnMapping (sourceColumn, destinationColumn);
  56. return Add(column);
  57. }
  58. public SqlBulkCopyColumnMapping Add(int sourceColumnIndex, string destinationColumn) {
  59. AssertWriteAccess();
  60. SqlBulkCopyColumnMapping column = new SqlBulkCopyColumnMapping (sourceColumnIndex, destinationColumn);
  61. return Add(column);
  62. }
  63. public SqlBulkCopyColumnMapping Add(string sourceColumn, int destinationColumnIndex) {
  64. AssertWriteAccess();
  65. SqlBulkCopyColumnMapping column = new SqlBulkCopyColumnMapping (sourceColumn, destinationColumnIndex);
  66. return Add(column);
  67. }
  68. public SqlBulkCopyColumnMapping Add(int sourceColumnIndex, int destinationColumnIndex) {
  69. AssertWriteAccess();
  70. SqlBulkCopyColumnMapping column = new SqlBulkCopyColumnMapping (sourceColumnIndex, destinationColumnIndex);
  71. return Add(column);
  72. }
  73. private void AssertWriteAccess () {
  74. if (ReadOnly) {
  75. throw SQL.BulkLoadMappingInaccessible();
  76. }
  77. }
  78. new public void Clear() {
  79. AssertWriteAccess();
  80. base.Clear();
  81. }
  82. public bool Contains(SqlBulkCopyColumnMapping value) {
  83. return (-1 != InnerList.IndexOf(value));
  84. }
  85. public void CopyTo(SqlBulkCopyColumnMapping[] array, int index) {
  86. InnerList.CopyTo(array, index);
  87. }
  88. internal void CreateDefaultMapping (int columnCount) {
  89. for (int i=0; i<columnCount; i++) {
  90. InnerList.Add(new SqlBulkCopyColumnMapping (i,i));
  91. }
  92. }
  93. public int IndexOf(SqlBulkCopyColumnMapping value) {
  94. return InnerList.IndexOf(value);
  95. }
  96. public void Insert(int index, SqlBulkCopyColumnMapping value) {
  97. AssertWriteAccess();
  98. InnerList.Insert(index, value);
  99. }
  100. public void Remove(SqlBulkCopyColumnMapping value) {
  101. AssertWriteAccess();
  102. InnerList.Remove(value);
  103. }
  104. new public void RemoveAt(int index) {
  105. AssertWriteAccess();
  106. base.RemoveAt(index);
  107. }
  108. internal void ValidateCollection () {
  109. MappingSchema mappingSchema;
  110. foreach (SqlBulkCopyColumnMapping a in this) {
  111. if (a.SourceOrdinal != -1) {
  112. if(a.DestinationOrdinal != -1) {
  113. mappingSchema = MappingSchema.OrdinalsOrdinals;
  114. }
  115. else {
  116. mappingSchema = MappingSchema.OrdinalsNames;
  117. }
  118. }
  119. else {
  120. if(a.DestinationOrdinal != -1) {
  121. mappingSchema = MappingSchema.NemesOrdinals;
  122. }
  123. else {
  124. mappingSchema = MappingSchema.NamesNames;
  125. }
  126. }
  127. if (_mappingSchema == MappingSchema.Undefined) {
  128. _mappingSchema = mappingSchema;
  129. }
  130. else {
  131. if (_mappingSchema != mappingSchema) {
  132. throw SQL.BulkLoadMappingsNamesOrOrdinalsOnly();
  133. }
  134. }
  135. }
  136. }
  137. }
  138. }