Code:
/ Dotnetfx_Vista_SP2 / Dotnetfx_Vista_SP2 / 8.0.50727.4016 / DEVDIV / depot / DevDiv / releases / Orcas / QFE / 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
- ClonableStack.cs
- BufferModesCollection.cs
- ProxyElement.cs
- ADMembershipProvider.cs
- ReferenceSchema.cs
- TcpProcessProtocolHandler.cs
- CodeDomSerializerException.cs
- PlanCompiler.cs
- LambdaCompiler.Address.cs
- SHA1Managed.cs
- HttpRuntimeSection.cs
- ViewCellRelation.cs
- StylusCaptureWithinProperty.cs
- CqlLexerHelpers.cs
- BitmapData.cs
- SoapAttributeAttribute.cs
- ScriptReference.cs
- XmlSchemaImporter.cs
- InkCanvas.cs
- SqlProviderServices.cs
- WebHeaderCollection.cs
- Win32Interop.cs
- MembershipValidatePasswordEventArgs.cs
- TaiwanCalendar.cs
- Documentation.cs
- AggregateNode.cs
- XmlSerializerSection.cs
- HtmlContainerControl.cs
- Ticks.cs
- ConfigXmlElement.cs
- KeyBinding.cs
- _SingleItemRequestCache.cs
- PerfService.cs
- CheckBoxField.cs
- ModelPropertyCollectionImpl.cs
- XmlAttributeAttribute.cs
- BitmapEffectGroup.cs
- SqlLiftIndependentRowExpressions.cs
- XmlFormatMapping.cs
- MarkupProperty.cs
- NonBatchDirectoryCompiler.cs
- SpecialTypeDataContract.cs
- OutKeywords.cs
- LogSwitch.cs
- Int32RectValueSerializer.cs
- PagerSettings.cs
- MenuScrollingVisibilityConverter.cs
- StaticFileHandler.cs
- KernelTypeValidation.cs
- CodeSubDirectory.cs
- XmlEncodedRawTextWriter.cs
- ProjectionAnalyzer.cs
- Stylus.cs
- GridViewCancelEditEventArgs.cs
- SimpleType.cs
- Encoding.cs
- MultiView.cs
- TraceProvider.cs
- DataBindingHandlerAttribute.cs
- BaseTemplateBuildProvider.cs
- BooleanFunctions.cs
- DependencyPropertyDescriptor.cs
- ObjectListCommand.cs
- KnownBoxes.cs
- ConfigurationManagerInternalFactory.cs
- StringExpressionSet.cs
- UInt64Converter.cs
- BoundPropertyEntry.cs
- KeyNotFoundException.cs
- SapiInterop.cs
- TogglePattern.cs
- SecurityTokenSerializer.cs
- ComponentChangingEvent.cs
- GeometryCollection.cs
- OleDragDropHandler.cs
- SizeConverter.cs
- SettingsPropertyWrongTypeException.cs
- PathNode.cs
- TemplateXamlTreeBuilder.cs
- CodeGenerator.cs
- SQLInt32.cs
- X509UI.cs
- RC2.cs
- OleDbEnumerator.cs
- DoubleCollectionValueSerializer.cs
- DataGridBeginningEditEventArgs.cs
- StringOutput.cs
- CounterCreationDataCollection.cs
- COM2IPerPropertyBrowsingHandler.cs
- WebPartConnectionsCancelEventArgs.cs
- MessageAction.cs
- TypeRestriction.cs
- Pen.cs
- EventLog.cs
- MobileControlPersister.cs
- CanonicalXml.cs
- AppDomainCompilerProxy.cs
- GridLength.cs
- BindingsCollection.cs
- AuthorizationRule.cs