116 references to NewDbParameter
System.Workflow.Runtime (116)
Hosting\DbResourceAllocator.cs (1)
241return NewDbParameter(null, null);
Hosting\SqlWorkflowPersistenceService.cs (26)
176command.Parameters.Add(this.dbResourceAllocator.NewDbParameter("@uidInstanceID", item.InstanceId)); 177command.Parameters.Add(this.dbResourceAllocator.NewDbParameter("@state", item.SerializedActivity)); 178command.Parameters.Add(this.dbResourceAllocator.NewDbParameter("@status", item.Status)); 179command.Parameters.Add(this.dbResourceAllocator.NewDbParameter("@unlocked", item.Unlocked)); 180command.Parameters.Add(this.dbResourceAllocator.NewDbParameter("@blocked", item.Blocked)); 181command.Parameters.Add(this.dbResourceAllocator.NewDbParameter("@info", item.Info)); 182command.Parameters.Add(this.dbResourceAllocator.NewDbParameter("@ownedUntil", ownedUntil == DateTime.MaxValue ? SqlDateTime.MaxValue : ownedUntil)); 183command.Parameters.Add(this.dbResourceAllocator.NewDbParameter("@ownerID", DbOwnerId(ownerId))); 184command.Parameters.Add(this.dbResourceAllocator.NewDbParameter("@nextTimer", item.NextTimer)); 218command.Parameters.Add(this.dbResourceAllocator.NewDbParameter("instanceID", instanceId)); 219command.Parameters.Add(this.dbResourceAllocator.NewDbParameter("completedScopeID", scopeId)); 220command.Parameters.Add(this.dbResourceAllocator.NewDbParameter("state", state)); 234command.Parameters.Add(this.dbResourceAllocator.NewDbParameter("@uidInstanceID", instanceId)); 235command.Parameters.Add(this.dbResourceAllocator.NewDbParameter("@ownerID", DbOwnerId(ownerId))); 258command.Parameters.Add(this.dbResourceAllocator.NewDbParameter("@ownedUntil", ownedUntil == DateTime.MaxValue ? SqlDateTime.MaxValue : ownedUntil)); 259command.Parameters.Add(this.dbResourceAllocator.NewDbParameter("@ownerID", DbOwnerId(ownerId))); 260command.Parameters.Add(this.dbResourceAllocator.NewDbParameter("@now", DateTime.UtcNow)); 307command.Parameters.Add(this.dbResourceAllocator.NewDbParameter("@ownedUntil", ownedUntil == DateTime.MaxValue ? SqlDateTime.MaxValue : ownedUntil)); 308command.Parameters.Add(this.dbResourceAllocator.NewDbParameter("@ownerID", DbOwnerId(ownerId))); 372command.Parameters.Add(this.dbResourceAllocator.NewDbParameter("@ownedUntil", ownedUntil == DateTime.MaxValue ? SqlDateTime.MaxValue : ownedUntil)); 373command.Parameters.Add(this.dbResourceAllocator.NewDbParameter("@ownerID", DbOwnerId(ownerId))); 374command.Parameters.Add(this.dbResourceAllocator.NewDbParameter("@now", DateTime.UtcNow)); 422command.Parameters.Add(this.dbResourceAllocator.NewDbParameter("@uidInstanceID", instanceStateId)); 423command.Parameters.Add(this.dbResourceAllocator.NewDbParameter("@ownerID", DbOwnerId(ownerId))); 424command.Parameters.Add(this.dbResourceAllocator.NewDbParameter("@ownedUntil", timeout == DateTime.MaxValue ? SqlDateTime.MaxValue : timeout)); 492command.Parameters.Add(this.dbResourceAllocator.NewDbParameter("@completedScopeID", scopeId));
Tracking\SqlTrackingService.cs (89)
279cmd.Parameters.Add(this._dbResourceAllocator.NewDbParameter("@InstanceId", scheduleInstanceId)); 371cmd.Parameters.Add(this._dbResourceAllocator.NewDbParameter("@LastCheckDateTime", _lastProfileCheck)); 633cmd.Parameters.Add(this._dbResourceAllocator.NewDbParameter("@TypeFullName", workflowType.FullName)); 634cmd.Parameters.Add(this._dbResourceAllocator.NewDbParameter("@AssemblyFullName", workflowType.Assembly.FullName)); 637cmd.Parameters.Add(this._dbResourceAllocator.NewDbParameter("@Version", profileVersionId.ToString())); 639cmd.Parameters.Add(this._dbResourceAllocator.NewDbParameter("@CreateDefault", wantToCreateDefault)); 830command.Parameters.Add(DbResourceAllocator.NewDbParameter("@WorkflowInstanceInternalId", _internalId)); 869command.Parameters.Add(DbResourceAllocator.NewDbParameter("@WorkflowInstanceInternalId", internalId)); 870command.Parameters.Add(DbResourceAllocator.NewDbParameter("@EndDateTime", DateTime.UtcNow)); 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)); 1304command.Parameters.Add(DbResourceAllocator.NewDbParameter("@Activities", GetActivitiesXml((CompositeActivity)rootActivity))); 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)); 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)); 1541command.Parameters.Add(DbResourceAllocator.NewDbParameter("@WorkflowInstanceId", _parameters.InstanceId)); 1549command.Parameters.Add(DbResourceAllocator.NewDbParameter("@WorkflowInstanceContextGuid", _parameters.ContextGuid)); 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)); 1742command.Parameters.Add(DbResourceAllocator.NewDbParameter("@EventOrder", record.EventOrder)); 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)); 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)); 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)); 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));