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
- AlternateViewCollection.cs
- DataReceivedEventArgs.cs
- DbMetaDataFactory.cs
- EntityDataSource.cs
- ExpressionPrefixAttribute.cs
- SessionStateUtil.cs
- XmlDataLoader.cs
- HttpRawResponse.cs
- BindMarkupExtensionSerializer.cs
- StringConverter.cs
- CharConverter.cs
- MulticastOption.cs
- TextRunCacheImp.cs
- UriSectionReader.cs
- httpstaticobjectscollection.cs
- XmlDataDocument.cs
- PermissionSetEnumerator.cs
- QueryResult.cs
- TextEffectCollection.cs
- GroupedContextMenuStrip.cs
- StylusOverProperty.cs
- ConfigurationLockCollection.cs
- InstanceNameConverter.cs
- CurrentTimeZone.cs
- TreeViewImageKeyConverter.cs
- ProfilePropertySettings.cs
- GiveFeedbackEvent.cs
- WSHttpBindingBase.cs
- XmlDataImplementation.cs
- WindowProviderWrapper.cs
- SoapExtensionReflector.cs
- DataGridItemAttachedStorage.cs
- MissingManifestResourceException.cs
- XamlDebuggerXmlReader.cs
- StorageEntityContainerMapping.cs
- MatrixConverter.cs
- SchemaCollectionCompiler.cs
- ObjectNotFoundException.cs
- HostedHttpContext.cs
- OpenTypeLayoutCache.cs
- StylusButton.cs
- EntityDataSourceMemberPath.cs
- SelectionHighlightInfo.cs
- HttpServerVarsCollection.cs
- DataGridBoundColumn.cs
- RuntimeConfigLKG.cs
- ContextMenu.cs
- ScrollBarRenderer.cs
- TreePrinter.cs
- MediaTimeline.cs
- CachingHintValidation.cs
- MetadataSerializer.cs
- CachedPathData.cs
- TextBoxBase.cs
- DataList.cs
- AspNetCompatibilityRequirementsAttribute.cs
- RootBrowserWindowAutomationPeer.cs
- CqlLexerHelpers.cs
- MemberAssignment.cs
- ValidatorCompatibilityHelper.cs
- SizeAnimationUsingKeyFrames.cs
- securitycriticaldata.cs
- FilterableAttribute.cs
- MimeTypeAttribute.cs
- UnsafeNativeMethods.cs
- MetadataCacheItem.cs
- MenuEventArgs.cs
- DataPagerFieldCollection.cs
- XmlElementList.cs
- WebPartAddingEventArgs.cs
- OdbcConnectionStringbuilder.cs
- DataGridViewColumnDividerDoubleClickEventArgs.cs
- InvalidProgramException.cs
- TextBox.cs
- WhiteSpaceTrimStringConverter.cs
- securitymgrsite.cs
- DataPagerFieldCommandEventArgs.cs
- CapabilitiesUse.cs
- ListBase.cs
- CodeNamespaceImport.cs
- FileCodeGroup.cs
- CodeDirectoryCompiler.cs
- CodeCommentStatementCollection.cs
- SplineKeyFrames.cs
- IgnoreSectionHandler.cs
- RenderContext.cs
- ConsoleTraceListener.cs
- BezierSegment.cs
- PolygonHotSpot.cs
- ImageSourceTypeConverter.cs
- FilterQueryOptionExpression.cs
- HttpModuleActionCollection.cs
- ScrollableControl.cs
- Subtree.cs
- ExpressionEvaluator.cs
- RelatedPropertyManager.cs
- DesignerTransactionCloseEvent.cs
- MainMenu.cs
- Cursor.cs
- XmlSchemaSimpleTypeList.cs