825DbConnection connection = DbResourceAllocator.OpenNewConnection(false); 830command.Parameters.Add(DbResourceAllocator.NewDbParameter("@WorkflowInstanceInternalId", _internalId)); 849DbConnection connection = DbResourceAllocator.OpenNewConnection(false); 869command.Parameters.Add(DbResourceAllocator.NewDbParameter("@WorkflowInstanceInternalId", internalId)); 870command.Parameters.Add(DbResourceAllocator.NewDbParameter("@EndDateTime", DateTime.UtcNow)); 954connection = DbResourceAllocator.GetEnlistedConnection( 1160DbConnection conn = DbResourceAllocator.OpenNewConnection(); 1248command.Parameters.Add(DbResourceAllocator.NewDbParameter("@WorkflowInstanceId", _parameters.InstanceId)); 1249command.Parameters.Add(DbResourceAllocator.NewDbParameter("@TypeFullName", (xamlInst ? _parameters.InstanceId.ToString() : _parameters.WorkflowType.FullName))); 1250command.Parameters.Add(DbResourceAllocator.NewDbParameter("@AssemblyFullName", (xamlInst ? _parameters.InstanceId.ToString() : _parameters.WorkflowType.Assembly.FullName))); 1251command.Parameters.Add(DbResourceAllocator.NewDbParameter("@ContextGuid", _parameters.ContextGuid)); 1254command.Parameters.Add(DbResourceAllocator.NewDbParameter("@CallerInstanceId", _parameters.CallerInstanceId)); 1255command.Parameters.Add(DbResourceAllocator.NewDbParameter("@CallPath", _callPathKey)); 1256command.Parameters.Add(DbResourceAllocator.NewDbParameter("@CallerContextGuid", _parameters.CallerContextGuid)); 1257command.Parameters.Add(DbResourceAllocator.NewDbParameter("@CallerParentContextGuid", _parameters.CallerParentContextGuid)); 1259command.Parameters.Add(DbResourceAllocator.NewDbParameter("@EventDateTime", this.GetSqlDateTimeString(DateTime.UtcNow))); 1294command.Parameters.Add(DbResourceAllocator.NewDbParameter("@TypeFullName", (null == workflowType ? workflowInstanceId.ToString() : workflowType.FullName))); 1295command.Parameters.Add(DbResourceAllocator.NewDbParameter("@AssemblyFullName", (null == workflowType ? workflowInstanceId.ToString() : workflowType.Assembly.FullName))); 1296command.Parameters.Add(DbResourceAllocator.NewDbParameter("@IsInstanceType", (null == workflowType ? true : false))); 1299command.Parameters.Add(DbResourceAllocator.NewDbParameter("@WorkflowDefinition", xoml)); 1301command.Parameters.Add(DbResourceAllocator.NewDbParameter("@WorkflowId", DbType.Int32, System.Data.ParameterDirection.Output)); 1302command.Parameters.Add(DbResourceAllocator.NewDbParameter("@Exists", DbType.Boolean, System.Data.ParameterDirection.Output)); 1304command.Parameters.Add(DbResourceAllocator.NewDbParameter("@Activities", GetActivitiesXml((CompositeActivity)rootActivity))); 1336DbConnection conn = DbResourceAllocator.OpenNewConnection(); 1423command.Parameters.Add(DbResourceAllocator.NewDbParameter("@WorkflowInstanceInternalId", internalId)); 1425command.Parameters.Add(DbResourceAllocator.NewDbParameter("@TrackingWorkflowEventId1", (int)record1.TrackingWorkflowEvent)); 1426command.Parameters.Add(DbResourceAllocator.NewDbParameter("@EventDateTime1", record1.EventDateTime)); 1427command.Parameters.Add(DbResourceAllocator.NewDbParameter("@EventOrder1", record1.EventOrder)); 1439command.Parameters.Add(DbResourceAllocator.NewDbParameter("@EventArgTypeFullName1", t.FullName)); 1440command.Parameters.Add(DbResourceAllocator.NewDbParameter("@EventArgAssemblyFullName1", t.Assembly.FullName)); 1441command.Parameters.Add(DbResourceAllocator.NewDbParameter("@EventArg1", data)); 1443command.Parameters.Add(DbResourceAllocator.NewDbParameter("@WorkflowInstanceEventId1", DbType.Int64, ParameterDirection.Output)); 1447command.Parameters.Add(DbResourceAllocator.NewDbParameter("@TrackingWorkflowEventId2", (int)record2.TrackingWorkflowEvent)); 1448command.Parameters.Add(DbResourceAllocator.NewDbParameter("@EventDateTime2", record2.EventDateTime)); 1449command.Parameters.Add(DbResourceAllocator.NewDbParameter("@EventOrder2", record2.EventOrder)); 1461command.Parameters.Add(DbResourceAllocator.NewDbParameter("@EventArgTypeFullName2", t.FullName)); 1462command.Parameters.Add(DbResourceAllocator.NewDbParameter("@EventArgAssemblyFullName2", t.Assembly.FullName)); 1463command.Parameters.Add(DbResourceAllocator.NewDbParameter("@EventArg2", data)); 1465command.Parameters.Add(DbResourceAllocator.NewDbParameter("@WorkflowInstanceEventId2", DbType.Int64, ParameterDirection.Output)); 1480DbConnection conn = DbResourceAllocator.OpenNewConnection(); 1541command.Parameters.Add(DbResourceAllocator.NewDbParameter("@WorkflowInstanceId", _parameters.InstanceId)); 1544DbParameter param = DbResourceAllocator.NewDbParameter("@WorkflowInstanceInternalId", DbType.Int64, System.Data.ParameterDirection.InputOutput); 1549command.Parameters.Add(DbResourceAllocator.NewDbParameter("@WorkflowInstanceContextGuid", _parameters.ContextGuid)); 1623DbParameter param = DbResourceAllocator.NewDbParameter("@ActivityInstanceId" + paramIdString, DbType.Int64, System.Data.ParameterDirection.InputOutput); 1629command.Parameters.Add(DbResourceAllocator.NewDbParameter("@QualifiedName" + paramIdString, record.QualifiedName)); 1630command.Parameters.Add(DbResourceAllocator.NewDbParameter("@ContextGuid" + paramIdString, record.ContextGuid)); 1631command.Parameters.Add(DbResourceAllocator.NewDbParameter("@ParentContextGuid" + paramIdString, record.ParentContextGuid)); 1632command.Parameters.Add(DbResourceAllocator.NewDbParameter("@ExecutionStatusId" + paramIdString, (int)record.ExecutionStatus)); 1633command.Parameters.Add(DbResourceAllocator.NewDbParameter("@EventDateTime" + paramIdString, record.EventDateTime)); 1634command.Parameters.Add(DbResourceAllocator.NewDbParameter("@EventOrder" + paramIdString, record.EventOrder)); 1635command.Parameters.Add(DbResourceAllocator.NewDbParameter("@ActivityExecutionStatusEventId" + paramIdString, DbType.Int64, ParameterDirection.Output)); 1650DbConnection conn = DbResourceAllocator.OpenNewConnection(); 1738DbParameter param = DbResourceAllocator.NewDbParameter("@WorkflowInstanceInternalId", DbType.Int64); 1742command.Parameters.Add(DbResourceAllocator.NewDbParameter("@EventOrder", record.EventOrder)); 1745param = DbResourceAllocator.NewDbParameter("@ActivityInstanceId", DbType.Int64, System.Data.ParameterDirection.InputOutput); 1757command.Parameters.Add(DbResourceAllocator.NewDbParameter("@QualifiedName", record.QualifiedName)); 1758command.Parameters.Add(DbResourceAllocator.NewDbParameter("@ContextGuid", record.ContextGuid)); 1759command.Parameters.Add(DbResourceAllocator.NewDbParameter("@ParentContextGuid", record.ParentContextGuid)); 1762command.Parameters.Add(DbResourceAllocator.NewDbParameter("@EventDateTime", record.EventDateTime)); 1763command.Parameters.Add(DbResourceAllocator.NewDbParameter("@UserDataKey", record.UserDataKey)); 1780command.Parameters.Add(DbResourceAllocator.NewDbParameter("@UserDataTypeFullName", t.FullName)); 1781command.Parameters.Add(DbResourceAllocator.NewDbParameter("@UserDataAssemblyFullName", t.Assembly.FullName)); 1782command.Parameters.Add(DbResourceAllocator.NewDbParameter("@UserData_Str", userDataString)); 1783command.Parameters.Add(DbResourceAllocator.NewDbParameter("@UserData_Blob", data)); 1784command.Parameters.Add(DbResourceAllocator.NewDbParameter("@UserDataNonSerializable", nonSerializable)); 1786command.Parameters.Add(DbResourceAllocator.NewDbParameter("@UserEventId", DbType.Int64, ParameterDirection.Output)); 1838command.Parameters.Add(DbResourceAllocator.NewDbParameter("@WorkflowInstanceInternalId", internalId)); 1839command.Parameters.Add(DbResourceAllocator.NewDbParameter("@EventTypeId", eventTypeId)); 1852command.Parameters.Add(DbResourceAllocator.NewDbParameter("@EventId" + index, kvp.Key)); 1853command.Parameters.Add(DbResourceAllocator.NewDbParameter("@FieldName" + index, sItem.FieldName)); 1854command.Parameters.Add(DbResourceAllocator.NewDbParameter("@TypeFullName" + index, ((null == t) ? null : t.FullName))); 1855command.Parameters.Add(DbResourceAllocator.NewDbParameter("@AssemblyFullName" + index, ((null == t) ? null : t.Assembly.FullName))); 1856command.Parameters.Add(DbResourceAllocator.NewDbParameter("@Data_Str" + index, sItem.StringData)); 1857command.Parameters.Add(DbResourceAllocator.NewDbParameter("@Data_Blob" + index, sItem.SerializedData)); 1858command.Parameters.Add(DbResourceAllocator.NewDbParameter("@DataNonSerializable" + index, sItem.NonSerializable)); 1859command.Parameters.Add(DbResourceAllocator.NewDbParameter("@TrackingDataItemId" + index, DbType.Int64, System.Data.ParameterDirection.Output)); 1915command.Parameters.Add(DbResourceAllocator.NewDbParameter("@WorkflowInstanceInternalId", internalId)); 1921command.Parameters.Add(DbResourceAllocator.NewDbParameter("@HasData" + index, true)); 1922command.Parameters.Add(DbResourceAllocator.NewDbParameter("@TrackingDataItemId" + index, kvp.Key)); 1923command.Parameters.Add(DbResourceAllocator.NewDbParameter("@Annotation" + index, kvp.Value)); 1978command.Parameters.Add(DbResourceAllocator.NewDbParameter("@WorkflowInstanceInternalId", internalId)); 1979command.Parameters.Add(DbResourceAllocator.NewDbParameter("@EventTypeId", eventTypeId)); 1985command.Parameters.Add(DbResourceAllocator.NewDbParameter("@HasData" + index, true)); 1986command.Parameters.Add(DbResourceAllocator.NewDbParameter("@EventId" + index, kvp.Key)); 1987command.Parameters.Add(DbResourceAllocator.NewDbParameter("@Annotation" + index, kvp.Value)); 2007DbCommand command = DbResourceAllocator.NewCommand(); 2101command.Parameters.Add(DbResourceAllocator.NewDbParameter("@WorkflowInstanceInternalId", internalId)); 2102command.Parameters.Add(DbResourceAllocator.NewDbParameter("@WorkflowInstanceEventId", eventId)); 2103command.Parameters.Add(DbResourceAllocator.NewDbParameter("@QualifiedName", qualifiedName)); 2104command.Parameters.Add(DbResourceAllocator.NewDbParameter("@TypeFullName", typeFullName)); 2105command.Parameters.Add(DbResourceAllocator.NewDbParameter("@AssemblyFullName", assemblyFullName)); 2106command.Parameters.Add(DbResourceAllocator.NewDbParameter("@ParentQualifiedName", parentQualifiedName)); 2107command.Parameters.Add(DbResourceAllocator.NewDbParameter("@AddedActivityAction", addedActivityActionXoml)); 2109command.Parameters.Add(DbResourceAllocator.NewDbParameter("@Order", DBNull.Value)); 2111command.Parameters.Add(DbResourceAllocator.NewDbParameter("@Order", order)); 2125command.Parameters.Add(DbResourceAllocator.NewDbParameter("@WorkflowInstanceInternalId", internalId)); 2126command.Parameters.Add(DbResourceAllocator.NewDbParameter("@WorkflowInstanceEventId", eventId)); 2127command.Parameters.Add(DbResourceAllocator.NewDbParameter("@QualifiedName", qualifiedName)); 2128command.Parameters.Add(DbResourceAllocator.NewDbParameter("@ParentQualifiedName", parentQualifiedName)); 2129command.Parameters.Add(DbResourceAllocator.NewDbParameter("@RemovedActivityAction", removedActivityActionXoml)); 2131command.Parameters.Add(DbResourceAllocator.NewDbParameter("@Order", DBNull.Value)); 2133command.Parameters.Add(DbResourceAllocator.NewDbParameter("@Order", order));