Code:
/ Dotnetfx_Win7_3.5.1 / Dotnetfx_Win7_3.5.1 / 3.5.1 / DEVDIV / depot / DevDiv / releases / Orcas / NetFXw7 / ndp / fx / src / DataEntity / System / Data / Common / DbCommandDefinition.cs / 1 / DbCommandDefinition.cs
//------------------------------------------------------------------------------ //// Copyright (c) Microsoft Corporation. All rights reserved. // // // @owner [....], [....] //----------------------------------------------------------------------------- using System.Diagnostics; using System.Data.Metadata.Edm; namespace System.Data.Common { ////// A prepared command definition, can be cached and reused to avoid /// repreparing a command. /// [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Naming", "CA1709:IdentifiersShouldBeCasedCorrectly", MessageId = "Db")] public class DbCommandDefinition { private readonly ICloneable _prototype; ////// Internal factory method to create the default Command Definition object /// based on a prototype command. The prototype command is cloned /// before the protected constructor is invoked /// /// prototype DbCommand ///the DbCommandDefinition internal static DbCommandDefinition CreateCommandDefinition(DbCommand prototype) { EntityUtil.CheckArgumentNull(prototype, "prototype"); ICloneable cloneablePrototype = prototype as ICloneable; if (null == cloneablePrototype) { throw EntityUtil.CannotCloneStoreProvider(); } DbCommand clonedPrototype = (DbCommand)(cloneablePrototype.Clone()); return new DbCommandDefinition(clonedPrototype); } ////// Protected constructor; the command is assumed to be a prototype /// that will be cloned on CreateCommand, and the cloned command will be executed. /// protected DbCommandDefinition(DbCommand prototype) { EntityUtil.CheckArgumentNull(prototype, "prototype"); _prototype = prototype as ICloneable; if (null == _prototype) { throw EntityUtil.CannotCloneStoreProvider(); } } ////// Constructor overload for subclasses to use /// protected DbCommandDefinition() { } ////// Create a DbCommand object from the definition, that can be executed. /// ///public virtual DbCommand CreateCommand() { return (DbCommand)(_prototype.Clone()); } internal static void PopulateParameterFromTypeUsage(DbParameter parameter, TypeUsage type, bool isOutParam) { EntityUtil.CheckArgumentNull(parameter, "parameter"); EntityUtil.CheckArgumentNull(type, "type"); // parameter.IsNullable - from the NullableConstraintAttribute value parameter.IsNullable = TypeSemantics.IsNullable(type); // parameter.ParameterName - set by the caller; // parameter.SourceColumn - not applicable until we have a data adapter; // parameter.SourceColumnNullMapping - not applicable until we have a data adapter; // parameter.SourceVersion - not applicable until we have a data adapter; // parameter.Value - left unset; // parameter.DbType - determined by the TypeMapping; // parameter.Precision - from the TypeMapping; // parameter.Scale - from the TypeMapping; // parameter.Size - from the TypeMapping; Debug.Assert(null != type, "no type mapping?"); if (TypeSemantics.IsPrimitiveType(type, Metadata.Edm.PrimitiveTypeKind.Binary)) { PopulateBinaryParameter(parameter, type, DbType.Binary, isOutParam); } else if (TypeSemantics.IsPrimitiveType(type, PrimitiveTypeKind.Boolean)) { parameter.DbType = DbType.Boolean; } else if (TypeSemantics.IsPrimitiveType(type, PrimitiveTypeKind.Byte)) { parameter.DbType = DbType.Byte; } else if (TypeSemantics.IsPrimitiveType(type, PrimitiveTypeKind.DateTime)) { PopulateDateTimeParameter(parameter, type, DbType.DateTime); } else if (TypeSemantics.IsPrimitiveType(type, PrimitiveTypeKind.Time)) { PopulateDateTimeParameter(parameter, type, DbType.Time); } else if (TypeSemantics.IsPrimitiveType(type, PrimitiveTypeKind.DateTimeOffset)) { PopulateDateTimeParameter(parameter, type, DbType.DateTimeOffset); } else if (TypeSemantics.IsPrimitiveType(type, PrimitiveTypeKind.Decimal)) { PopulateDecimalParameter(parameter, type, DbType.Decimal); } else if (TypeSemantics.IsPrimitiveType(type, PrimitiveTypeKind.Double)) { parameter.DbType = DbType.Double; } else if (TypeSemantics.IsPrimitiveType(type, PrimitiveTypeKind.Guid)) { parameter.DbType = DbType.Guid; } else if (TypeSemantics.IsPrimitiveType(type, PrimitiveTypeKind.Single)) { parameter.DbType = DbType.Single; } else if (TypeSemantics.IsPrimitiveType(type, PrimitiveTypeKind.SByte)) { parameter.DbType = DbType.SByte; } else if (TypeSemantics.IsPrimitiveType(type, PrimitiveTypeKind.Int16)) { parameter.DbType = DbType.Int16; } else if (TypeSemantics.IsPrimitiveType(type, PrimitiveTypeKind.Int32)) { parameter.DbType = DbType.Int32; } else if (TypeSemantics.IsPrimitiveType(type, PrimitiveTypeKind.Int64)) { parameter.DbType = DbType.Int64; } else if (TypeSemantics.IsPrimitiveType(type, PrimitiveTypeKind.String)) { PopulateStringParameter(parameter, type, isOutParam); } } private static void PopulateBinaryParameter(DbParameter parameter, TypeUsage type, DbType dbType, bool isOutParam) { parameter.DbType = dbType; // For each facet, set the facet value only if we have it, note that it's possible to not have // it in the case the facet value is null SetParameterSize(parameter, type, isOutParam); } private static void PopulateDecimalParameter (DbParameter parameter, TypeUsage type, DbType dbType) { parameter.DbType = dbType; IDbDataParameter dataParameter = (IDbDataParameter)parameter; // For each facet, set the facet value only if we have it, note that it's possible to not have // it in the case the facet value is null byte precision; byte scale; if (TypeHelpers.TryGetPrecision(type, out precision)) { dataParameter.Precision = precision; } if (TypeHelpers.TryGetScale(type, out scale)) { dataParameter.Scale = scale; } } private static void PopulateDateTimeParameter(DbParameter parameter, TypeUsage type, DbType dbType) { parameter.DbType = dbType; IDbDataParameter dataParameter = (IDbDataParameter)parameter; // For each facet, set the facet value only if we have it, note that it's possible to not have // it in the case the facet value is null byte precision; if (TypeHelpers.TryGetPrecision(type, out precision)) { dataParameter.Precision = precision; } } private static void PopulateStringParameter(DbParameter parameter, TypeUsage type, bool isOutParam) { // For each facet, set the facet value only if we have it, note that it's possible to not have // it in the case the facet value is null bool unicode = true; bool fixedLength = false; if (!TypeHelpers.TryGetIsFixedLength(type, out fixedLength)) { // If we can't get the fixed length facet value, then default to fixed length = false fixedLength = false; } if (!TypeHelpers.TryGetIsUnicode(type, out unicode)) { // If we can't get the unicode facet value, then default to unicode = true unicode = true; } if (fixedLength) { parameter.DbType = (unicode ? DbType.StringFixedLength : DbType.AnsiStringFixedLength); } else { parameter.DbType = (unicode ? DbType.String : DbType.AnsiString); } SetParameterSize(parameter, type, isOutParam); } private static void SetParameterSize(DbParameter parameter, TypeUsage type, bool isOutParam) { // only set the size if the parameter has a specific size value. Facet maxLengthFacet; if (type.Facets.TryGetValue(DbProviderManifest.MaxLengthFacetName, true, out maxLengthFacet) && maxLengthFacet.Value != null) { // only set size if there is a specific size if (!Helper.IsUnboundedFacetValue(maxLengthFacet)) { parameter.Size = (int)maxLengthFacet.Value; } else if (isOutParam) { // if it is store procedure parameter and it is unbounded set the size to max parameter.Size = Int32.MaxValue; } } } } } // File provided for Reference Use Only by Microsoft Corporation (c) 2007. //------------------------------------------------------------------------------ // // Copyright (c) Microsoft Corporation. All rights reserved. // // // @owner [....], [....] //----------------------------------------------------------------------------- using System.Diagnostics; using System.Data.Metadata.Edm; namespace System.Data.Common { ////// A prepared command definition, can be cached and reused to avoid /// repreparing a command. /// [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Naming", "CA1709:IdentifiersShouldBeCasedCorrectly", MessageId = "Db")] public class DbCommandDefinition { private readonly ICloneable _prototype; ////// Internal factory method to create the default Command Definition object /// based on a prototype command. The prototype command is cloned /// before the protected constructor is invoked /// /// prototype DbCommand ///the DbCommandDefinition internal static DbCommandDefinition CreateCommandDefinition(DbCommand prototype) { EntityUtil.CheckArgumentNull(prototype, "prototype"); ICloneable cloneablePrototype = prototype as ICloneable; if (null == cloneablePrototype) { throw EntityUtil.CannotCloneStoreProvider(); } DbCommand clonedPrototype = (DbCommand)(cloneablePrototype.Clone()); return new DbCommandDefinition(clonedPrototype); } ////// Protected constructor; the command is assumed to be a prototype /// that will be cloned on CreateCommand, and the cloned command will be executed. /// protected DbCommandDefinition(DbCommand prototype) { EntityUtil.CheckArgumentNull(prototype, "prototype"); _prototype = prototype as ICloneable; if (null == _prototype) { throw EntityUtil.CannotCloneStoreProvider(); } } ////// Constructor overload for subclasses to use /// protected DbCommandDefinition() { } ////// Create a DbCommand object from the definition, that can be executed. /// ///public virtual DbCommand CreateCommand() { return (DbCommand)(_prototype.Clone()); } internal static void PopulateParameterFromTypeUsage(DbParameter parameter, TypeUsage type, bool isOutParam) { EntityUtil.CheckArgumentNull(parameter, "parameter"); EntityUtil.CheckArgumentNull(type, "type"); // parameter.IsNullable - from the NullableConstraintAttribute value parameter.IsNullable = TypeSemantics.IsNullable(type); // parameter.ParameterName - set by the caller; // parameter.SourceColumn - not applicable until we have a data adapter; // parameter.SourceColumnNullMapping - not applicable until we have a data adapter; // parameter.SourceVersion - not applicable until we have a data adapter; // parameter.Value - left unset; // parameter.DbType - determined by the TypeMapping; // parameter.Precision - from the TypeMapping; // parameter.Scale - from the TypeMapping; // parameter.Size - from the TypeMapping; Debug.Assert(null != type, "no type mapping?"); if (TypeSemantics.IsPrimitiveType(type, Metadata.Edm.PrimitiveTypeKind.Binary)) { PopulateBinaryParameter(parameter, type, DbType.Binary, isOutParam); } else if (TypeSemantics.IsPrimitiveType(type, PrimitiveTypeKind.Boolean)) { parameter.DbType = DbType.Boolean; } else if (TypeSemantics.IsPrimitiveType(type, PrimitiveTypeKind.Byte)) { parameter.DbType = DbType.Byte; } else if (TypeSemantics.IsPrimitiveType(type, PrimitiveTypeKind.DateTime)) { PopulateDateTimeParameter(parameter, type, DbType.DateTime); } else if (TypeSemantics.IsPrimitiveType(type, PrimitiveTypeKind.Time)) { PopulateDateTimeParameter(parameter, type, DbType.Time); } else if (TypeSemantics.IsPrimitiveType(type, PrimitiveTypeKind.DateTimeOffset)) { PopulateDateTimeParameter(parameter, type, DbType.DateTimeOffset); } else if (TypeSemantics.IsPrimitiveType(type, PrimitiveTypeKind.Decimal)) { PopulateDecimalParameter(parameter, type, DbType.Decimal); } else if (TypeSemantics.IsPrimitiveType(type, PrimitiveTypeKind.Double)) { parameter.DbType = DbType.Double; } else if (TypeSemantics.IsPrimitiveType(type, PrimitiveTypeKind.Guid)) { parameter.DbType = DbType.Guid; } else if (TypeSemantics.IsPrimitiveType(type, PrimitiveTypeKind.Single)) { parameter.DbType = DbType.Single; } else if (TypeSemantics.IsPrimitiveType(type, PrimitiveTypeKind.SByte)) { parameter.DbType = DbType.SByte; } else if (TypeSemantics.IsPrimitiveType(type, PrimitiveTypeKind.Int16)) { parameter.DbType = DbType.Int16; } else if (TypeSemantics.IsPrimitiveType(type, PrimitiveTypeKind.Int32)) { parameter.DbType = DbType.Int32; } else if (TypeSemantics.IsPrimitiveType(type, PrimitiveTypeKind.Int64)) { parameter.DbType = DbType.Int64; } else if (TypeSemantics.IsPrimitiveType(type, PrimitiveTypeKind.String)) { PopulateStringParameter(parameter, type, isOutParam); } } private static void PopulateBinaryParameter(DbParameter parameter, TypeUsage type, DbType dbType, bool isOutParam) { parameter.DbType = dbType; // For each facet, set the facet value only if we have it, note that it's possible to not have // it in the case the facet value is null SetParameterSize(parameter, type, isOutParam); } private static void PopulateDecimalParameter (DbParameter parameter, TypeUsage type, DbType dbType) { parameter.DbType = dbType; IDbDataParameter dataParameter = (IDbDataParameter)parameter; // For each facet, set the facet value only if we have it, note that it's possible to not have // it in the case the facet value is null byte precision; byte scale; if (TypeHelpers.TryGetPrecision(type, out precision)) { dataParameter.Precision = precision; } if (TypeHelpers.TryGetScale(type, out scale)) { dataParameter.Scale = scale; } } private static void PopulateDateTimeParameter(DbParameter parameter, TypeUsage type, DbType dbType) { parameter.DbType = dbType; IDbDataParameter dataParameter = (IDbDataParameter)parameter; // For each facet, set the facet value only if we have it, note that it's possible to not have // it in the case the facet value is null byte precision; if (TypeHelpers.TryGetPrecision(type, out precision)) { dataParameter.Precision = precision; } } private static void PopulateStringParameter(DbParameter parameter, TypeUsage type, bool isOutParam) { // For each facet, set the facet value only if we have it, note that it's possible to not have // it in the case the facet value is null bool unicode = true; bool fixedLength = false; if (!TypeHelpers.TryGetIsFixedLength(type, out fixedLength)) { // If we can't get the fixed length facet value, then default to fixed length = false fixedLength = false; } if (!TypeHelpers.TryGetIsUnicode(type, out unicode)) { // If we can't get the unicode facet value, then default to unicode = true unicode = true; } if (fixedLength) { parameter.DbType = (unicode ? DbType.StringFixedLength : DbType.AnsiStringFixedLength); } else { parameter.DbType = (unicode ? DbType.String : DbType.AnsiString); } SetParameterSize(parameter, type, isOutParam); } private static void SetParameterSize(DbParameter parameter, TypeUsage type, bool isOutParam) { // only set the size if the parameter has a specific size value. Facet maxLengthFacet; if (type.Facets.TryGetValue(DbProviderManifest.MaxLengthFacetName, true, out maxLengthFacet) && maxLengthFacet.Value != null) { // only set size if there is a specific size if (!Helper.IsUnboundedFacetValue(maxLengthFacet)) { parameter.Size = (int)maxLengthFacet.Value; } else if (isOutParam) { // if it is store procedure parameter and it is unbounded set the size to max parameter.Size = Int32.MaxValue; } } } } } // File provided for Reference Use Only by Microsoft Corporation (c) 2007.
Link Menu
This book is available now!
Buy at Amazon US or
Buy at Amazon UK
- IndexOutOfRangeException.cs
- DataServices.cs
- linebase.cs
- LinqDataSource.cs
- ProjectionRewriter.cs
- WmiPutTraceRecord.cs
- TypeEnumerableViewSchema.cs
- HTMLTextWriter.cs
- SqlLiftIndependentRowExpressions.cs
- WindowsScrollBar.cs
- HotCommands.cs
- VScrollBar.cs
- NavigationEventArgs.cs
- ContractMapping.cs
- WinFormsUtils.cs
- FixedFindEngine.cs
- StateMachineSubscriptionManager.cs
- VisualCollection.cs
- FaultBookmark.cs
- SystemTcpConnection.cs
- HMAC.cs
- WebPartConnectVerb.cs
- ListSortDescriptionCollection.cs
- Resources.Designer.cs
- ProcessThread.cs
- ActiveXSite.cs
- VectorAnimationBase.cs
- LocalizedNameDescriptionPair.cs
- X509CertificateCollection.cs
- SystemIcmpV4Statistics.cs
- WindowsScrollBarBits.cs
- GatewayDefinition.cs
- WebRequestModuleElement.cs
- LightweightEntityWrapper.cs
- IImplicitResourceProvider.cs
- InputBuffer.cs
- Types.cs
- EventRoute.cs
- DecoderNLS.cs
- PackageFilter.cs
- EntitySqlQueryBuilder.cs
- ResourcesChangeInfo.cs
- TransformerTypeCollection.cs
- Int16Converter.cs
- OdbcEnvironment.cs
- ExceptionUtil.cs
- Queue.cs
- MetadataPropertyCollection.cs
- PrivilegeNotHeldException.cs
- WorkflowApplicationCompletedException.cs
- RegexCompilationInfo.cs
- TemplateBaseAction.cs
- ScrollBar.cs
- EditorPartChrome.cs
- safex509handles.cs
- FixedDocumentPaginator.cs
- CompilerGeneratedAttribute.cs
- ObjectContext.cs
- ResourcePart.cs
- DataGridColumnHeadersPresenterAutomationPeer.cs
- HttpGetServerProtocol.cs
- CodeComment.cs
- XmlUtf8RawTextWriter.cs
- SessionPageStatePersister.cs
- LinkClickEvent.cs
- SystemWebExtensionsSectionGroup.cs
- TemplateXamlParser.cs
- MarkupObject.cs
- CookielessHelper.cs
- VarRemapper.cs
- Pointer.cs
- DefaultEventAttribute.cs
- Token.cs
- RayHitTestParameters.cs
- DataServiceOperationContext.cs
- xsdvalidator.cs
- SafeNativeMethods.cs
- FixedLineResult.cs
- MemoryResponseElement.cs
- JournalEntry.cs
- NamedPipeProcessProtocolHandler.cs
- DbUpdateCommandTree.cs
- DataGridViewDataErrorEventArgs.cs
- SrgsRule.cs
- PersonalizationStateInfo.cs
- ComponentConverter.cs
- StackSpiller.cs
- DataGridViewLinkCell.cs
- WriteLineDesigner.xaml.cs
- PhonemeEventArgs.cs
- BrowserCapabilitiesCodeGenerator.cs
- CodeMethodInvokeExpression.cs
- HttpHandlersSection.cs
- WSSecurityOneDotZeroSendSecurityHeader.cs
- SpellerStatusTable.cs
- PositiveTimeSpanValidator.cs
- DeferredElementTreeState.cs
- SafeHandle.cs
- BaseDataBoundControl.cs
- IBuiltInEvidence.cs