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
- CompilationUnit.cs
- ResolveNameEventArgs.cs
- ControlParameter.cs
- IteratorFilter.cs
- DesignerDataRelationship.cs
- Queue.cs
- RootProfilePropertySettingsCollection.cs
- Padding.cs
- MoveSizeWinEventHandler.cs
- WebPartConnectVerb.cs
- HandleCollector.cs
- ReachFixedDocumentSerializer.cs
- ListViewTableCell.cs
- DoubleLink.cs
- ApplicationDirectory.cs
- ExecutionScope.cs
- SoapSchemaImporter.cs
- CodeSubDirectory.cs
- SystemFonts.cs
- SafeSecurityHandles.cs
- DATA_BLOB.cs
- GridViewUpdatedEventArgs.cs
- WindowsSolidBrush.cs
- CharacterHit.cs
- DesignerCategoryAttribute.cs
- SoapClientProtocol.cs
- BaseCollection.cs
- ThaiBuddhistCalendar.cs
- XmlAttributeHolder.cs
- Compiler.cs
- SequentialUshortCollection.cs
- HostedTcpTransportManager.cs
- AmbientProperties.cs
- ResizeBehavior.cs
- TransactionScope.cs
- FunctionDescription.cs
- TreeNodeConverter.cs
- LayoutInformation.cs
- NativeMethods.cs
- DataGridView.cs
- TextBox.cs
- CatalogPartCollection.cs
- IndexedEnumerable.cs
- OdbcError.cs
- DifferencingCollection.cs
- SqlSupersetValidator.cs
- KeyFrames.cs
- ImageField.cs
- StorageRoot.cs
- KeyConverter.cs
- XslVisitor.cs
- SamlAction.cs
- IdentifierCreationService.cs
- EntityCommandCompilationException.cs
- ParenthesizePropertyNameAttribute.cs
- CodeSnippetStatement.cs
- BindingMAnagerBase.cs
- SqlMethodCallConverter.cs
- DrawingImage.cs
- BufferBuilder.cs
- BaseHashHelper.cs
- Internal.cs
- ExpressionList.cs
- StreamingContext.cs
- UnionExpr.cs
- ParserContext.cs
- CodeTypeOfExpression.cs
- ListBindingConverter.cs
- FastEncoder.cs
- FragmentQueryKB.cs
- LicFileLicenseProvider.cs
- X509UI.cs
- SuppressMessageAttribute.cs
- RowsCopiedEventArgs.cs
- ScriptManager.cs
- SqlPersistenceProviderFactory.cs
- ViewDesigner.cs
- httpserverutility.cs
- EventToken.cs
- RunClient.cs
- XmlSchemaComplexType.cs
- KeyedHashAlgorithm.cs
- Quad.cs
- DynamicUpdateCommand.cs
- JsonGlobals.cs
- SqlReorderer.cs
- FormViewRow.cs
- SelectionProviderWrapper.cs
- VersionPair.cs
- PanningMessageFilter.cs
- ListBoxAutomationPeer.cs
- AsnEncodedData.cs
- HwndSource.cs
- DataColumnMapping.cs
- DataSourceExpressionCollection.cs
- SimpleWorkerRequest.cs
- ComponentResourceKey.cs
- TreeViewImageKeyConverter.cs
- SingleResultAttribute.cs
- UncommonField.cs