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
- DataControlButton.cs
- UnsafeNativeMethods.cs
- NavigationPropertySingletonExpression.cs
- KnownTypesProvider.cs
- XPathAncestorIterator.cs
- _AuthenticationState.cs
- _BasicClient.cs
- ConsumerConnectionPointCollection.cs
- DesignTimeParseData.cs
- NotificationContext.cs
- HttpCapabilitiesEvaluator.cs
- COM2Enum.cs
- DatatypeImplementation.cs
- PlacementWorkspace.cs
- TextFormatterHost.cs
- FirewallWrapper.cs
- BaseParagraph.cs
- CompressStream.cs
- EncodingInfo.cs
- StateMachineWorkflowInstance.cs
- SystemInformation.cs
- CheckoutException.cs
- TreeNodeStyleCollection.cs
- VectorConverter.cs
- MappingException.cs
- SqlTypeConverter.cs
- HttpDictionary.cs
- BaseUriHelper.cs
- TextSpanModifier.cs
- XmlLanguage.cs
- DataObjectCopyingEventArgs.cs
- DetailsViewInsertEventArgs.cs
- EventTrigger.cs
- Command.cs
- PrePrepareMethodAttribute.cs
- TreeBuilder.cs
- ScriptIgnoreAttribute.cs
- CodeTypeConstructor.cs
- ParsedAttributeCollection.cs
- SHA1CryptoServiceProvider.cs
- ButtonBaseAdapter.cs
- UIElementParagraph.cs
- HttpContextWrapper.cs
- dataprotectionpermissionattribute.cs
- MiniMapControl.xaml.cs
- TreeSet.cs
- ScriptResourceHandler.cs
- UrlMappingsSection.cs
- PrinterUnitConvert.cs
- DataGridAutoFormat.cs
- OrderedDictionaryStateHelper.cs
- AuthenticationModuleElementCollection.cs
- TemplatePropertyEntry.cs
- TaskScheduler.cs
- WindowHideOrCloseTracker.cs
- CharacterBuffer.cs
- RowType.cs
- SoapExtensionReflector.cs
- BooleanFunctions.cs
- ElementProxy.cs
- Vector3DCollection.cs
- XPathNodeHelper.cs
- XmlDataLoader.cs
- EndpointDiscoveryBehavior.cs
- TdsParserStateObject.cs
- SQLMembershipProvider.cs
- RoleExceptions.cs
- StorageFunctionMapping.cs
- PointAnimationUsingPath.cs
- EventlogProvider.cs
- HyperLinkColumn.cs
- GlobalProxySelection.cs
- KeyNotFoundException.cs
- GeneralTransformGroup.cs
- SynchronousChannelMergeEnumerator.cs
- NamespaceQuery.cs
- TextFragmentEngine.cs
- messageonlyhwndwrapper.cs
- TextBoxAutoCompleteSourceConverter.cs
- Registry.cs
- WebPartConnectionsConfigureVerb.cs
- SourceFileBuildProvider.cs
- ListControlActionList.cs
- CollectionsUtil.cs
- DirectionalLight.cs
- CmsUtils.cs
- ValueOfAction.cs
- Stopwatch.cs
- ToolStripDropTargetManager.cs
- Byte.cs
- ControlValuePropertyAttribute.cs
- ListenerElementsCollection.cs
- ObjectItemCollection.cs
- Control.cs
- BamlResourceSerializer.cs
- ContainerParagraph.cs
- IssuanceLicense.cs
- MultipleViewPattern.cs
- SoapCodeExporter.cs
- ImageResources.Designer.cs