| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147 |
- //
- // System.Data.SqlClient.SqlBulkCopyColumnMapping.cs
- //
- // Author:
- // Umadevi S <[email protected]>
- //
- //
- // Copyright (C) 2004 Novell, Inc (http://www.novell.com)
- //
- // Permission is hereby granted, free of charge, to any person obtaining
- // a copy of this software and associated documentation files (the
- // "Software"), to deal in the Software without restriction, including
- // without limitation the rights to use, copy, modify, merge, publish,
- // distribute, sublicense, and/or sell copies of the Software, and to
- // permit persons to whom the Software is furnished to do so, subject to
- // the following conditions:
- //
- // The above copyright notice and this permission notice shall be
- // included in all copies or substantial portions of the Software.
- //
- // THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
- // EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
- // MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
- // NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE
- // LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
- // OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION
- // WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
- //
- #if NET_2_0
- namespace System.Data.SqlClient
- {
- /// <summary>
- /// Class that defines the mapping between a column in the destination table and an
- /// column in the datasource of SqlBulkCopy's instance
- /// </summary>
-
- public sealed class SqlBulkCopyColumnMapping {
- #region Fields
-
- int sourceOrdinal = 0;
- int destinationOrdinal = 0;
- string sourceColumn = null;
- string destinationColumn = null;
- #endregion //Fields
- #region Constructors
-
- public SqlBulkCopyColumnMapping(){
-
- }
-
- public SqlBulkCopyColumnMapping(int sourceColumnOrdinal, int destinationOrdinal){
- this.sourceOrdinal = sourceColumnOrdinal;
- this.destinationOrdinal = destinationOrdinal;
- }
- public SqlBulkCopyColumnMapping(int sourceColumnOrdinal, string destinationColumn){
- this.sourceOrdinal = sourceColumnOrdinal;
- this.destinationColumn = destinationColumn;
- }
- public SqlBulkCopyColumnMapping(string sourceColumn, int destinationOrdinal){
- this.sourceColumn = sourceColumn;
- this.destinationOrdinal = destinationOrdinal;
- }
- public SqlBulkCopyColumnMapping(string sourceColumn, string destinationColumn){
- this.sourceColumn = sourceColumn;
- this.destinationColumn = destinationColumn;
- }
- # endregion //Constructors
- # region Properties
-
- public String DestinationColumn {
- get {
- if (this.destinationColumn != null)
- return destinationColumn;
- else
- return string.Empty; //ms:doesnot return null.
- }
- set {
- // ms: whenever the name is set the ordinal is reset to -1
- this.destinationOrdinal = -1;
- this.destinationColumn = value;
- }
- }
-
- public String SourceColumn {
- get {
- if (this.sourceColumn != null)
- return sourceColumn;
- else
- return string.Empty;//ms doesnot return null
- }
- set {
- // ms: whenever the name is set the ordinal is reset to -1
- this.sourceOrdinal = -1;
- this.sourceColumn = value;
- }
-
- }
- public int DestinationOrdinal {
- get {
- return this.destinationOrdinal;
- }
- set {
- // ms: whenever the ordinal is set, the name is null
- if (value < 0)
- throw new ArgumentOutOfRangeException();
- this.destinationColumn = null;
- this.destinationOrdinal = value;
- }
-
- }
-
- public int SourceOrdinal {
- get {
- return this.sourceOrdinal;
- }
- set {
- // ms: whenever the ordinal is set, the name is null
- if (value < 0)
- throw new ArgumentOutOfRangeException();
- this.sourceColumn = null;
- this.sourceOrdinal = value;
- }
-
- }
- #endregion //Properties
-
- }
- }
- #endif
|