Code:
/ Dotnetfx_Vista_SP2 / Dotnetfx_Vista_SP2 / 8.0.50727.4016 / DEVDIV / depot / DevDiv / releases / Orcas / QFE / ndp / fx / src / DLinq / Dlinq / SqlClient / Query / SqlTopReducer.cs / 1 / SqlTopReducer.cs
using System; using System.Collections.Generic; using System.Linq.Expressions; using System.Reflection; using System.Data.Linq; using System.Data.Linq.Provider; using System.Linq; namespace System.Data.Linq.SqlClient { internal class SqlTopReducer { internal static SqlNode Reduce(SqlNode node, SqlNodeAnnotations annotations, SqlFactory sql) { return new Visitor(annotations, sql).Visit(node); } class Visitor : SqlVisitor { SqlNodeAnnotations annotations; SqlFactory sql; internal Visitor(SqlNodeAnnotations annotations, SqlFactory sql) { this.annotations = annotations; this.sql = sql; } internal override SqlSelect VisitSelect(SqlSelect select) { base.VisitSelect(select); if (select.Top != null) { if (select.Top.NodeType == SqlNodeType.Value) { SqlValue val = (SqlValue)select.Top; // convert to literal value for SQL2K compatibility if (val.IsClientSpecified) { select.Top = sql.Value(val.ClrType, val.SqlType, val.Value, false, val.SourceExpression); } } else { // cannot be converted to literal value. note that this select is not SQL2K compatible this.annotations.Add(select.Top, new SqlServerCompatibilityAnnotation(Strings.SourceExpressionAnnotation(select.Top.SourceExpression), SqlProvider.ProviderMode.Sql2000)); } } return select; } } } } // 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.Linq.Expressions; using System.Reflection; using System.Data.Linq; using System.Data.Linq.Provider; using System.Linq; namespace System.Data.Linq.SqlClient { internal class SqlTopReducer { internal static SqlNode Reduce(SqlNode node, SqlNodeAnnotations annotations, SqlFactory sql) { return new Visitor(annotations, sql).Visit(node); } class Visitor : SqlVisitor { SqlNodeAnnotations annotations; SqlFactory sql; internal Visitor(SqlNodeAnnotations annotations, SqlFactory sql) { this.annotations = annotations; this.sql = sql; } internal override SqlSelect VisitSelect(SqlSelect select) { base.VisitSelect(select); if (select.Top != null) { if (select.Top.NodeType == SqlNodeType.Value) { SqlValue val = (SqlValue)select.Top; // convert to literal value for SQL2K compatibility if (val.IsClientSpecified) { select.Top = sql.Value(val.ClrType, val.SqlType, val.Value, false, val.SourceExpression); } } else { // cannot be converted to literal value. note that this select is not SQL2K compatible this.annotations.Add(select.Top, new SqlServerCompatibilityAnnotation(Strings.SourceExpressionAnnotation(select.Top.SourceExpression), SqlProvider.ProviderMode.Sql2000)); } } return select; } } } } // 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
- WebPartRestoreVerb.cs
- ZipPackagePart.cs
- WeakHashtable.cs
- XmlDownloadManager.cs
- AllMembershipCondition.cs
- tibetanshape.cs
- SourceFilter.cs
- SQlBooleanStorage.cs
- ObjectSecurity.cs
- IPEndPointCollection.cs
- RawStylusInputCustomDataList.cs
- TableRow.cs
- PartialCachingAttribute.cs
- Bezier.cs
- MatrixTransform.cs
- XamlReader.cs
- Event.cs
- UserControl.cs
- ApplicationSecurityInfo.cs
- SendKeys.cs
- SqlSupersetValidator.cs
- HandlerBase.cs
- GetPageNumberCompletedEventArgs.cs
- MouseEventArgs.cs
- CompiledQueryCacheKey.cs
- InputScopeAttribute.cs
- MobileErrorInfo.cs
- SingleTagSectionHandler.cs
- BCLDebug.cs
- DoubleAnimationBase.cs
- CommentEmitter.cs
- AssignDesigner.xaml.cs
- SessionIDManager.cs
- SettingsProviderCollection.cs
- DoubleKeyFrameCollection.cs
- IdentifierCollection.cs
- SemanticTag.cs
- AsymmetricKeyExchangeDeformatter.cs
- SizeKeyFrameCollection.cs
- ClientBuildManager.cs
- ViewLoader.cs
- EventProxy.cs
- securitycriticaldataClass.cs
- CommonDialog.cs
- XmlHierarchicalEnumerable.cs
- VisualStyleInformation.cs
- UInt16.cs
- AspNetSynchronizationContext.cs
- Registry.cs
- SelectManyQueryOperator.cs
- EntityCodeGenerator.cs
- ContainerUIElement3D.cs
- ObjectTypeMapping.cs
- Compiler.cs
- ZipIOCentralDirectoryBlock.cs
- Content.cs
- FormViewDeletedEventArgs.cs
- StringWriter.cs
- SqlFlattener.cs
- Vector3DKeyFrameCollection.cs
- StyleCollectionEditor.cs
- TextOnlyOutput.cs
- VersionConverter.cs
- PrintDocument.cs
- WmiEventSink.cs
- XmlAnyElementAttributes.cs
- StringArrayConverter.cs
- Compiler.cs
- EdmRelationshipRoleAttribute.cs
- XmlSchemaException.cs
- AccessDataSource.cs
- ProtectedProviderSettings.cs
- PagedDataSource.cs
- odbcmetadatacollectionnames.cs
- XmlTextWriter.cs
- SqlBooleanizer.cs
- Pick.cs
- CommandBindingCollection.cs
- RichTextBox.cs
- InheritedPropertyDescriptor.cs
- SoapIncludeAttribute.cs
- AmbientLight.cs
- XmlSiteMapProvider.cs
- TextTreeTextNode.cs
- AppearanceEditorPart.cs
- IdentityHolder.cs
- DataKeyCollection.cs
- CompModHelpers.cs
- FilterUserControlBase.cs
- SendActivityDesignerTheme.cs
- UndirectedGraph.cs
- FontUnit.cs
- ThumbAutomationPeer.cs
- StructuralObject.cs
- ObfuscateAssemblyAttribute.cs
- TableFieldsEditor.cs
- MessagePartSpecification.cs
- StyleBamlRecordReader.cs
- ResolvedKeyFrameEntry.cs
- ShaperBuffers.cs