DataTableMapping.cs source code in C# .NET

Source code for the .NET framework in C#

                        
Code:

                         / Dotnetfx_Win7_3.5.1 / Dotnetfx_Win7_3.5.1 / 3.5.1 / DEVDIV / depot / DevDiv / releases / whidbey / NetFXspW7 / ndp / fx / src / Data / System / Data / Common / DataTableMapping.cs / 1 / DataTableMapping.cs
                        

                        
                            //------------------------------------------------------------------------------ 
// 
//      Copyright (c) Microsoft Corporation.  All rights reserved.
// 
// [....] 
// [....]
//----------------------------------------------------------------------------- 
 
namespace System.Data.Common {
 
    using System;
    using System.ComponentModel;
    using System.ComponentModel.Design.Serialization;
    using System.Data; 
    using System.Diagnostics;
    using System.Globalization; 
    using System.Reflection; 

    [ 
    System.ComponentModel.TypeConverterAttribute(typeof(System.Data.Common.DataTableMapping.DataTableMappingConverter))
    ]
#if WINFSInternalOnly
    internal 
#else
    public 
#endif 
    sealed class DataTableMapping : MarshalByRefObject, ITableMapping, ICloneable {
        private DataTableMappingCollection parent; 
        private DataColumnMappingCollection _columnMappings;
        private string _dataSetTableName;
        private string _sourceTableName;
 
        public DataTableMapping() {
        } 
 
        public DataTableMapping(string sourceTable, string dataSetTable) {
            SourceTable = sourceTable; 
            DataSetTable = dataSetTable;
        }

        public DataTableMapping(string sourceTable, string dataSetTable, DataColumnMapping[] columnMappings) { 
            SourceTable = sourceTable;
            DataSetTable = dataSetTable; 
            if ((null != columnMappings) && (0 < columnMappings.Length)) { 
                ColumnMappings.AddRange(columnMappings);
            } 
        }

        // explict ITableMapping implementation
        IColumnMappingCollection ITableMapping.ColumnMappings { 
            get { return ColumnMappings; }
        } 
 
        [
        DesignerSerializationVisibility(DesignerSerializationVisibility.Content), 
        ResCategoryAttribute(Res.DataCategory_Mapping),
        ResDescriptionAttribute(Res.DataTableMapping_ColumnMappings),
        ]
        public DataColumnMappingCollection ColumnMappings { 
            get {
                DataColumnMappingCollection columnMappings = _columnMappings; 
                if (null == columnMappings) { 
                    columnMappings = new DataColumnMappingCollection();
                    _columnMappings = columnMappings; 
                }
                return columnMappings;
            }
        } 

        [ 
        DefaultValue(""), 
        ResCategoryAttribute(Res.DataCategory_Mapping),
        ResDescriptionAttribute(Res.DataTableMapping_DataSetTable), 
        ]
        public string DataSetTable {
            get {
                string dataSetTableName = _dataSetTableName; 
                return ((null != dataSetTableName) ? dataSetTableName : ADP.StrEmpty);
            } 
            set { 
                _dataSetTableName = value;
            } 
        }

        internal DataTableMappingCollection Parent {
            get { 
                return parent;
            } 
            set { 
                parent = value;
            } 
        }

        [
        DefaultValue(""), 
        ResCategoryAttribute(Res.DataCategory_Mapping),
        ResDescriptionAttribute(Res.DataTableMapping_SourceTable), 
        ] 
        public string SourceTable {
            get { 
                string sourceTableName = _sourceTableName;
                return ((null != sourceTableName) ? sourceTableName : ADP.StrEmpty);
            }
            set { 
                if ((null != Parent) && (0 != ADP.SrcCompare(_sourceTableName, value))) {
                    Parent.ValidateSourceTable(-1, value); 
                } 
                _sourceTableName = value;
            } 
        }

        object ICloneable.Clone() {
            DataTableMapping clone = new DataTableMapping(); // MDAC 81448 
            clone._dataSetTableName = _dataSetTableName;
            clone._sourceTableName = _sourceTableName; 
 
            if ((null != _columnMappings) && (0 < ColumnMappings.Count)) {
                DataColumnMappingCollection parameters = clone.ColumnMappings; 
                foreach(ICloneable parameter in ColumnMappings) {
                    parameters.Add(parameter.Clone());
                }
            } 
            return clone;
        } 
 
        [ EditorBrowsableAttribute(EditorBrowsableState.Advanced) ] // MDAC 69508
        public DataColumn GetDataColumn(string sourceColumn, Type dataType, DataTable dataTable, MissingMappingAction mappingAction, MissingSchemaAction schemaAction) { 
            return DataColumnMappingCollection.GetDataColumn(_columnMappings, sourceColumn, dataType, dataTable, mappingAction, schemaAction);
        }

        [ EditorBrowsableAttribute(EditorBrowsableState.Advanced) ] // MDAC 69508 
        public DataColumnMapping GetColumnMappingBySchemaAction(string sourceColumn, MissingMappingAction mappingAction) {
            return DataColumnMappingCollection.GetColumnMappingBySchemaAction(_columnMappings, sourceColumn, mappingAction); 
        } 

        [ EditorBrowsableAttribute(EditorBrowsableState.Advanced) ] // MDAC 69508 
        public DataTable GetDataTableBySchemaAction(DataSet dataSet, MissingSchemaAction schemaAction) {
            if (null == dataSet) {
                throw ADP.ArgumentNull("dataSet");
            } 
            string dataSetTable = DataSetTable;
 
            if (ADP.IsEmpty(dataSetTable)) { 
#if DEBUG
                if (AdapterSwitches.DataSchema.TraceWarning) { 
                    Debug.WriteLine("explicit filtering of SourceTable \"" + SourceTable + "\"");
                }
#endif
                return null; 
            }
            DataTableCollection tables = dataSet.Tables; 
            int index = tables.IndexOf(dataSetTable); 
            if ((0 <= index) && (index < tables.Count)) {
#if DEBUG 
                if (AdapterSwitches.DataSchema.TraceInfo) {
                    Debug.WriteLine("schema match on DataTable \"" + dataSetTable);
                }
#endif 
                return tables[index];
            } 
            switch (schemaAction) { 
                case MissingSchemaAction.Add:
                case MissingSchemaAction.AddWithKey: 
#if DEBUG
                    if (AdapterSwitches.DataSchema.TraceInfo) {
                        Debug.WriteLine("schema add of DataTable \"" + dataSetTable + "\"");
                    } 
#endif
                    return new DataTable(dataSetTable); 
 
                case MissingSchemaAction.Ignore:
#if DEBUG 
                    if (AdapterSwitches.DataSchema.TraceWarning) {
                        Debug.WriteLine("schema filter of DataTable \"" + dataSetTable + "\"");
                    }
#endif 
                    return null;
 
                case MissingSchemaAction.Error: 
#if DEBUG
                    if (AdapterSwitches.DataSchema.TraceError) { 
                        Debug.WriteLine("schema error on DataTable \"" + dataSetTable + "\"");
                    }
#endif
                    throw ADP.MissingTableSchema(dataSetTable, SourceTable); 
            }
            throw ADP.InvalidMissingSchemaAction(schemaAction); 
        } 

        public override String ToString() { 
            return SourceTable;
        }

        sealed internal class DataTableMappingConverter : System.ComponentModel.ExpandableObjectConverter { 

            // converter classes should have public ctor 
            public DataTableMappingConverter() { 
            }
 
            override public bool CanConvertTo(ITypeDescriptorContext context, Type destinationType) {
                if (typeof(InstanceDescriptor) == destinationType) {
                    return true;
                } 
                return base.CanConvertTo(context, destinationType);
            } 
 
            override public object ConvertTo(ITypeDescriptorContext context, CultureInfo culture, object value, Type destinationType) {
                if (null == destinationType) { 
                    throw ADP.ArgumentNull("destinationType");
                }

                if ((typeof(InstanceDescriptor) == destinationType) && (value is DataTableMapping)) { 
                    DataTableMapping mapping = (DataTableMapping)value;
 
                    DataColumnMapping[] columnMappings = new DataColumnMapping[mapping.ColumnMappings.Count]; 
                    mapping.ColumnMappings.CopyTo(columnMappings, 0);
                    object[] values = new object[] { mapping.SourceTable, mapping.DataSetTable, columnMappings}; 
                    Type[] types = new Type[] { typeof(string), typeof(string), typeof(DataColumnMapping[]) };

                    ConstructorInfo ctor = typeof(DataTableMapping).GetConstructor(types);
                    return new InstanceDescriptor(ctor, values); 
                }
                return base.ConvertTo(context, culture, value, destinationType); 
            } 
        }
    } 
}

// File provided for Reference Use Only by Microsoft Corporation (c) 2007.
//------------------------------------------------------------------------------ 
// 
//      Copyright (c) Microsoft Corporation.  All rights reserved.
// 
// [....] 
// [....]
//----------------------------------------------------------------------------- 
 
namespace System.Data.Common {
 
    using System;
    using System.ComponentModel;
    using System.ComponentModel.Design.Serialization;
    using System.Data; 
    using System.Diagnostics;
    using System.Globalization; 
    using System.Reflection; 

    [ 
    System.ComponentModel.TypeConverterAttribute(typeof(System.Data.Common.DataTableMapping.DataTableMappingConverter))
    ]
#if WINFSInternalOnly
    internal 
#else
    public 
#endif 
    sealed class DataTableMapping : MarshalByRefObject, ITableMapping, ICloneable {
        private DataTableMappingCollection parent; 
        private DataColumnMappingCollection _columnMappings;
        private string _dataSetTableName;
        private string _sourceTableName;
 
        public DataTableMapping() {
        } 
 
        public DataTableMapping(string sourceTable, string dataSetTable) {
            SourceTable = sourceTable; 
            DataSetTable = dataSetTable;
        }

        public DataTableMapping(string sourceTable, string dataSetTable, DataColumnMapping[] columnMappings) { 
            SourceTable = sourceTable;
            DataSetTable = dataSetTable; 
            if ((null != columnMappings) && (0 < columnMappings.Length)) { 
                ColumnMappings.AddRange(columnMappings);
            } 
        }

        // explict ITableMapping implementation
        IColumnMappingCollection ITableMapping.ColumnMappings { 
            get { return ColumnMappings; }
        } 
 
        [
        DesignerSerializationVisibility(DesignerSerializationVisibility.Content), 
        ResCategoryAttribute(Res.DataCategory_Mapping),
        ResDescriptionAttribute(Res.DataTableMapping_ColumnMappings),
        ]
        public DataColumnMappingCollection ColumnMappings { 
            get {
                DataColumnMappingCollection columnMappings = _columnMappings; 
                if (null == columnMappings) { 
                    columnMappings = new DataColumnMappingCollection();
                    _columnMappings = columnMappings; 
                }
                return columnMappings;
            }
        } 

        [ 
        DefaultValue(""), 
        ResCategoryAttribute(Res.DataCategory_Mapping),
        ResDescriptionAttribute(Res.DataTableMapping_DataSetTable), 
        ]
        public string DataSetTable {
            get {
                string dataSetTableName = _dataSetTableName; 
                return ((null != dataSetTableName) ? dataSetTableName : ADP.StrEmpty);
            } 
            set { 
                _dataSetTableName = value;
            } 
        }

        internal DataTableMappingCollection Parent {
            get { 
                return parent;
            } 
            set { 
                parent = value;
            } 
        }

        [
        DefaultValue(""), 
        ResCategoryAttribute(Res.DataCategory_Mapping),
        ResDescriptionAttribute(Res.DataTableMapping_SourceTable), 
        ] 
        public string SourceTable {
            get { 
                string sourceTableName = _sourceTableName;
                return ((null != sourceTableName) ? sourceTableName : ADP.StrEmpty);
            }
            set { 
                if ((null != Parent) && (0 != ADP.SrcCompare(_sourceTableName, value))) {
                    Parent.ValidateSourceTable(-1, value); 
                } 
                _sourceTableName = value;
            } 
        }

        object ICloneable.Clone() {
            DataTableMapping clone = new DataTableMapping(); // MDAC 81448 
            clone._dataSetTableName = _dataSetTableName;
            clone._sourceTableName = _sourceTableName; 
 
            if ((null != _columnMappings) && (0 < ColumnMappings.Count)) {
                DataColumnMappingCollection parameters = clone.ColumnMappings; 
                foreach(ICloneable parameter in ColumnMappings) {
                    parameters.Add(parameter.Clone());
                }
            } 
            return clone;
        } 
 
        [ EditorBrowsableAttribute(EditorBrowsableState.Advanced) ] // MDAC 69508
        public DataColumn GetDataColumn(string sourceColumn, Type dataType, DataTable dataTable, MissingMappingAction mappingAction, MissingSchemaAction schemaAction) { 
            return DataColumnMappingCollection.GetDataColumn(_columnMappings, sourceColumn, dataType, dataTable, mappingAction, schemaAction);
        }

        [ EditorBrowsableAttribute(EditorBrowsableState.Advanced) ] // MDAC 69508 
        public DataColumnMapping GetColumnMappingBySchemaAction(string sourceColumn, MissingMappingAction mappingAction) {
            return DataColumnMappingCollection.GetColumnMappingBySchemaAction(_columnMappings, sourceColumn, mappingAction); 
        } 

        [ EditorBrowsableAttribute(EditorBrowsableState.Advanced) ] // MDAC 69508 
        public DataTable GetDataTableBySchemaAction(DataSet dataSet, MissingSchemaAction schemaAction) {
            if (null == dataSet) {
                throw ADP.ArgumentNull("dataSet");
            } 
            string dataSetTable = DataSetTable;
 
            if (ADP.IsEmpty(dataSetTable)) { 
#if DEBUG
                if (AdapterSwitches.DataSchema.TraceWarning) { 
                    Debug.WriteLine("explicit filtering of SourceTable \"" + SourceTable + "\"");
                }
#endif
                return null; 
            }
            DataTableCollection tables = dataSet.Tables; 
            int index = tables.IndexOf(dataSetTable); 
            if ((0 <= index) && (index < tables.Count)) {
#if DEBUG 
                if (AdapterSwitches.DataSchema.TraceInfo) {
                    Debug.WriteLine("schema match on DataTable \"" + dataSetTable);
                }
#endif 
                return tables[index];
            } 
            switch (schemaAction) { 
                case MissingSchemaAction.Add:
                case MissingSchemaAction.AddWithKey: 
#if DEBUG
                    if (AdapterSwitches.DataSchema.TraceInfo) {
                        Debug.WriteLine("schema add of DataTable \"" + dataSetTable + "\"");
                    } 
#endif
                    return new DataTable(dataSetTable); 
 
                case MissingSchemaAction.Ignore:
#if DEBUG 
                    if (AdapterSwitches.DataSchema.TraceWarning) {
                        Debug.WriteLine("schema filter of DataTable \"" + dataSetTable + "\"");
                    }
#endif 
                    return null;
 
                case MissingSchemaAction.Error: 
#if DEBUG
                    if (AdapterSwitches.DataSchema.TraceError) { 
                        Debug.WriteLine("schema error on DataTable \"" + dataSetTable + "\"");
                    }
#endif
                    throw ADP.MissingTableSchema(dataSetTable, SourceTable); 
            }
            throw ADP.InvalidMissingSchemaAction(schemaAction); 
        } 

        public override String ToString() { 
            return SourceTable;
        }

        sealed internal class DataTableMappingConverter : System.ComponentModel.ExpandableObjectConverter { 

            // converter classes should have public ctor 
            public DataTableMappingConverter() { 
            }
 
            override public bool CanConvertTo(ITypeDescriptorContext context, Type destinationType) {
                if (typeof(InstanceDescriptor) == destinationType) {
                    return true;
                } 
                return base.CanConvertTo(context, destinationType);
            } 
 
            override public object ConvertTo(ITypeDescriptorContext context, CultureInfo culture, object value, Type destinationType) {
                if (null == destinationType) { 
                    throw ADP.ArgumentNull("destinationType");
                }

                if ((typeof(InstanceDescriptor) == destinationType) && (value is DataTableMapping)) { 
                    DataTableMapping mapping = (DataTableMapping)value;
 
                    DataColumnMapping[] columnMappings = new DataColumnMapping[mapping.ColumnMappings.Count]; 
                    mapping.ColumnMappings.CopyTo(columnMappings, 0);
                    object[] values = new object[] { mapping.SourceTable, mapping.DataSetTable, columnMappings}; 
                    Type[] types = new Type[] { typeof(string), typeof(string), typeof(DataColumnMapping[]) };

                    ConstructorInfo ctor = typeof(DataTableMapping).GetConstructor(types);
                    return new InstanceDescriptor(ctor, values); 
                }
                return base.ConvertTo(context, culture, value, destinationType); 
            } 
        }
    } 
}

// File provided for Reference Use Only by Microsoft Corporation (c) 2007.

Link Menu

Network programming in C#, Network Programming in VB.NET, Network Programming in .NET
This book is available now!
Buy at Amazon US or
Buy at Amazon UK