Code:
/ 4.0 / 4.0 / DEVDIV_TFS / Dev10 / Releases / RTMRel / ndp / fx / src / DLinq / Dlinq / SqlClient / Query / SqlTopReducer.cs / 1305376 / 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
- SqlProfileProvider.cs
- DbDataSourceEnumerator.cs
- ExternalFile.cs
- BigInt.cs
- StreamFormatter.cs
- TraversalRequest.cs
- QuaternionRotation3D.cs
- OleDbInfoMessageEvent.cs
- FunctionImportElement.cs
- HttpVersion.cs
- XPathNodeIterator.cs
- ClientApiGenerator.cs
- DataColumn.cs
- XPathAncestorQuery.cs
- IsolatedStorage.cs
- Rule.cs
- GradientStop.cs
- BaseParagraph.cs
- CompiledRegexRunnerFactory.cs
- VisualStyleTypesAndProperties.cs
- ComUdtElementCollection.cs
- CmsUtils.cs
- InfoCardRSAPKCS1KeyExchangeDeformatter.cs
- ValidatorCompatibilityHelper.cs
- RSAOAEPKeyExchangeDeformatter.cs
- CodeArrayIndexerExpression.cs
- ProviderConnectionPoint.cs
- DataListGeneralPage.cs
- OleDbPropertySetGuid.cs
- TemplateManager.cs
- Errors.cs
- ObjectQueryProvider.cs
- ipaddressinformationcollection.cs
- UserMapPath.cs
- UniqueContractNameValidationBehavior.cs
- DateTimeFormatInfoScanner.cs
- ObjectConverter.cs
- ProfessionalColorTable.cs
- BindingUtils.cs
- StrongTypingException.cs
- RoleService.cs
- StyleCollectionEditor.cs
- ColumnMapVisitor.cs
- Pen.cs
- Line.cs
- ResourceDisplayNameAttribute.cs
- CreateParams.cs
- CssTextWriter.cs
- DataFormats.cs
- ServiceObjectContainer.cs
- ReferentialConstraintRoleElement.cs
- Color.cs
- EnumerableWrapperWeakToStrong.cs
- ChangeNode.cs
- ParallelTimeline.cs
- XmlSchemaFacet.cs
- Executor.cs
- PeerApplication.cs
- RefreshPropertiesAttribute.cs
- updateconfighost.cs
- BaseResourcesBuildProvider.cs
- SafeWaitHandle.cs
- Size3D.cs
- CodeCommentStatementCollection.cs
- RawStylusInputReport.cs
- EnumMemberAttribute.cs
- FlowDocument.cs
- ErrorFormatter.cs
- DesignerGenericWebPart.cs
- ServerProtocol.cs
- VarRemapper.cs
- PrimitiveCodeDomSerializer.cs
- NamespaceMapping.cs
- MessageQueue.cs
- LassoHelper.cs
- PropertySegmentSerializationProvider.cs
- FixedBufferAttribute.cs
- PackWebResponse.cs
- RectKeyFrameCollection.cs
- SystemIPv6InterfaceProperties.cs
- ArrayHelper.cs
- UrlPath.cs
- DataSourceControl.cs
- FixedSOMTextRun.cs
- KeyInterop.cs
- ComponentResourceManager.cs
- PkcsMisc.cs
- SqlDataSourceSelectingEventArgs.cs
- Function.cs
- InheritanceUI.cs
- BitmapEffectState.cs
- XLinq.cs
- SerializerDescriptor.cs
- EndpointAddressMessageFilterTable.cs
- SelectionItemProviderWrapper.cs
- SerializationException.cs
- Compiler.cs
- AncillaryOps.cs
- BaseComponentEditor.cs
- PropertyExpression.cs