195 references to Parameters
System.Data (10)
fx\src\data\System\Data\Common\DBCommandBuilder.cs (8)
1041if (!command.Parameters.Contains(p)) { 1042command.Parameters.Add(p); 1084if (!command.Parameters.Contains(p)) { 1085command.Parameters.Add(p); 1241if (pcount < command.Parameters.Count) { 1242p = command.Parameters[pcount]; 1358for (int i = command.Parameters.Count-1; i >= usedParameterCount; --i) { 1359command.Parameters.RemoveAt(i);
fx\src\data\System\Data\ProviderBase\DbMetaDataFactory.cs (1)
166command.Parameters.Add(restrictionParameter);
fx\src\data\System\Data\SqlClient\SqlCommandSet.cs (1)
230batchCommand.Parameters.Clear();
System.Data.Entity (6)
System\Data\Common\Utils\CommandHelper.cs (1)
126foreach (DbParameter storeParameter in storeProviderCommand.Parameters)
System\Data\EntityClient\EntityCommandDefinition.cs (2)
444if (storeProviderCommand.Parameters != null) // SQLBUDT 519066 448foreach (DbParameter storeParameter in storeProviderCommand.Parameters) {
System\Data\Mapping\Update\Internal\FunctionUpdateCommand.cs (2)
135DbParameter parameter = this.m_dbCommand.Parameters[parameterBinding.Parameter.Name]; 164m_rowsAffectedParameter = m_dbCommand.Parameters[rowsAffectedParameter.Name];
System\Data\Objects\ObjectContext.cs (1)
3252command.Parameters.AddRange(dbParameters);
System.Data.Linq (3)
SqlClient\SqlProvider.cs (3)
1155foreach (DbParameter p in cmd.Parameters) { 1207cmd.Parameters.Add(p); 1853object parameterValue = this.command.Parameters[parameterIndex].Value;
System.Web (11)
UI\WebControls\SqlDataSourceView.cs (11)
654if (command.Parameters.Contains(formattedParamName)) { 657command.Parameters[formattedParamName].Value = value; 663command.Parameters.Add(dbParameter); 684if (command.Parameters.Count > 0) { 687foreach (DbParameter p in command.Parameters) { 959command.Parameters.Add(_owner.CreateParameter(ParameterPrefix + sortParameterName, sortExpression)); 976int paramCount = command.Parameters.Count; 978DbParameter parameter = command.Parameters[i]; 1237command.Parameters.Add(dbParameter); 1445int paramCount = command.Parameters.Count; 1446foreach (DbParameter parameter in command.Parameters) {
System.Web.Extensions (2)
ClientServices\Providers\SqlHelper.cs (2)
73cmd.Parameters.Add(new SqlParameter(paramName, paramValue)); 291cmd.Parameters.Add((DbParameter) Activator.CreateInstance(_SqlCeParamType, new object[]{paramName, paramValue}));
System.Workflow.Runtime (163)
Hosting\SqlWorkflowPersistenceService.cs (41)
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)); 190command.Parameters.Add(p1); 197command.Parameters.Add(p2); 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))); 315command.Parameters.Add(p2); 323command.Parameters.Add(found); 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)); 430command.Parameters.Add(p1); 437command.Parameters.Add(p2); 492command.Parameters.Add(this.dbResourceAllocator.NewDbParameter("@completedScopeID", scopeId)); 498command.Parameters.Add(p1); 572DbParameter result = command.Parameters["@result"]; 575if (command.Parameters.Contains("@currentOwnerID")) 578if (command.Parameters["@currentOwnerID"].Value is System.Guid) 579currentOwnerId = (Guid)command.Parameters["@currentOwnerID"].Value; 580Guid myId = (Guid)command.Parameters["@ownerID"].Value; 581Guid instId = (Guid)command.Parameters["@uidInstanceID"].Value; 584DbParameter instanceId = command.Parameters["@uidInstanceID"]; 615DbParameter resultParam = command.Parameters["@result"];
Tracking\SqlTrackingService.cs (122)
279cmd.Parameters.Add(this._dbResourceAllocator.NewDbParameter("@InstanceId", scheduleInstanceId)); 371cmd.Parameters.Add(this._dbResourceAllocator.NewDbParameter("@LastCheckDateTime", _lastProfileCheck)); 378cmd.Parameters.Add(param); 437if (null != cmd.Parameters[1].Value) 438_lastProfileCheck = (DateTime)cmd.Parameters[1].Value; 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)); 865command.Parameters.Clear(); 869command.Parameters.Add(DbResourceAllocator.NewDbParameter("@WorkflowInstanceInternalId", internalId)); 870command.Parameters.Add(DbResourceAllocator.NewDbParameter("@EndDateTime", DateTime.UtcNow)); 1241command.Parameters.Clear(); 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))); 1289command.Parameters.Clear(); 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))); 1385long eventId1 = (long)command.Parameters["@WorkflowInstanceEventId1"].Value; 1391eventId2 = (long)command.Parameters["@WorkflowInstanceEventId2"].Value; 1422command.Parameters.Clear(); 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)); 1540command.Parameters.Clear(); 1541command.Parameters.Add(DbResourceAllocator.NewDbParameter("@WorkflowInstanceId", _parameters.InstanceId)); 1545command.Parameters.Add(param); 1549command.Parameters.Add(DbResourceAllocator.NewDbParameter("@WorkflowInstanceContextGuid", _parameters.ContextGuid)); 1576long aId = (long)command.Parameters["@ActivityInstanceId" + index].Value; 1590long aeseId = (long)command.Parameters["@ActivityExecutionStatusEventId" + index].Value; 1624command.Parameters.Add(param); 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)); 1710SetActivityInstanceId(id, (long)command.Parameters["@ActivityInstanceId"].Value); 1712long eventId = (long)command.Parameters["@UserEventId"].Value; 1736command.Parameters.Clear(); 1739command.Parameters.Add(param); 1742command.Parameters.Add(DbResourceAllocator.NewDbParameter("@EventOrder", record.EventOrder)); 1746command.Parameters.Add(param); 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)); 1837command.Parameters.Clear(); 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)); 1871ids.Insert(i, (long)command.Parameters["@TrackingDataItemId" + index].Value); 1911command.Parameters.Clear(); 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)); 1974command.Parameters.Clear(); 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)); 2068long eventId = (long)command.Parameters["@WorkflowInstanceEventId1"].Value; 2096command.Parameters.Clear(); 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)); 2121command.Parameters.Clear(); 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));