2 // System.Data.Common.DataTableMapping.cs
5 // Rodrigo Moya (rodrigo@ximian.com)
6 // Tim Coleman (tim@timcoleman.com)
9 // Copyright (C) Tim Coleman, 2002-2003
13 // Copyright (C) 2004 Novell, Inc (http://www.novell.com)
15 // Permission is hereby granted, free of charge, to any person obtaining
16 // a copy of this software and associated documentation files (the
17 // "Software"), to deal in the Software without restriction, including
18 // without limitation the rights to use, copy, modify, merge, publish,
19 // distribute, sublicense, and/or sell copies of the Software, and to
20 // permit persons to whom the Software is furnished to do so, subject to
21 // the following conditions:
23 // The above copyright notice and this permission notice shall be
24 // included in all copies or substantial portions of the Software.
26 // THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
27 // EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
28 // MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
29 // NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE
30 // LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
31 // OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION
32 // WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
35 using System.ComponentModel;
38 namespace System.Data.Common {
40 [TypeConverterAttribute ("System.Data.Common.DataTableMapping+DataTableMappingConverter, " + Consts.AssemblySystem_Data)]
42 [TypeConverterAttribute (typeof (DataTableMappingConverter))]
44 public sealed class DataTableMapping : MarshalByRefObject, ITableMapping, ICloneable
50 DataColumnMappingCollection columnMappings;
56 public DataTableMapping ()
58 dataSetTable = String.Empty;
59 sourceTable = String.Empty;
60 columnMappings = new DataColumnMappingCollection ();
63 public DataTableMapping (string sourceTable, string dataSetTable)
66 this.sourceTable = sourceTable;
67 this.dataSetTable = dataSetTable;
70 public DataTableMapping (string sourceTable, string dataSetTable, DataColumnMapping[] columnMappings)
71 : this (sourceTable, dataSetTable)
73 this.columnMappings.AddRange (columnMappings);
76 #endregion // Constructors
81 [DataSysDescription ("Individual columns mappings when this table mapping is matched.")]
83 [DesignerSerializationVisibility (DesignerSerializationVisibility.Content)]
84 public DataColumnMappingCollection ColumnMappings {
85 get { return columnMappings; }
89 [DataSysDescription ("DataTable.TableName")]
92 public string DataSetTable {
93 get { return dataSetTable; }
94 set { dataSetTable = value; }
97 IColumnMappingCollection ITableMapping.ColumnMappings {
98 get { return ColumnMappings; }
102 [DataSysDescription ("The DataTableMapping source table name. This name is case sensitive.")]
105 public string SourceTable {
106 get { return sourceTable; }
107 set { sourceTable = value; }
110 #endregion // Properties
114 [EditorBrowsable (EditorBrowsableState.Advanced)]
115 public DataColumnMapping GetColumnMappingBySchemaAction (string sourceColumn, MissingMappingAction mappingAction)
117 return DataColumnMappingCollection.GetColumnMappingBySchemaAction (columnMappings, sourceColumn, mappingAction);
122 [EditorBrowsable (EditorBrowsableState.Advanced)]
123 public DataColumn GetDataColumn (string sourceColumn,
126 MissingMappingAction mappingAction,
127 MissingSchemaAction schemaAction)
129 throw new NotImplementedException ();
133 [EditorBrowsable (EditorBrowsableState.Advanced)]
134 public DataTable GetDataTableBySchemaAction (DataSet dataSet, MissingSchemaAction schemaAction)
136 if (dataSet.Tables.Contains (DataSetTable))
137 return dataSet.Tables [DataSetTable];
138 if (schemaAction == MissingSchemaAction.Ignore)
140 if (schemaAction == MissingSchemaAction.Error)
141 throw new InvalidOperationException (String.Format ("Missing the '{0} DataTable for the '{1}' SourceTable", DataSetTable, SourceTable));
142 return new DataTable (DataSetTable);
145 object ICloneable.Clone ()
147 DataColumnMapping [] arr = new DataColumnMapping [columnMappings.Count];
148 columnMappings.CopyTo (arr, 0);
149 return new DataTableMapping (SourceTable, DataSetTable, arr);
152 public override string ToString ()
157 #endregion // Methods