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 / SqlSupersetValidator.cs / 1 / SqlSupersetValidator.cs
using System; using System.Collections.Generic; using System.Text; namespace System.Data.Linq.SqlClient { ////// Validates the integrity of super-SQL trees. /// internal class SqlSupersetValidator { Listvalidators = new List (); /// /// Add a validator to the collection of validators to run. /// internal void AddValidator(SqlVisitor validator) { this.validators.Add(validator); } ////// Execute each current validator. /// internal void Validate(SqlNode node) { foreach (SqlVisitor validator in this.validators) { validator.Visit(node); } } } ////// Column ClrType must agree with the expression that it points to. /// internal class ColumnTypeValidator : SqlVisitor { internal override SqlRow VisitRow(SqlRow row) { for (int i = 0, n = row.Columns.Count; i < n; i++) { SqlColumn col = row.Columns[i]; SqlExpression expr = this.VisitExpression(col.Expression); if (expr != null) { if (TypeSystem.GetNonNullableType(col.ClrType) != TypeSystem.GetNonNullableType(expr.ClrType)) { throw Error.ColumnClrTypeDoesNotAgreeWithExpressionsClrType(); } } } return row; } } ////// A validator that ensures literal values are reasonable. /// internal class LiteralValidator : SqlVisitor { internal override SqlExpression VisitValue(SqlValue value) { if (!value.IsClientSpecified && value.ClrType.IsClass && value.ClrType != typeof(string) && value.ClrType != typeof(Type) && value.Value != null) { throw Error.ClassLiteralsNotAllowed(value.ClrType); } return value; } internal override SqlExpression VisitBinaryOperator(SqlBinary bo) { bo.Left = this.VisitExpression(bo.Left); return bo; } } ////// A validator which enforces rationalized boolean expressions. /// internal class ExpectRationalizedBooleans : SqlBooleanMismatchVisitor { internal ExpectRationalizedBooleans() { } internal override SqlExpression ConvertValueToPredicate(SqlExpression bitExpression) { throw Error.ExpectedPredicateFoundBit(); } internal override SqlExpression ConvertPredicateToValue(SqlExpression predicateExpression) { throw Error.ExpectedBitFoundPredicate(); } } ////// A validator which enforces that no more SqlMethodCall nodes exist in the tree. /// internal class ExpectNoMethodCalls : SqlVisitor { internal override SqlExpression VisitMethodCall(SqlMethodCall mc) { // eventually we may support this type of stuff given the SQL CLR, but for now it is illegal throw Error.MethodHasNoSupportConversionToSql(mc.Method.Name); } // check everything except selection expressions (which will be client or ignored) internal override SqlSelect VisitSelect(SqlSelect select) { select.From = this.VisitSource(select.From); select.Where = this.VisitExpression(select.Where); for (int i = 0, n = select.GroupBy.Count; i < n; i++) { select.GroupBy[i] = this.VisitExpression(select.GroupBy[i]); } select.Having = this.VisitExpression(select.Having); for (int i = 0, n = select.OrderBy.Count; i < n; i++) { select.OrderBy[i].Expression = this.VisitExpression(select.OrderBy[i].Expression); } select.Top = this.VisitExpression(select.Top); //select.Selection = this.VisitExpression(select.Selection); select.Row = (SqlRow)this.Visit(select.Row); return select; } } internal class ExpectNoFloatingColumns : SqlVisitor { internal override SqlRow VisitRow(SqlRow row) { foreach (SqlColumn c in row.Columns) { this.Visit(c.Expression); } return row; } internal override SqlTable VisitTable(SqlTable tab) { foreach (SqlColumn c in tab.Columns) { this.Visit(c.Expression); } return tab; } internal override SqlExpression VisitColumn(SqlColumn col) { throw Error.UnexpectedFloatingColumn(); } } internal class ExpectNoAliasRefs : SqlVisitor { internal override SqlExpression VisitAliasRef(SqlAliasRef aref) { throw Error.UnexpectedNode(aref.NodeType); } } internal class ExpectNoSharedExpressions : SqlVisitor { internal override SqlExpression VisitSharedExpression(SqlSharedExpression shared) { throw Error.UnexpectedSharedExpression(); } internal override SqlExpression VisitSharedExpressionRef(SqlSharedExpressionRef sref) { throw Error.UnexpectedSharedExpressionReference(); } } ////// Determines if there is a boolean NText/Text/Image comparison and if so throws an exception /// because this is not valid in SQLServer. /// internal class ValidateNoInvalidComparison : SqlVisitor { internal override SqlExpression VisitBinaryOperator(SqlBinary bo) { if (bo.NodeType == SqlNodeType.EQ || bo.NodeType == SqlNodeType.NE || bo.NodeType == SqlNodeType.EQ2V || bo.NodeType == SqlNodeType.NE2V || bo.NodeType == SqlNodeType.GT || bo.NodeType == SqlNodeType.GE || bo.NodeType == SqlNodeType.LT || bo.NodeType == SqlNodeType.LE ) { if (!bo.Left.SqlType.SupportsComparison || !bo.Right.SqlType.SupportsComparison){ throw Error.UnhandledStringTypeComparison(); } } bo.Left = this.VisitExpression(bo.Left); bo.Right = this.VisitExpression(bo.Right); return bo; } } } // 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; namespace System.Data.Linq.SqlClient { ////// Validates the integrity of super-SQL trees. /// internal class SqlSupersetValidator { Listvalidators = new List (); /// /// Add a validator to the collection of validators to run. /// internal void AddValidator(SqlVisitor validator) { this.validators.Add(validator); } ////// Execute each current validator. /// internal void Validate(SqlNode node) { foreach (SqlVisitor validator in this.validators) { validator.Visit(node); } } } ////// Column ClrType must agree with the expression that it points to. /// internal class ColumnTypeValidator : SqlVisitor { internal override SqlRow VisitRow(SqlRow row) { for (int i = 0, n = row.Columns.Count; i < n; i++) { SqlColumn col = row.Columns[i]; SqlExpression expr = this.VisitExpression(col.Expression); if (expr != null) { if (TypeSystem.GetNonNullableType(col.ClrType) != TypeSystem.GetNonNullableType(expr.ClrType)) { throw Error.ColumnClrTypeDoesNotAgreeWithExpressionsClrType(); } } } return row; } } ////// A validator that ensures literal values are reasonable. /// internal class LiteralValidator : SqlVisitor { internal override SqlExpression VisitValue(SqlValue value) { if (!value.IsClientSpecified && value.ClrType.IsClass && value.ClrType != typeof(string) && value.ClrType != typeof(Type) && value.Value != null) { throw Error.ClassLiteralsNotAllowed(value.ClrType); } return value; } internal override SqlExpression VisitBinaryOperator(SqlBinary bo) { bo.Left = this.VisitExpression(bo.Left); return bo; } } ////// A validator which enforces rationalized boolean expressions. /// internal class ExpectRationalizedBooleans : SqlBooleanMismatchVisitor { internal ExpectRationalizedBooleans() { } internal override SqlExpression ConvertValueToPredicate(SqlExpression bitExpression) { throw Error.ExpectedPredicateFoundBit(); } internal override SqlExpression ConvertPredicateToValue(SqlExpression predicateExpression) { throw Error.ExpectedBitFoundPredicate(); } } ////// A validator which enforces that no more SqlMethodCall nodes exist in the tree. /// internal class ExpectNoMethodCalls : SqlVisitor { internal override SqlExpression VisitMethodCall(SqlMethodCall mc) { // eventually we may support this type of stuff given the SQL CLR, but for now it is illegal throw Error.MethodHasNoSupportConversionToSql(mc.Method.Name); } // check everything except selection expressions (which will be client or ignored) internal override SqlSelect VisitSelect(SqlSelect select) { select.From = this.VisitSource(select.From); select.Where = this.VisitExpression(select.Where); for (int i = 0, n = select.GroupBy.Count; i < n; i++) { select.GroupBy[i] = this.VisitExpression(select.GroupBy[i]); } select.Having = this.VisitExpression(select.Having); for (int i = 0, n = select.OrderBy.Count; i < n; i++) { select.OrderBy[i].Expression = this.VisitExpression(select.OrderBy[i].Expression); } select.Top = this.VisitExpression(select.Top); //select.Selection = this.VisitExpression(select.Selection); select.Row = (SqlRow)this.Visit(select.Row); return select; } } internal class ExpectNoFloatingColumns : SqlVisitor { internal override SqlRow VisitRow(SqlRow row) { foreach (SqlColumn c in row.Columns) { this.Visit(c.Expression); } return row; } internal override SqlTable VisitTable(SqlTable tab) { foreach (SqlColumn c in tab.Columns) { this.Visit(c.Expression); } return tab; } internal override SqlExpression VisitColumn(SqlColumn col) { throw Error.UnexpectedFloatingColumn(); } } internal class ExpectNoAliasRefs : SqlVisitor { internal override SqlExpression VisitAliasRef(SqlAliasRef aref) { throw Error.UnexpectedNode(aref.NodeType); } } internal class ExpectNoSharedExpressions : SqlVisitor { internal override SqlExpression VisitSharedExpression(SqlSharedExpression shared) { throw Error.UnexpectedSharedExpression(); } internal override SqlExpression VisitSharedExpressionRef(SqlSharedExpressionRef sref) { throw Error.UnexpectedSharedExpressionReference(); } } ////// Determines if there is a boolean NText/Text/Image comparison and if so throws an exception /// because this is not valid in SQLServer. /// internal class ValidateNoInvalidComparison : SqlVisitor { internal override SqlExpression VisitBinaryOperator(SqlBinary bo) { if (bo.NodeType == SqlNodeType.EQ || bo.NodeType == SqlNodeType.NE || bo.NodeType == SqlNodeType.EQ2V || bo.NodeType == SqlNodeType.NE2V || bo.NodeType == SqlNodeType.GT || bo.NodeType == SqlNodeType.GE || bo.NodeType == SqlNodeType.LT || bo.NodeType == SqlNodeType.LE ) { if (!bo.Left.SqlType.SupportsComparison || !bo.Right.SqlType.SupportsComparison){ throw Error.UnhandledStringTypeComparison(); } } bo.Left = this.VisitExpression(bo.Left); bo.Right = this.VisitExpression(bo.Right); return bo; } } } // 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
- WindowsAltTab.cs
- SafeNativeMethods.cs
- RelationshipDetailsRow.cs
- CodeIdentifier.cs
- QuotedStringFormatReader.cs
- PathData.cs
- PositiveTimeSpanValidator.cs
- SHA512Managed.cs
- ObjectItemConventionAssemblyLoader.cs
- PropertyDescriptorCollection.cs
- EditBehavior.cs
- CommonXSendMessage.cs
- SqlClientFactory.cs
- AvTraceDetails.cs
- UntrustedRecipientException.cs
- ClientScriptManagerWrapper.cs
- EmulateRecognizeCompletedEventArgs.cs
- MouseBinding.cs
- DocobjHost.cs
- COM2ExtendedTypeConverter.cs
- SqlDataSourceSelectingEventArgs.cs
- WebPartHeaderCloseVerb.cs
- WindowsClientElement.cs
- SelectionRangeConverter.cs
- Icon.cs
- NativeMethods.cs
- MethodBuilderInstantiation.cs
- TraceUtils.cs
- InsufficientMemoryException.cs
- CollectionViewGroupInternal.cs
- URLIdentityPermission.cs
- ControlBuilder.cs
- DLinqAssociationProvider.cs
- CreateUserErrorEventArgs.cs
- InternalResources.cs
- BitmapSource.cs
- DataGridViewCellParsingEventArgs.cs
- SafeTimerHandle.cs
- RSACryptoServiceProvider.cs
- SchemaHelper.cs
- TabletDeviceInfo.cs
- SynchronizationContext.cs
- DbParameterHelper.cs
- ResourceCategoryAttribute.cs
- Convert.cs
- ConnectionManagementSection.cs
- SiteMapNodeCollection.cs
- ResourceReferenceExpressionConverter.cs
- ArraySortHelper.cs
- ControlCommandSet.cs
- ConnectionPointGlyph.cs
- EventSetter.cs
- EventSetter.cs
- QueryCacheKey.cs
- baseshape.cs
- BaseValidator.cs
- DragDropManager.cs
- CodeObjectCreateExpression.cs
- WebPartActionVerb.cs
- ExtensionSimplifierMarkupObject.cs
- SafeReadContext.cs
- EntityKey.cs
- JumpItem.cs
- SequentialOutput.cs
- TextElementEditingBehaviorAttribute.cs
- ColorContextHelper.cs
- CompositionDesigner.cs
- SvcFileManager.cs
- TemplateXamlTreeBuilder.cs
- DeploymentSection.cs
- IteratorAsyncResult.cs
- TimelineGroup.cs
- BamlLocalizer.cs
- PackageFilter.cs
- ReadOnlyKeyedCollection.cs
- Schema.cs
- ArcSegment.cs
- EntityCollection.cs
- InstanceDescriptor.cs
- ApplicationBuildProvider.cs
- SimpleTypesSurrogate.cs
- VirtualizedItemPattern.cs
- MarkupExtensionSerializer.cs
- UInt16Storage.cs
- ToolStripTextBox.cs
- FunctionDefinition.cs
- ChangesetResponse.cs
- LinqMaximalSubtreeNominator.cs
- StructuredTypeInfo.cs
- MethodRental.cs
- OSFeature.cs
- XmlSchemaType.cs
- IdentityHolder.cs
- KeySplineConverter.cs
- DataContractJsonSerializerOperationBehavior.cs
- ThreadAbortException.cs
- KeyNotFoundException.cs
- FixedPageProcessor.cs
- StringValueSerializer.cs
- Grant.cs