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
- DataContext.cs
- Utils.cs
- OleDbDataReader.cs
- CustomValidator.cs
- TemplateNameScope.cs
- DataControlField.cs
- OrderByExpression.cs
- DataRowCollection.cs
- HandleCollector.cs
- RemoveStoryboard.cs
- Freezable.cs
- NameValuePermission.cs
- XPathMessageContext.cs
- ComponentCommands.cs
- ACE.cs
- dataobject.cs
- PackWebRequestFactory.cs
- SemanticKeyElement.cs
- ToolStripItemRenderEventArgs.cs
- DesignTimeXamlWriter.cs
- CachingHintValidation.cs
- JsonDeserializer.cs
- ControlBindingsCollection.cs
- InstallerTypeAttribute.cs
- HttpModuleCollection.cs
- DataServiceRequestException.cs
- Viewport2DVisual3D.cs
- ProfessionalColors.cs
- ISO2022Encoding.cs
- RefType.cs
- LinkDesigner.cs
- LazyTextWriterCreator.cs
- BinaryFormatterWriter.cs
- TextParagraphCache.cs
- TableLayout.cs
- X509Utils.cs
- HideDisabledControlAdapter.cs
- ListViewGroupCollectionEditor.cs
- KnownBoxes.cs
- DefinitionUpdate.cs
- SqlCacheDependencySection.cs
- MainMenu.cs
- GridViewRowEventArgs.cs
- webproxy.cs
- ResourceCollectionInfo.cs
- ManipulationVelocities.cs
- AsyncContentLoadedEventArgs.cs
- TableRow.cs
- Pair.cs
- Int32.cs
- ExecutedRoutedEventArgs.cs
- DbParameterHelper.cs
- ModelTreeEnumerator.cs
- LinqMaximalSubtreeNominator.cs
- processwaithandle.cs
- XmlNodeList.cs
- HttpRequestCacheValidator.cs
- DocumentReferenceCollection.cs
- Win32SafeHandles.cs
- WebReferencesBuildProvider.cs
- AxHostDesigner.cs
- ListView.cs
- BitStack.cs
- XmlTextReaderImpl.cs
- Font.cs
- PropertyEmitterBase.cs
- WmlPageAdapter.cs
- _DomainName.cs
- KoreanLunisolarCalendar.cs
- IdentitySection.cs
- ShaderEffect.cs
- OrthographicCamera.cs
- ValueUtilsSmi.cs
- NumberSubstitution.cs
- SmiEventSink_DeferedProcessing.cs
- DefaultValueTypeConverter.cs
- ImageDesigner.cs
- ListQueryResults.cs
- BindingList.cs
- AttachedPropertyMethodSelector.cs
- SqlDataSourceConfigureFilterForm.cs
- MetadataCollection.cs
- IisTraceListener.cs
- UnsupportedPolicyOptionsException.cs
- LinkDesigner.cs
- RectangleConverter.cs
- SortDescription.cs
- XmlHierarchicalEnumerable.cs
- _FtpDataStream.cs
- GridViewUpdatedEventArgs.cs
- PathFigureCollection.cs
- DataKey.cs
- UxThemeWrapper.cs
- ipaddressinformationcollection.cs
- AnimationLayer.cs
- ButtonBase.cs
- VideoDrawing.cs
- WindowPattern.cs
- AuthorizationRule.cs
- PathParser.cs