Code:
/ 4.0 / 4.0 / untmp / DEVDIV_TFS / Dev10 / Releases / RTMRel / ndp / fx / src / DLinq / Dlinq / SqlClient / Query / SqlUnionizer.cs / 1305376 / SqlUnionizer.cs
using System; using System.Collections.Generic; using System.Text; using System.Diagnostics.CodeAnalysis; namespace System.Data.Linq.SqlClient { internal class SqlUnionizer { internal static SqlNode Unionize(SqlNode node) { return new Visitor().Visit(node); } class Visitor : SqlVisitor { internal override SqlSelect VisitSelect(SqlSelect select) { base.VisitSelect(select); // enforce exact ordering of columns in union selects SqlUnion union = this.GetUnion(select.From); if (union != null) { SqlSelect sleft = union.Left as SqlSelect; SqlSelect sright = union.Right as SqlSelect; if (sleft != null & sright != null) { // preset ordinals to high values (so any unreachable column definition is ordered last) for (int i = 0, n = sleft.Row.Columns.Count; i < n; i++) { sleft.Row.Columns[i].Ordinal = select.Row.Columns.Count + i; } for (int i = 0, n = sright.Row.Columns.Count; i < n; i++) { sright.Row.Columns[i].Ordinal = select.Row.Columns.Count + i; } // next assign ordinals to all direct columns in subselects for (int i = 0, n = select.Row.Columns.Count; i < n; i++) { SqlExprSet es = select.Row.Columns[i].Expression as SqlExprSet; if (es != null) { for (int e = 0, en = es.Expressions.Count; e < en; e++) { SqlColumnRef cr = es.Expressions[e] as SqlColumnRef; if (cr != null && e >= select.Row.Columns.Count) { cr.Column.Ordinal = i; } } } } // next sort columns in left & right subselects Comparisoncomp = (x,y) => x.Ordinal - y.Ordinal; sleft.Row.Columns.Sort(comp); sright.Row.Columns.Sort(comp); } } return select; } [SuppressMessage("Microsoft.Performance", "CA1822:MarkMembersAsStatic", Justification="Unknown reason.")] private SqlUnion GetUnion(SqlSource source) { SqlAlias alias = source as SqlAlias; if (alias != null) { SqlUnion union = alias.Node as SqlUnion; if (union != null) return union; } return null; } } } } // File provided for Reference Use Only by Microsoft Corporation (c) 2007. // Copyright (c) Microsoft Corporation. All rights reserved.
Link Menu
This book is available now!
Buy at Amazon US or
Buy at Amazon UK
- ListBindingHelper.cs
- HttpWebRequestElement.cs
- TemplateKey.cs
- ScrollPattern.cs
- SpeechRecognitionEngine.cs
- TransactionalPackage.cs
- XsltQilFactory.cs
- BufferedGraphicsContext.cs
- formatstringdialog.cs
- CryptographicAttribute.cs
- GroupQuery.cs
- SoapException.cs
- SelectionList.cs
- TdsParserStaticMethods.cs
- Simplifier.cs
- AmbiguousMatchException.cs
- TextElementEnumerator.cs
- GreaterThan.cs
- CqlBlock.cs
- DataServiceRequestArgs.cs
- MailWebEventProvider.cs
- Relationship.cs
- SmtpNetworkElement.cs
- DataServiceHostFactory.cs
- DoubleCollectionValueSerializer.cs
- RowParagraph.cs
- XmlUTF8TextReader.cs
- GB18030Encoding.cs
- GetWinFXPath.cs
- CodeDirectoryCompiler.cs
- UserPersonalizationStateInfo.cs
- SchemaImporterExtensionsSection.cs
- AutomationFocusChangedEventArgs.cs
- HtmlTernaryTree.cs
- XmlSerializerFactory.cs
- ProfessionalColors.cs
- Camera.cs
- OdbcConnectionPoolProviderInfo.cs
- DbgUtil.cs
- DataGridViewCellValueEventArgs.cs
- SafeThemeHandle.cs
- SymmetricSecurityProtocolFactory.cs
- XamlClipboardData.cs
- RoamingStoreFileUtility.cs
- SmiTypedGetterSetter.cs
- Tool.cs
- DynamicDataRouteHandler.cs
- TextUtf8RawTextWriter.cs
- QilChoice.cs
- XsltArgumentList.cs
- ResourceType.cs
- RewritingSimplifier.cs
- StandardBindingElementCollection.cs
- Point4DConverter.cs
- DefaultValueAttribute.cs
- Itemizer.cs
- UInt32.cs
- HtmlAnchor.cs
- InternalEnumValidatorAttribute.cs
- DbParameterCollectionHelper.cs
- CalloutQueueItem.cs
- UserNamePasswordValidator.cs
- DebugHandleTracker.cs
- WebServiceParameterData.cs
- ConnectionPointGlyph.cs
- PaintEvent.cs
- DataGridTemplateColumn.cs
- DataGridTablesFactory.cs
- ProfileServiceManager.cs
- MulticastOption.cs
- securitymgrsite.cs
- DataRowExtensions.cs
- SqlDataSourceConfigureSortForm.cs
- MSAANativeProvider.cs
- FullTextState.cs
- CommandSet.cs
- RoleService.cs
- DbDataReader.cs
- StyleSheetDesigner.cs
- ToolStripDropDown.cs
- DataGridViewHeaderCell.cs
- returneventsaver.cs
- PropertyPath.cs
- LambdaSerializationException.cs
- LogExtentCollection.cs
- TypedReference.cs
- _ListenerRequestStream.cs
- SharedPersonalizationStateInfo.cs
- TextServicesPropertyRanges.cs
- Screen.cs
- EntitySet.cs
- autovalidator.cs
- SpeechRecognitionEngine.cs
- HotSpotCollection.cs
- CompilerGeneratedAttribute.cs
- ZipIOCentralDirectoryDigitalSignature.cs
- OperandQuery.cs
- TextSelectionProcessor.cs
- OdbcEnvironment.cs
- ObjectView.cs