Code:
/ Net / Net / 3.5.50727.3053 / DEVDIV / depot / DevDiv / releases / Orcas / SP / ndp / fx / src / DLinq / Dlinq / SqlClient / Query / SqlExpressionNullability.cs / 1 / 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.ObjectType: 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. 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.ObjectType: 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
![Network programming in C#, Network Programming in VB.NET, Network Programming in .NET](/images/book.jpg)
This book is available now!
Buy at Amazon US or
Buy at Amazon UK
- PkcsMisc.cs
- StreamFormatter.cs
- XPathConvert.cs
- Table.cs
- AttributeQuery.cs
- DropDownList.cs
- FlowLayoutSettings.cs
- ButtonPopupAdapter.cs
- SocketManager.cs
- Int64Storage.cs
- MsmqBindingMonitor.cs
- UITypeEditor.cs
- ControlPropertyNameConverter.cs
- InputBinding.cs
- PreApplicationStartMethodAttribute.cs
- KeyTimeConverter.cs
- FtpCachePolicyElement.cs
- KeyInfo.cs
- IndexedGlyphRun.cs
- SignalGate.cs
- TreeNodeStyleCollection.cs
- DbException.cs
- DebugHandleTracker.cs
- ScrollChrome.cs
- WebErrorHandler.cs
- QueueNameHelper.cs
- Expander.cs
- InvalidWMPVersionException.cs
- StatusBarDrawItemEvent.cs
- CodeIdentifiers.cs
- DataSourceSelectArguments.cs
- SurrogateSelector.cs
- SingleObjectCollection.cs
- CompilerError.cs
- DoubleLinkListEnumerator.cs
- ContextMenu.cs
- RadioButtonList.cs
- SpellCheck.cs
- EventProviderBase.cs
- _BaseOverlappedAsyncResult.cs
- TransactionInformation.cs
- _SSPIWrapper.cs
- PolicyLevel.cs
- StylusButton.cs
- XmlBinaryWriter.cs
- RuleSettings.cs
- MemberAssignment.cs
- UriSection.cs
- DrawingAttributeSerializer.cs
- DelegateBodyWriter.cs
- ProvidersHelper.cs
- TemplateNameScope.cs
- SolidColorBrush.cs
- ListViewEditEventArgs.cs
- CreateUserErrorEventArgs.cs
- NodeLabelEditEvent.cs
- ProfileBuildProvider.cs
- InternalsVisibleToAttribute.cs
- MailDefinition.cs
- MediaCommands.cs
- ImageEditor.cs
- AsyncCompletedEventArgs.cs
- WebBaseEventKeyComparer.cs
- AppDomainUnloadedException.cs
- SafeLibraryHandle.cs
- MaskedTextProvider.cs
- XmlSchemaComplexContentRestriction.cs
- MenuItemAutomationPeer.cs
- SafeViewOfFileHandle.cs
- SettingsPropertyValueCollection.cs
- TiffBitmapEncoder.cs
- RefreshPropertiesAttribute.cs
- HttpValueCollection.cs
- MetadataFile.cs
- GridViewItemAutomationPeer.cs
- BaseTransportHeaders.cs
- X509DefaultServiceCertificateElement.cs
- RoleService.cs
- ScrollContentPresenter.cs
- SecurityCriticalDataForSet.cs
- Gdiplus.cs
- DbMetaDataCollectionNames.cs
- InkCanvas.cs
- XMLSchema.cs
- DataGridState.cs
- MarginCollapsingState.cs
- CommandPlan.cs
- Panel.cs
- WebMessageFormatHelper.cs
- Point3DCollection.cs
- ReaderOutput.cs
- ResourceWriter.cs
- IRCollection.cs
- SafeNativeMethods.cs
- LocalBuilder.cs
- ChannelManager.cs
- QueryOperator.cs
- XPathDocumentIterator.cs
- FilePresentation.cs
- OutOfMemoryException.cs