Code:
/ Dotnetfx_Win7_3.5.1 / Dotnetfx_Win7_3.5.1 / 3.5.1 / DEVDIV / depot / DevDiv / releases / Orcas / NetFXw7 / ndp / fx / src / DLinq / Dlinq / SqlClient / Query / SqlUnionizer.cs / 1 / 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
- CustomError.cs
- TheQuery.cs
- AuthenticatingEventArgs.cs
- CommandHelpers.cs
- GuidConverter.cs
- GridViewColumn.cs
- HtmlMeta.cs
- PropertyTabChangedEvent.cs
- DataConnectionHelper.cs
- sqlinternaltransaction.cs
- MetadataArtifactLoaderComposite.cs
- BulletedListDesigner.cs
- SecurityPermission.cs
- DataGridViewCellParsingEventArgs.cs
- SurrogateSelector.cs
- ExternalFile.cs
- CommonGetThemePartSize.cs
- IDReferencePropertyAttribute.cs
- X509Utils.cs
- Pkcs7Recipient.cs
- WebPartConnectionsCancelVerb.cs
- SqlXmlStorage.cs
- DiagnosticStrings.cs
- PrePrepareMethodAttribute.cs
- XmlSchemaElement.cs
- XmlComment.cs
- MeshGeometry3D.cs
- DataServiceRequestOfT.cs
- RegexNode.cs
- mediaeventargs.cs
- TreeNode.cs
- RedBlackList.cs
- CustomUserNameSecurityTokenAuthenticator.cs
- SrgsText.cs
- WindowsBrush.cs
- Propagator.JoinPropagator.cs
- AnalyzedTree.cs
- CatalogZoneBase.cs
- DefaultObjectSerializer.cs
- ListView.cs
- GeneralTransform3D.cs
- SchemaEntity.cs
- DispatcherFrame.cs
- DocumentSchemaValidator.cs
- RegexFCD.cs
- MarkupObject.cs
- AQNBuilder.cs
- ProfileGroupSettings.cs
- CharacterString.cs
- DeviceContext2.cs
- TakeOrSkipWhileQueryOperator.cs
- SqlMethods.cs
- ColumnHeader.cs
- StateWorkerRequest.cs
- CodeGenHelper.cs
- OdbcParameterCollection.cs
- DefaultAssemblyResolver.cs
- EnumerableWrapperWeakToStrong.cs
- TextContainerChangedEventArgs.cs
- EntityWithChangeTrackerStrategy.cs
- XmlSchemaSet.cs
- XmlILModule.cs
- TextRangeSerialization.cs
- coordinatorscratchpad.cs
- EmbeddedMailObjectsCollection.cs
- ObjectQueryState.cs
- TextTreeUndoUnit.cs
- Attributes.cs
- DataContractSerializerSection.cs
- Pts.cs
- AssemblySettingAttributes.cs
- NumericUpDown.cs
- DataGridViewAutoSizeColumnModeEventArgs.cs
- CFStream.cs
- PolyQuadraticBezierSegment.cs
- RawAppCommandInputReport.cs
- HttpHandlersSection.cs
- XmlAttributes.cs
- EdmMember.cs
- ShutDownListener.cs
- AppSettingsExpressionEditor.cs
- HtmlInputImage.cs
- StylusShape.cs
- CreateUserErrorEventArgs.cs
- ObjectItemNoOpAssemblyLoader.cs
- GridView.cs
- DataPager.cs
- Validator.cs
- RetrieveVirtualItemEventArgs.cs
- NamedPipeConnectionPoolSettings.cs
- ProxyWebPart.cs
- WebPartChrome.cs
- AddInAttribute.cs
- _KerberosClient.cs
- MappingSource.cs
- KnownIds.cs
- StrongNameMembershipCondition.cs
- SystemIPv4InterfaceProperties.cs
- BinaryFormatter.cs
- DBDataPermission.cs