Code:
/ 4.0 / 4.0 / 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. 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 Comparison comp = (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
- ButtonPopupAdapter.cs
- CodeCommentStatement.cs
- RuntimeArgumentHandle.cs
- CompensatableSequenceActivity.cs
- BitmapEffectState.cs
- ToolStripGripRenderEventArgs.cs
- ReadWriteSpinLock.cs
- CodeChecksumPragma.cs
- SimplePropertyEntry.cs
- ArrangedElementCollection.cs
- UInt32.cs
- CreateUserWizard.cs
- DataGridViewComboBoxEditingControl.cs
- Hash.cs
- Pkcs7Signer.cs
- SplitterPanel.cs
- AsmxEndpointPickerExtension.cs
- XmlSignatureProperties.cs
- XmlSchemaImport.cs
- transactioncontext.cs
- MailMessage.cs
- StylusEventArgs.cs
- PreviewKeyDownEventArgs.cs
- ReachSerializerAsync.cs
- FixedBufferAttribute.cs
- ObjectSpanRewriter.cs
- _ConnectionGroup.cs
- Token.cs
- Transactions.cs
- ComPlusTypeLoader.cs
- ThemeableAttribute.cs
- ColumnBinding.cs
- IisTraceListener.cs
- _ChunkParse.cs
- DisplayInformation.cs
- MarkupCompiler.cs
- XmlObjectSerializerWriteContextComplex.cs
- Span.cs
- BitmapCacheBrush.cs
- WebPartAddingEventArgs.cs
- ListView.cs
- HandlerBase.cs
- MemberAssignment.cs
- XPathNodeInfoAtom.cs
- HtmlButton.cs
- SignedPkcs7.cs
- Vector3DValueSerializer.cs
- NullableDoubleAverageAggregationOperator.cs
- PkcsUtils.cs
- ConnectionPoolManager.cs
- HtmlUtf8RawTextWriter.cs
- CompModSwitches.cs
- SystemIPv4InterfaceProperties.cs
- ConstrainedGroup.cs
- MarshalByValueComponent.cs
- AppSettingsSection.cs
- MimeMapping.cs
- StringFunctions.cs
- KeyEventArgs.cs
- InstallerTypeAttribute.cs
- DocumentViewer.cs
- _ProxyChain.cs
- UnionExpr.cs
- HtmlInputSubmit.cs
- ErrorHandlerModule.cs
- TextModifier.cs
- CheckStoreFileValidityRequest.cs
- IgnoreSectionHandler.cs
- PointValueSerializer.cs
- HtmlDocument.cs
- RowUpdatingEventArgs.cs
- ParentQuery.cs
- HttpModuleActionCollection.cs
- EncryptedXml.cs
- FormatterConverter.cs
- URLIdentityPermission.cs
- TextElement.cs
- RepeaterItemCollection.cs
- SizeChangedEventArgs.cs
- DetailsViewRowCollection.cs
- WebBaseEventKeyComparer.cs
- OSEnvironmentHelper.cs
- DataTableExtensions.cs
- EdmProperty.cs
- SamlAuthorityBinding.cs
- ColorConverter.cs
- HierarchicalDataSourceIDConverter.cs
- PlainXmlSerializer.cs
- AttachedPropertyBrowsableWhenAttributePresentAttribute.cs
- RemotingException.cs
- HiddenFieldPageStatePersister.cs
- UrlPath.cs
- RectangleHotSpot.cs
- GridViewRowPresenterBase.cs
- StatusBarItemAutomationPeer.cs
- DataColumnMappingCollection.cs
- safelinkcollection.cs
- TypeExtensions.cs
- MessageHeaderException.cs
- PluralizationServiceUtil.cs