Code:
/ Net / Net / 3.5.50727.3053 / DEVDIV / depot / DevDiv / releases / Orcas / SP / ndp / fx / src / DataEntity / System / Data / Common / Utils / CommandHelper.cs / 3 / CommandHelper.cs
//---------------------------------------------------------------------- //// Copyright (c) Microsoft Corporation. All rights reserved. // // // @owner [....] // @backupOwner [....] //--------------------------------------------------------------------- using System.Diagnostics; using System.Data.Metadata.Edm; using System.Data.EntityClient; using System.Data.Objects; namespace System.Data.Common.Utils { ////// Contains utility methods for construction of DB commands through generic /// provider interfaces. /// internal static class CommandHelper { ////// Consumes all rows and result sets from the reader. This allows client to retrieve /// parameter values and intercept any store exceptions. /// /// reader to consume internal static void ConsumeReader(DbDataReader reader) { if (null != reader && !reader.IsClosed) { while (reader.NextResult()) { // Note that we only walk through the result sets. We don't need // to walk through individual rows (though underlying provider // implementation may do so) } } } ////// requires: commandText must not be null /// The command text must be in the form Container.FunctionImportName. /// internal static void ParseFunctionImportCommandText(string commandText, string defaultContainerName, out string containerName, out string functionImportName) { Debug.Assert(null != commandText); // Split the string string[] nameParts = commandText.Split('.'); containerName = null; functionImportName = null; if (2 == nameParts.Length) { containerName = nameParts[0].Trim(); functionImportName = nameParts[1].Trim(); } else if (1 == nameParts.Length && null != defaultContainerName) { containerName = defaultContainerName; functionImportName = nameParts[0].Trim(); } if (string.IsNullOrEmpty(containerName) || string.IsNullOrEmpty(functionImportName)) { throw EntityUtil.InvalidOperation(System.Data.Entity.Strings.EntityClient_InvalidStoredProcedureCommandText); } } ////// Given an entity command, returns the associated entity transaction and performs validation /// to ensure the transaction is consistent. /// /// Entity command instance. Must not be null. ///Entity transaction internal static EntityTransaction GetEntityTransaction(EntityCommand entityCommand) { Debug.Assert(null != entityCommand); EntityTransaction entityTransaction = (EntityTransaction)entityCommand.Transaction; // Check to make sure that either the command has no transaction associated with it, or it // matches the one used by the connection if (entityTransaction != null && entityTransaction != entityCommand.Connection.CurrentTransaction) { throw EntityUtil.InvalidOperation(System.Data.Entity.Strings.EntityClient_InvalidTransactionForCommand); } // Now we have asserted that EntityCommand either has no transaction or has one that matches the // one used in the connection, we can simply use the connection's transaction object entityTransaction = entityCommand.Connection.CurrentTransaction; return entityTransaction; } ////// Given an entity command and entity transaction, passes through relevant state to store provider /// command. /// /// Entity command. Must not be null. /// Entity transaction. Must not be null. /// Store provider command that is being setup. Must not be null. internal static void SetStoreProviderCommandState(EntityCommand entityCommand, EntityTransaction entityTransaction, DbCommand storeProviderCommand) { Debug.Assert(null != entityCommand); Debug.Assert(null != storeProviderCommand); storeProviderCommand.CommandTimeout = entityCommand.CommandTimeout; storeProviderCommand.Connection = ((EntityConnection)entityCommand.Connection).StoreConnection; storeProviderCommand.Transaction = (null != entityTransaction) ? entityTransaction.StoreTransaction : null; storeProviderCommand.UpdatedRowSource = entityCommand.UpdatedRowSource; } ////// Given an entity command and store provider command, sets all output parameter values on the entity command. /// /// Entity command on which to set parameter values. Must not be null. /// Store provider command from which to retrieve parameter values. Must not /// be null. internal static void SetEntityParameterValues(EntityCommand entityCommand, DbCommand storeProviderCommand) { Debug.Assert(null != entityCommand); Debug.Assert(null != storeProviderCommand); foreach (DbParameter storeParameter in storeProviderCommand.Parameters) { ParameterDirection direction = storeParameter.Direction; if (0 != (direction & ParameterDirection.Output)) { // if the entity command also defines the parameter, propagate store parameter value // to entity parameter int parameterOrdinal = entityCommand.Parameters.IndexOf(storeParameter.ParameterName); if (0 <= parameterOrdinal) { EntityParameter entityParameter = entityCommand.Parameters[parameterOrdinal]; entityParameter.Value = storeParameter.Value; } } } } // requires: all arguments must be given internal static EdmFunction FindFunctionImport(MetadataWorkspace workspace, string containerName, string functionImportName) { Debug.Assert(null != workspace && null != containerName && null != functionImportName); // find entity container EntityContainer entityContainer; if (!workspace.TryGetEntityContainer(containerName, DataSpace.CSpace, out entityContainer)) { throw EntityUtil.InvalidOperation(System.Data.Entity.Strings.EntityClient_UnableToFindFunctionImportContainer( containerName)); } // find function import EdmFunction functionImport = null; foreach (EdmFunction candidate in entityContainer.FunctionImports) { if (candidate.Name == functionImportName) { functionImport = candidate; break; } } if (null == functionImport) { throw EntityUtil.InvalidOperation(System.Data.Entity.Strings.EntityClient_UnableToFindFunctionImport( containerName, functionImportName)); } return functionImport; } } } // File provided for Reference Use Only by Microsoft Corporation (c) 2007. //---------------------------------------------------------------------- //// Copyright (c) Microsoft Corporation. All rights reserved. // // // @owner [....] // @backupOwner [....] //--------------------------------------------------------------------- using System.Diagnostics; using System.Data.Metadata.Edm; using System.Data.EntityClient; using System.Data.Objects; namespace System.Data.Common.Utils { ////// Contains utility methods for construction of DB commands through generic /// provider interfaces. /// internal static class CommandHelper { ////// Consumes all rows and result sets from the reader. This allows client to retrieve /// parameter values and intercept any store exceptions. /// /// reader to consume internal static void ConsumeReader(DbDataReader reader) { if (null != reader && !reader.IsClosed) { while (reader.NextResult()) { // Note that we only walk through the result sets. We don't need // to walk through individual rows (though underlying provider // implementation may do so) } } } ////// requires: commandText must not be null /// The command text must be in the form Container.FunctionImportName. /// internal static void ParseFunctionImportCommandText(string commandText, string defaultContainerName, out string containerName, out string functionImportName) { Debug.Assert(null != commandText); // Split the string string[] nameParts = commandText.Split('.'); containerName = null; functionImportName = null; if (2 == nameParts.Length) { containerName = nameParts[0].Trim(); functionImportName = nameParts[1].Trim(); } else if (1 == nameParts.Length && null != defaultContainerName) { containerName = defaultContainerName; functionImportName = nameParts[0].Trim(); } if (string.IsNullOrEmpty(containerName) || string.IsNullOrEmpty(functionImportName)) { throw EntityUtil.InvalidOperation(System.Data.Entity.Strings.EntityClient_InvalidStoredProcedureCommandText); } } ////// Given an entity command, returns the associated entity transaction and performs validation /// to ensure the transaction is consistent. /// /// Entity command instance. Must not be null. ///Entity transaction internal static EntityTransaction GetEntityTransaction(EntityCommand entityCommand) { Debug.Assert(null != entityCommand); EntityTransaction entityTransaction = (EntityTransaction)entityCommand.Transaction; // Check to make sure that either the command has no transaction associated with it, or it // matches the one used by the connection if (entityTransaction != null && entityTransaction != entityCommand.Connection.CurrentTransaction) { throw EntityUtil.InvalidOperation(System.Data.Entity.Strings.EntityClient_InvalidTransactionForCommand); } // Now we have asserted that EntityCommand either has no transaction or has one that matches the // one used in the connection, we can simply use the connection's transaction object entityTransaction = entityCommand.Connection.CurrentTransaction; return entityTransaction; } ////// Given an entity command and entity transaction, passes through relevant state to store provider /// command. /// /// Entity command. Must not be null. /// Entity transaction. Must not be null. /// Store provider command that is being setup. Must not be null. internal static void SetStoreProviderCommandState(EntityCommand entityCommand, EntityTransaction entityTransaction, DbCommand storeProviderCommand) { Debug.Assert(null != entityCommand); Debug.Assert(null != storeProviderCommand); storeProviderCommand.CommandTimeout = entityCommand.CommandTimeout; storeProviderCommand.Connection = ((EntityConnection)entityCommand.Connection).StoreConnection; storeProviderCommand.Transaction = (null != entityTransaction) ? entityTransaction.StoreTransaction : null; storeProviderCommand.UpdatedRowSource = entityCommand.UpdatedRowSource; } ////// Given an entity command and store provider command, sets all output parameter values on the entity command. /// /// Entity command on which to set parameter values. Must not be null. /// Store provider command from which to retrieve parameter values. Must not /// be null. internal static void SetEntityParameterValues(EntityCommand entityCommand, DbCommand storeProviderCommand) { Debug.Assert(null != entityCommand); Debug.Assert(null != storeProviderCommand); foreach (DbParameter storeParameter in storeProviderCommand.Parameters) { ParameterDirection direction = storeParameter.Direction; if (0 != (direction & ParameterDirection.Output)) { // if the entity command also defines the parameter, propagate store parameter value // to entity parameter int parameterOrdinal = entityCommand.Parameters.IndexOf(storeParameter.ParameterName); if (0 <= parameterOrdinal) { EntityParameter entityParameter = entityCommand.Parameters[parameterOrdinal]; entityParameter.Value = storeParameter.Value; } } } } // requires: all arguments must be given internal static EdmFunction FindFunctionImport(MetadataWorkspace workspace, string containerName, string functionImportName) { Debug.Assert(null != workspace && null != containerName && null != functionImportName); // find entity container EntityContainer entityContainer; if (!workspace.TryGetEntityContainer(containerName, DataSpace.CSpace, out entityContainer)) { throw EntityUtil.InvalidOperation(System.Data.Entity.Strings.EntityClient_UnableToFindFunctionImportContainer( containerName)); } // find function import EdmFunction functionImport = null; foreach (EdmFunction candidate in entityContainer.FunctionImports) { if (candidate.Name == functionImportName) { functionImport = candidate; break; } } if (null == functionImport) { throw EntityUtil.InvalidOperation(System.Data.Entity.Strings.EntityClient_UnableToFindFunctionImport( containerName, functionImportName)); } return functionImport; } } } // 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
- DecimalConstantAttribute.cs
- BaseParser.cs
- ModuleBuilderData.cs
- RegexCharClass.cs
- XmlReflectionImporter.cs
- RedistVersionInfo.cs
- Attachment.cs
- ScriptManagerProxy.cs
- ReadOnlyAttribute.cs
- SecurityKeyIdentifier.cs
- WindowsScrollBar.cs
- _BaseOverlappedAsyncResult.cs
- SecuritySessionSecurityTokenProvider.cs
- StandardToolWindows.cs
- SchemaInfo.cs
- StylusEditingBehavior.cs
- SiteMapDataSource.cs
- InstanceLockLostException.cs
- cookiecollection.cs
- SerializationStore.cs
- safelink.cs
- ResourcesGenerator.cs
- MutexSecurity.cs
- CodeGeneratorOptions.cs
- Events.cs
- Tuple.cs
- XPathDocumentNavigator.cs
- WebPartMinimizeVerb.cs
- PropVariant.cs
- Int16.cs
- KeyGestureConverter.cs
- WarningException.cs
- ComAdminInterfaces.cs
- DataPointer.cs
- ObjectManager.cs
- List.cs
- InputMethod.cs
- ScrollChangedEventArgs.cs
- figurelengthconverter.cs
- OpCellTreeNode.cs
- COM2ExtendedTypeConverter.cs
- Error.cs
- TypeDescriptionProviderAttribute.cs
- RoutedEventValueSerializer.cs
- GetRecipientRequest.cs
- CalendarAutoFormatDialog.cs
- ConfigXmlDocument.cs
- NaturalLanguageHyphenator.cs
- TypeTypeConverter.cs
- MessageBuilder.cs
- SmtpDateTime.cs
- WebException.cs
- HtmlInputHidden.cs
- LoginCancelEventArgs.cs
- HwndAppCommandInputProvider.cs
- PartialArray.cs
- EventWaitHandle.cs
- FormsAuthenticationUserCollection.cs
- XmlSerializableReader.cs
- QueueAccessMode.cs
- FunctionDefinition.cs
- SHA512CryptoServiceProvider.cs
- FormatSettings.cs
- CopyOnWriteList.cs
- SafeWaitHandle.cs
- PageContentAsyncResult.cs
- externdll.cs
- EventEntry.cs
- TrustManagerPromptUI.cs
- ConfigurationStrings.cs
- InternalPermissions.cs
- RoutedEventValueSerializer.cs
- PolyLineSegment.cs
- SpoolingTask.cs
- SqlLiftWhereClauses.cs
- OledbConnectionStringbuilder.cs
- PropertyKey.cs
- NotifyParentPropertyAttribute.cs
- UnitySerializationHolder.cs
- ExpandoObject.cs
- SoapIncludeAttribute.cs
- Enum.cs
- LabelLiteral.cs
- ErrorEventArgs.cs
- Size.cs
- HandlerMappingMemo.cs
- ProxyElement.cs
- ToolboxCategoryItems.cs
- MetadataArtifactLoaderComposite.cs
- CustomErrorsSectionWrapper.cs
- VirtualizingPanel.cs
- BamlTreeMap.cs
- IdentitySection.cs
- LambdaCompiler.Logical.cs
- DelegateSerializationHolder.cs
- ThreadExceptionEvent.cs
- StorageMappingItemLoader.cs
- ActivityInstance.cs
- ControlsConfig.cs
- SimpleApplicationHost.cs