Code:
/ Net / Net / 3.5.50727.3053 / DEVDIV / depot / DevDiv / releases / whidbey / netfxsp / ndp / fx / src / Data / System / Data / Common / DBSchemaTable.cs / 1 / DBSchemaTable.cs
//------------------------------------------------------------------------------ //// Copyright (c) Microsoft Corporation. All rights reserved. // //[....] //[....] //----------------------------------------------------------------------------- namespace System.Data.Common { using System; using System.Data; using System.Data.ProviderBase; using System.Diagnostics; sealed internal class DbSchemaTable { private enum ColumnEnum { ColumnName, ColumnOrdinal, ColumnSize, BaseServerName, BaseCatalogName, BaseColumnName, BaseSchemaName, BaseTableName, IsAutoIncrement, IsUnique, IsKey, IsRowVersion, DataType, ProviderSpecificDataType, AllowDBNull, ProviderType, IsExpression, IsHidden, IsLong, IsReadOnly, SchemaMappingUnsortedIndex, } static readonly private string[] DBCOLUMN_NAME = new string[] { SchemaTableColumn.ColumnName, SchemaTableColumn.ColumnOrdinal, SchemaTableColumn.ColumnSize, SchemaTableOptionalColumn.BaseServerName, SchemaTableOptionalColumn.BaseCatalogName, SchemaTableColumn.BaseColumnName, SchemaTableColumn.BaseSchemaName, SchemaTableColumn.BaseTableName, SchemaTableOptionalColumn.IsAutoIncrement, SchemaTableColumn.IsUnique, SchemaTableColumn.IsKey, SchemaTableOptionalColumn.IsRowVersion, SchemaTableColumn.DataType, SchemaTableOptionalColumn.ProviderSpecificDataType, SchemaTableColumn.AllowDBNull, SchemaTableColumn.ProviderType, SchemaTableColumn.IsExpression, SchemaTableOptionalColumn.IsHidden, SchemaTableColumn.IsLong, SchemaTableOptionalColumn.IsReadOnly, DbSchemaRow.SchemaMappingUnsortedIndex, }; internal DataTable dataTable; private DataColumnCollection columns; private DataColumn[] columnCache = new DataColumn[DBCOLUMN_NAME.Length]; private bool _returnProviderSpecificTypes; internal DbSchemaTable(DataTable dataTable, bool returnProviderSpecificTypes) { this.dataTable = dataTable; this.columns = dataTable.Columns; _returnProviderSpecificTypes = returnProviderSpecificTypes; } internal DataColumn ColumnName { get { return CachedDataColumn(ColumnEnum.ColumnName);}} internal DataColumn Size { get { return CachedDataColumn(ColumnEnum.ColumnSize);}} internal DataColumn BaseServerName { get { return CachedDataColumn(ColumnEnum.BaseServerName);}} internal DataColumn BaseColumnName { get { return CachedDataColumn(ColumnEnum.BaseColumnName);}} internal DataColumn BaseTableName { get { return CachedDataColumn(ColumnEnum.BaseTableName);}} internal DataColumn BaseCatalogName { get { return CachedDataColumn(ColumnEnum.BaseCatalogName);}} internal DataColumn BaseSchemaName { get { return CachedDataColumn(ColumnEnum.BaseSchemaName);}} internal DataColumn IsAutoIncrement { get { return CachedDataColumn(ColumnEnum.IsAutoIncrement);}} internal DataColumn IsUnique { get { return CachedDataColumn(ColumnEnum.IsUnique);}} internal DataColumn IsKey { get { return CachedDataColumn(ColumnEnum.IsKey);}} internal DataColumn IsRowVersion { get { return CachedDataColumn(ColumnEnum.IsRowVersion);}} internal DataColumn AllowDBNull { get { return CachedDataColumn(ColumnEnum.AllowDBNull);}} internal DataColumn IsExpression { get { return CachedDataColumn(ColumnEnum.IsExpression);}} internal DataColumn IsHidden { get { return CachedDataColumn(ColumnEnum.IsHidden);}} internal DataColumn IsLong { get { return CachedDataColumn(ColumnEnum.IsLong);}} internal DataColumn IsReadOnly { get { return CachedDataColumn(ColumnEnum.IsReadOnly);}} internal DataColumn UnsortedIndex { get { return CachedDataColumn(ColumnEnum.SchemaMappingUnsortedIndex);}} internal DataColumn DataType { get { if (_returnProviderSpecificTypes) { return CachedDataColumn(ColumnEnum.ProviderSpecificDataType, ColumnEnum.DataType); } return CachedDataColumn(ColumnEnum.DataType); } } private DataColumn CachedDataColumn(ColumnEnum column) { return CachedDataColumn(column, column); } private DataColumn CachedDataColumn(ColumnEnum column, ColumnEnum column2) { DataColumn dataColumn = columnCache[(int) column]; if (null == dataColumn) { int index = columns.IndexOf(DBCOLUMN_NAME[(int) column]); if ((-1 == index) && (column != column2)) { index = columns.IndexOf(DBCOLUMN_NAME[(int) column2]); } if (-1 != index) { dataColumn = columns[index]; columnCache[(int) column] = dataColumn; } } return dataColumn; } } } // 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.Data; using System.Data.ProviderBase; using System.Diagnostics; sealed internal class DbSchemaTable { private enum ColumnEnum { ColumnName, ColumnOrdinal, ColumnSize, BaseServerName, BaseCatalogName, BaseColumnName, BaseSchemaName, BaseTableName, IsAutoIncrement, IsUnique, IsKey, IsRowVersion, DataType, ProviderSpecificDataType, AllowDBNull, ProviderType, IsExpression, IsHidden, IsLong, IsReadOnly, SchemaMappingUnsortedIndex, } static readonly private string[] DBCOLUMN_NAME = new string[] { SchemaTableColumn.ColumnName, SchemaTableColumn.ColumnOrdinal, SchemaTableColumn.ColumnSize, SchemaTableOptionalColumn.BaseServerName, SchemaTableOptionalColumn.BaseCatalogName, SchemaTableColumn.BaseColumnName, SchemaTableColumn.BaseSchemaName, SchemaTableColumn.BaseTableName, SchemaTableOptionalColumn.IsAutoIncrement, SchemaTableColumn.IsUnique, SchemaTableColumn.IsKey, SchemaTableOptionalColumn.IsRowVersion, SchemaTableColumn.DataType, SchemaTableOptionalColumn.ProviderSpecificDataType, SchemaTableColumn.AllowDBNull, SchemaTableColumn.ProviderType, SchemaTableColumn.IsExpression, SchemaTableOptionalColumn.IsHidden, SchemaTableColumn.IsLong, SchemaTableOptionalColumn.IsReadOnly, DbSchemaRow.SchemaMappingUnsortedIndex, }; internal DataTable dataTable; private DataColumnCollection columns; private DataColumn[] columnCache = new DataColumn[DBCOLUMN_NAME.Length]; private bool _returnProviderSpecificTypes; internal DbSchemaTable(DataTable dataTable, bool returnProviderSpecificTypes) { this.dataTable = dataTable; this.columns = dataTable.Columns; _returnProviderSpecificTypes = returnProviderSpecificTypes; } internal DataColumn ColumnName { get { return CachedDataColumn(ColumnEnum.ColumnName);}} internal DataColumn Size { get { return CachedDataColumn(ColumnEnum.ColumnSize);}} internal DataColumn BaseServerName { get { return CachedDataColumn(ColumnEnum.BaseServerName);}} internal DataColumn BaseColumnName { get { return CachedDataColumn(ColumnEnum.BaseColumnName);}} internal DataColumn BaseTableName { get { return CachedDataColumn(ColumnEnum.BaseTableName);}} internal DataColumn BaseCatalogName { get { return CachedDataColumn(ColumnEnum.BaseCatalogName);}} internal DataColumn BaseSchemaName { get { return CachedDataColumn(ColumnEnum.BaseSchemaName);}} internal DataColumn IsAutoIncrement { get { return CachedDataColumn(ColumnEnum.IsAutoIncrement);}} internal DataColumn IsUnique { get { return CachedDataColumn(ColumnEnum.IsUnique);}} internal DataColumn IsKey { get { return CachedDataColumn(ColumnEnum.IsKey);}} internal DataColumn IsRowVersion { get { return CachedDataColumn(ColumnEnum.IsRowVersion);}} internal DataColumn AllowDBNull { get { return CachedDataColumn(ColumnEnum.AllowDBNull);}} internal DataColumn IsExpression { get { return CachedDataColumn(ColumnEnum.IsExpression);}} internal DataColumn IsHidden { get { return CachedDataColumn(ColumnEnum.IsHidden);}} internal DataColumn IsLong { get { return CachedDataColumn(ColumnEnum.IsLong);}} internal DataColumn IsReadOnly { get { return CachedDataColumn(ColumnEnum.IsReadOnly);}} internal DataColumn UnsortedIndex { get { return CachedDataColumn(ColumnEnum.SchemaMappingUnsortedIndex);}} internal DataColumn DataType { get { if (_returnProviderSpecificTypes) { return CachedDataColumn(ColumnEnum.ProviderSpecificDataType, ColumnEnum.DataType); } return CachedDataColumn(ColumnEnum.DataType); } } private DataColumn CachedDataColumn(ColumnEnum column) { return CachedDataColumn(column, column); } private DataColumn CachedDataColumn(ColumnEnum column, ColumnEnum column2) { DataColumn dataColumn = columnCache[(int) column]; if (null == dataColumn) { int index = columns.IndexOf(DBCOLUMN_NAME[(int) column]); if ((-1 == index) && (column != column2)) { index = columns.IndexOf(DBCOLUMN_NAME[(int) column2]); } if (-1 != index) { dataColumn = columns[index]; columnCache[(int) column] = dataColumn; } } return dataColumn; } } } // File provided for Reference Use Only by Microsoft Corporation (c) 2007.
Link Menu
This book is available now!
Buy at Amazon US or
Buy at Amazon UK
- ChildrenQuery.cs
- CacheMemory.cs
- GradientBrush.cs
- WorkflowRuntimeEndpoint.cs
- Point4DValueSerializer.cs
- HtmlGenericControl.cs
- CodeTypeParameterCollection.cs
- ObjectHandle.cs
- IpcClientChannel.cs
- BeginStoryboard.cs
- SplitterEvent.cs
- EncoderNLS.cs
- PriorityChain.cs
- EnlistmentTraceIdentifier.cs
- KnownBoxes.cs
- ReadOnlyHierarchicalDataSourceView.cs
- Stacktrace.cs
- CompilationUtil.cs
- FixedTextBuilder.cs
- FileDialog_Vista_Interop.cs
- PasswordPropertyTextAttribute.cs
- Wizard.cs
- TextEditor.cs
- SspiNegotiationTokenProviderState.cs
- TextBoxBase.cs
- DesignerSerializationVisibilityAttribute.cs
- FileCodeGroup.cs
- KeyedCollection.cs
- DoubleLinkList.cs
- SecurityDocument.cs
- LinkLabel.cs
- AxDesigner.cs
- CapabilitiesSection.cs
- AssemblyInfo.cs
- HttpVersion.cs
- TypeReference.cs
- ToolStrip.cs
- DataPagerFieldItem.cs
- ColorConvertedBitmap.cs
- TreeNodeBindingCollection.cs
- DependencyProperty.cs
- _LazyAsyncResult.cs
- BadImageFormatException.cs
- UserControlCodeDomTreeGenerator.cs
- CategoryValueConverter.cs
- AllMembershipCondition.cs
- KeyInterop.cs
- Substitution.cs
- DataControlButton.cs
- TraceRecords.cs
- IgnoreFileBuildProvider.cs
- FontCacheUtil.cs
- MobileUserControl.cs
- Timer.cs
- ManagementQuery.cs
- HMAC.cs
- Bidi.cs
- RoleManagerSection.cs
- RuleValidation.cs
- listitem.cs
- CollectionBase.cs
- SerTrace.cs
- TreeNodeCollection.cs
- DataGridViewRowStateChangedEventArgs.cs
- EnlistmentState.cs
- Button.cs
- ServiceOperationDetailViewControl.cs
- PrintPageEvent.cs
- Predicate.cs
- BinaryParser.cs
- BinaryReader.cs
- MailAddressCollection.cs
- Dictionary.cs
- TimeManager.cs
- StorageModelBuildProvider.cs
- SmtpNtlmAuthenticationModule.cs
- EvidenceBase.cs
- SqlPersistenceWorkflowInstanceDescription.cs
- TreeNodeConverter.cs
- Activation.cs
- CultureSpecificCharacterBufferRange.cs
- TileModeValidation.cs
- MaskInputRejectedEventArgs.cs
- IOThreadScheduler.cs
- ColumnWidthChangedEvent.cs
- OleDbPermission.cs
- Window.cs
- SpellerStatusTable.cs
- ParallelTimeline.cs
- DmlSqlGenerator.cs
- MetadataPropertyvalue.cs
- LoginView.cs
- ObservableDictionary.cs
- ProxyWebPartManager.cs
- BaseCodePageEncoding.cs
- FillBehavior.cs
- TypeSystem.cs
- RootDesignerSerializerAttribute.cs
- WebServiceEnumData.cs
- SymbolType.cs