SqlBulkCopyColumnMapping.cs 4.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147
  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. #if NET_2_0
  30. namespace System.Data.SqlClient
  31. {
  32. /// <summary>
  33. /// Class that defines the mapping between a column in the destination table and an
  34. /// column in the datasource of SqlBulkCopy's instance
  35. /// </summary>
  36. public sealed class SqlBulkCopyColumnMapping {
  37. #region Fields
  38. int sourceOrdinal = 0;
  39. int destinationOrdinal = 0;
  40. string sourceColumn = null;
  41. string destinationColumn = null;
  42. #endregion //Fields
  43. #region Constructors
  44. public SqlBulkCopyColumnMapping(){
  45. }
  46. public SqlBulkCopyColumnMapping(int sourceColumnOrdinal, int destinationOrdinal){
  47. this.sourceOrdinal = sourceColumnOrdinal;
  48. this.destinationOrdinal = destinationOrdinal;
  49. }
  50. public SqlBulkCopyColumnMapping(int sourceColumnOrdinal, string destinationColumn){
  51. this.sourceOrdinal = sourceColumnOrdinal;
  52. this.destinationColumn = destinationColumn;
  53. }
  54. public SqlBulkCopyColumnMapping(string sourceColumn, int destinationOrdinal){
  55. this.sourceColumn = sourceColumn;
  56. this.destinationOrdinal = destinationOrdinal;
  57. }
  58. public SqlBulkCopyColumnMapping(string sourceColumn, string destinationColumn){
  59. this.sourceColumn = sourceColumn;
  60. this.destinationColumn = destinationColumn;
  61. }
  62. # endregion //Constructors
  63. # region Properties
  64. public String DestinationColumn {
  65. get {
  66. if (this.destinationColumn != null)
  67. return destinationColumn;
  68. else
  69. return string.Empty; //ms:doesnot return null.
  70. }
  71. set {
  72. // ms: whenever the name is set the ordinal is reset to -1
  73. this.destinationOrdinal = -1;
  74. this.destinationColumn = value;
  75. }
  76. }
  77. public String SourceColumn {
  78. get {
  79. if (this.sourceColumn != null)
  80. return sourceColumn;
  81. else
  82. return string.Empty;//ms doesnot return null
  83. }
  84. set {
  85. // ms: whenever the name is set the ordinal is reset to -1
  86. this.sourceOrdinal = -1;
  87. this.sourceColumn = value;
  88. }
  89. }
  90. public int DestinationOrdinal {
  91. get {
  92. return this.destinationOrdinal;
  93. }
  94. set {
  95. // ms: whenever the ordinal is set, the name is null
  96. if (value < 0)
  97. throw new ArgumentOutOfRangeException();
  98. this.destinationColumn = null;
  99. this.destinationOrdinal = value;
  100. }
  101. }
  102. public int SourceOrdinal {
  103. get {
  104. return this.sourceOrdinal;
  105. }
  106. set {
  107. // ms: whenever the ordinal is set, the name is null
  108. if (value < 0)
  109. throw new ArgumentOutOfRangeException();
  110. this.sourceColumn = null;
  111. this.sourceOrdinal = value;
  112. }
  113. }
  114. #endregion //Properties
  115. }
  116. }
  117. #endif