Code:
/ 4.0 / 4.0 / untmp / DEVDIV_TFS / Dev10 / Releases / RTMRel / ndp / fx / src / DLinq / Dlinq / SqlClient / Query / SqlExpressionNullability.cs / 1305376 / SqlExpressionNullability.cs
using System; using System.Collections; using System.Collections.Generic; using System.Data; using System.Reflection; using System.Text; using System.Linq; using System.Linq.Expressions; using System.Data.Linq; using System.Data.Linq.Provider; using System.Diagnostics.CodeAnalysis; namespace System.Data.Linq.SqlClient { internal static class SqlExpressionNullability { ////// Determines whether the given expression may return a null result. /// /// The expression to check. ///null means that it couldn't be determined [SuppressMessage("Microsoft.Maintainability", "CA1502:AvoidExcessiveComplexity", Justification="These issues are related to our use of if-then and case statements for node types, which adds to the complexity count however when reviewed they are easy to navigate and understand.")] internal static bool? CanBeNull(SqlExpression expr) { switch (expr.NodeType) { case SqlNodeType.ExprSet: SqlExprSet exprSet = (SqlExprSet)expr; return CanBeNull(exprSet.Expressions); case SqlNodeType.SimpleCase: SqlSimpleCase sc = (SqlSimpleCase)expr; return CanBeNull(sc.Whens.Select(w => w.Value)); case SqlNodeType.Column: SqlColumn col = (SqlColumn)expr; if (col.MetaMember != null) { return col.MetaMember.CanBeNull; } else if (col.Expression != null) { return CanBeNull(col.Expression); } return null; // Don't know. case SqlNodeType.ColumnRef: SqlColumnRef cref = (SqlColumnRef)expr; return CanBeNull(cref.Column); case SqlNodeType.Value: return ((SqlValue)expr).Value == null; case SqlNodeType.New: case SqlNodeType.Multiset: case SqlNodeType.Grouping: case SqlNodeType.DiscriminatedType: case SqlNodeType.IsNotNull: // IsNull\IsNotNull always return true or false and can never return NULL. case SqlNodeType.IsNull: case SqlNodeType.Exists: return false; case SqlNodeType.Add: case SqlNodeType.Sub: case SqlNodeType.Mul: case SqlNodeType.Div: case SqlNodeType.Mod: case SqlNodeType.BitAnd: case SqlNodeType.BitOr: case SqlNodeType.BitXor: case SqlNodeType.Concat: { SqlBinary bop = (SqlBinary)expr; bool? left = CanBeNull(bop.Left); bool? right = CanBeNull(bop.Right); return (left != false) || (right != false); } case SqlNodeType.Negate: case SqlNodeType.BitNot: { SqlUnary uop = (SqlUnary)expr; return CanBeNull(uop.Operand); } case SqlNodeType.Lift: { SqlLift lift = (SqlLift)expr; return CanBeNull(lift.Expression); } case SqlNodeType.OuterJoinedValue: return true; default: return null; // Don't know. } } ////// Used to determine nullability for a collection of expressions. /// * If at least one of the expressions is nullable, the collection is nullable. /// * If no expressions are nullable, but at least one is 'don't know', the collection is 'don't know'. /// * Otherwise all expressions are non-nullable and the nullability is false. /// private static bool? CanBeNull(IEnumerableexprs) { bool hasAtleastOneUnknown = false; foreach(SqlExpression e in exprs) { bool? nullability = CanBeNull(e); // Even one expression that could return null means the // collection can return null. if (nullability == true) return true; // If there is one or more 'unknown' and no definitely nullable // results then the collection nullability is 'unknown'. if (nullability == null) hasAtleastOneUnknown = true; } if (hasAtleastOneUnknown) return null; return false; } } } // 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
- PageSettings.cs
- DoubleAnimation.cs
- DataGrid.cs
- PageStatePersister.cs
- IISUnsafeMethods.cs
- DiagnosticTraceSource.cs
- AndMessageFilter.cs
- FrameworkElement.cs
- Regex.cs
- SocketSettings.cs
- AppDomainFactory.cs
- PipelineModuleStepContainer.cs
- Opcode.cs
- ClientApiGenerator.cs
- ConnectionStringsExpressionBuilder.cs
- ConfigurationPropertyAttribute.cs
- TextServicesCompartmentContext.cs
- DocumentPageView.cs
- ComponentEditorPage.cs
- DiagnosticTrace.cs
- XamlSerializationHelper.cs
- TypefaceMetricsCache.cs
- CollectionViewGroupRoot.cs
- CounterCreationDataCollection.cs
- RubberbandSelector.cs
- RuntimeConfig.cs
- ProcessManager.cs
- FontFamilyIdentifier.cs
- Int64Converter.cs
- IconHelper.cs
- TypeConverterHelper.cs
- Manipulation.cs
- BaseDataListActionList.cs
- XmlWrappingReader.cs
- ConfigXmlAttribute.cs
- PersonalizationProviderCollection.cs
- XmlNotation.cs
- EventDescriptorCollection.cs
- SignatureToken.cs
- WebHttpBehavior.cs
- Splitter.cs
- LogArchiveSnapshot.cs
- ListDataHelper.cs
- _CommandStream.cs
- AsnEncodedData.cs
- ContainsSearchOperator.cs
- URLString.cs
- WindowsTokenRoleProvider.cs
- ComponentEvent.cs
- SqlGatherConsumedAliases.cs
- TransformGroup.cs
- Errors.cs
- HttpCookiesSection.cs
- WindowsListViewItemCheckBox.cs
- SafeHandles.cs
- CodeDomComponentSerializationService.cs
- EntityDataReader.cs
- CodeDomLocalizationProvider.cs
- ExpressionBuilderCollection.cs
- HttpStreamFormatter.cs
- CellLabel.cs
- HandledMouseEvent.cs
- _UriTypeConverter.cs
- EdmComplexPropertyAttribute.cs
- CookieProtection.cs
- AesManaged.cs
- QilName.cs
- HeaderLabel.cs
- FlowDocumentScrollViewer.cs
- ProfileGroupSettingsCollection.cs
- CustomCredentialPolicy.cs
- ContravarianceAdapter.cs
- CodeSubDirectory.cs
- DataGridViewColumnHeaderCell.cs
- ReferenceSchema.cs
- IndentedWriter.cs
- MemoryStream.cs
- MultilineStringConverter.cs
- Transform3D.cs
- SqlRowUpdatedEvent.cs
- TreeNodeCollectionEditorDialog.cs
- CompiledQuery.cs
- ScriptResourceHandler.cs
- RetrieveVirtualItemEventArgs.cs
- SignatureResourcePool.cs
- FlatButtonAppearance.cs
- DataTemplateKey.cs
- WasHttpHandlersInstallComponent.cs
- ProcessThreadCollection.cs
- __TransparentProxy.cs
- TrackingRecord.cs
- DescriptionAttribute.cs
- elementinformation.cs
- MissingFieldException.cs
- XamlTemplateSerializer.cs
- DefaultAuthorizationContext.cs
- PassportAuthenticationEventArgs.cs
- WebServiceFaultDesigner.cs
- ReflectionTypeLoadException.cs
- PackageRelationship.cs