SqlBulkCopyColumnMapping.cs 4.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136
  1. //
  2. // System.Data.SqlClient.SqlBulkCopyColumnMapping.cs
  3. //
  4. // Author:
  5. // Umadevi S <[email protected]>
  6. //
  7. //
  8. // Copyright (C) 2004 Novell, Inc (http://www.novell.com)
  9. //
  10. // Permission is hereby granted, free of charge, to any person obtaining
  11. // a copy of this software and associated documentation files (the
  12. // "Software"), to deal in the Software without restriction, including
  13. // without limitation the rights to use, copy, modify, merge, publish,
  14. // distribute, sublicense, and/or sell copies of the Software, and to
  15. // permit persons to whom the Software is furnished to do so, subject to
  16. // the following conditions:
  17. //
  18. // The above copyright notice and this permission notice shall be
  19. // included in all copies or substantial portions of the Software.
  20. //
  21. // THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
  22. // EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
  23. // MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
  24. // NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE
  25. // LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
  26. // OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION
  27. // WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
  28. //
  29. namespace System.Data.SqlClient
  30. {
  31. /// <summary>
  32. /// Class that defines the mapping between a column in the destination table and an
  33. /// column in the datasource of SqlBulkCopy's instance
  34. /// </summary>
  35. public sealed class SqlBulkCopyColumnMapping {
  36. #region Fields
  37. int sourceOrdinal = -1;
  38. int destinationOrdinal = -1;
  39. string sourceColumn = null;
  40. string destinationColumn = null;
  41. #endregion //Fields
  42. #region Constructors
  43. public SqlBulkCopyColumnMapping() {
  44. }
  45. public SqlBulkCopyColumnMapping(int sourceColumnOrdinal, int destinationOrdinal){
  46. SourceOrdinal = sourceColumnOrdinal;
  47. DestinationOrdinal = destinationOrdinal;
  48. }
  49. public SqlBulkCopyColumnMapping(int sourceColumnOrdinal, string destinationColumn){
  50. SourceOrdinal = sourceColumnOrdinal;
  51. DestinationColumn = destinationColumn;
  52. }
  53. public SqlBulkCopyColumnMapping(string sourceColumn, int destinationOrdinal){
  54. SourceColumn = sourceColumn;
  55. DestinationOrdinal = destinationOrdinal;
  56. }
  57. public SqlBulkCopyColumnMapping(string sourceColumn, string destinationColumn){
  58. SourceColumn = sourceColumn;
  59. DestinationColumn = destinationColumn;
  60. }
  61. # endregion //Constructors
  62. # region Properties
  63. public String DestinationColumn {
  64. get {
  65. if (this.destinationColumn != null)
  66. return destinationColumn;
  67. else
  68. return string.Empty; //ms:doesnot return null.
  69. }
  70. set {
  71. // ms: whenever the name is set the ordinal is reset to -1
  72. this.destinationOrdinal = -1;
  73. this.destinationColumn = value;
  74. }
  75. }
  76. public String SourceColumn {
  77. get {
  78. if (this.sourceColumn != null)
  79. return sourceColumn;
  80. else
  81. return string.Empty;//ms doesnot return null
  82. }
  83. set {
  84. // ms: whenever the name is set the ordinal is reset to -1
  85. this.sourceOrdinal = -1;
  86. this.sourceColumn = value;
  87. }
  88. }
  89. public int DestinationOrdinal {
  90. get {
  91. return this.destinationOrdinal;
  92. }
  93. set {
  94. // ms: whenever the ordinal is set, the name is null
  95. if (value < 0)
  96. throw new IndexOutOfRangeException ();
  97. this.destinationColumn = null;
  98. this.destinationOrdinal = value;
  99. }
  100. }
  101. public int SourceOrdinal {
  102. get {
  103. return this.sourceOrdinal;
  104. }
  105. set {
  106. // ms: whenever the ordinal is set, the name is null
  107. if (value < 0)
  108. throw new IndexOutOfRangeException ();
  109. this.sourceColumn = null;
  110. this.sourceOrdinal = value;
  111. }
  112. }
  113. #endregion //Properties
  114. }
  115. }