195 references to Parameters
System.Data (10)
fx\src\data\System\Data\Common\DBCommandBuilder.cs (8)
1041
if (!command.
Parameters
.Contains(p)) {
1042
command.
Parameters
.Add(p);
1084
if (!command.
Parameters
.Contains(p)) {
1085
command.
Parameters
.Add(p);
1241
if (pcount < command.
Parameters
.Count) {
1242
p = command.
Parameters
[pcount];
1358
for (int i = command.
Parameters
.Count-1; i >= usedParameterCount; --i) {
1359
command.
Parameters
.RemoveAt(i);
fx\src\data\System\Data\ProviderBase\DbMetaDataFactory.cs (1)
166
command.
Parameters
.Add(restrictionParameter);
fx\src\data\System\Data\SqlClient\SqlCommandSet.cs (1)
230
batchCommand.
Parameters
.Clear();
System.Data.Entity (6)
System\Data\Common\Utils\CommandHelper.cs (1)
126
foreach (DbParameter storeParameter in storeProviderCommand.
Parameters
)
System\Data\EntityClient\EntityCommandDefinition.cs (2)
444
if (storeProviderCommand.
Parameters
!= null) // SQLBUDT 519066
448
foreach (DbParameter storeParameter in storeProviderCommand.
Parameters
) {
System\Data\Mapping\Update\Internal\FunctionUpdateCommand.cs (2)
135
DbParameter parameter = this.m_dbCommand.
Parameters
[parameterBinding.Parameter.Name];
164
m_rowsAffectedParameter = m_dbCommand.
Parameters
[rowsAffectedParameter.Name];
System\Data\Objects\ObjectContext.cs (1)
3252
command.
Parameters
.AddRange(dbParameters);
System.Data.Linq (3)
SqlClient\SqlProvider.cs (3)
1155
foreach (DbParameter p in cmd.
Parameters
) {
1207
cmd.
Parameters
.Add(p);
1853
object parameterValue = this.command.
Parameters
[parameterIndex].Value;
System.Web (11)
UI\WebControls\SqlDataSourceView.cs (11)
654
if (command.
Parameters
.Contains(formattedParamName)) {
657
command.
Parameters
[formattedParamName].Value = value;
663
command.
Parameters
.Add(dbParameter);
684
if (command.
Parameters
.Count > 0) {
687
foreach (DbParameter p in command.
Parameters
) {
959
command.
Parameters
.Add(_owner.CreateParameter(ParameterPrefix + sortParameterName, sortExpression));
976
int paramCount = command.
Parameters
.Count;
978
DbParameter parameter = command.
Parameters
[i];
1237
command.
Parameters
.Add(dbParameter);
1445
int paramCount = command.
Parameters
.Count;
1446
foreach (DbParameter parameter in command.
Parameters
) {
System.Web.Extensions (2)
ClientServices\Providers\SqlHelper.cs (2)
73
cmd.
Parameters
.Add(new SqlParameter(paramName, paramValue));
291
cmd.
Parameters
.Add((DbParameter) Activator.CreateInstance(_SqlCeParamType, new object[]{paramName, paramValue}));
System.Workflow.Runtime (163)
Hosting\SqlWorkflowPersistenceService.cs (41)
176
command.
Parameters
.Add(this.dbResourceAllocator.NewDbParameter("@uidInstanceID", item.InstanceId));
177
command.
Parameters
.Add(this.dbResourceAllocator.NewDbParameter("@state", item.SerializedActivity));
178
command.
Parameters
.Add(this.dbResourceAllocator.NewDbParameter("@status", item.Status));
179
command.
Parameters
.Add(this.dbResourceAllocator.NewDbParameter("@unlocked", item.Unlocked));
180
command.
Parameters
.Add(this.dbResourceAllocator.NewDbParameter("@blocked", item.Blocked));
181
command.
Parameters
.Add(this.dbResourceAllocator.NewDbParameter("@info", item.Info));
182
command.
Parameters
.Add(this.dbResourceAllocator.NewDbParameter("@ownedUntil", ownedUntil == DateTime.MaxValue ? SqlDateTime.MaxValue : ownedUntil));
183
command.
Parameters
.Add(this.dbResourceAllocator.NewDbParameter("@ownerID", DbOwnerId(ownerId)));
184
command.
Parameters
.Add(this.dbResourceAllocator.NewDbParameter("@nextTimer", item.NextTimer));
190
command.
Parameters
.Add(p1);
197
command.
Parameters
.Add(p2);
218
command.
Parameters
.Add(this.dbResourceAllocator.NewDbParameter("instanceID", instanceId));
219
command.
Parameters
.Add(this.dbResourceAllocator.NewDbParameter("completedScopeID", scopeId));
220
command.
Parameters
.Add(this.dbResourceAllocator.NewDbParameter("state", state));
234
command.
Parameters
.Add(this.dbResourceAllocator.NewDbParameter("@uidInstanceID", instanceId));
235
command.
Parameters
.Add(this.dbResourceAllocator.NewDbParameter("@ownerID", DbOwnerId(ownerId)));
258
command.
Parameters
.Add(this.dbResourceAllocator.NewDbParameter("@ownedUntil", ownedUntil == DateTime.MaxValue ? SqlDateTime.MaxValue : ownedUntil));
259
command.
Parameters
.Add(this.dbResourceAllocator.NewDbParameter("@ownerID", DbOwnerId(ownerId)));
260
command.
Parameters
.Add(this.dbResourceAllocator.NewDbParameter("@now", DateTime.UtcNow));
307
command.
Parameters
.Add(this.dbResourceAllocator.NewDbParameter("@ownedUntil", ownedUntil == DateTime.MaxValue ? SqlDateTime.MaxValue : ownedUntil));
308
command.
Parameters
.Add(this.dbResourceAllocator.NewDbParameter("@ownerID", DbOwnerId(ownerId)));
315
command.
Parameters
.Add(p2);
323
command.
Parameters
.Add(found);
372
command.
Parameters
.Add(this.dbResourceAllocator.NewDbParameter("@ownedUntil", ownedUntil == DateTime.MaxValue ? SqlDateTime.MaxValue : ownedUntil));
373
command.
Parameters
.Add(this.dbResourceAllocator.NewDbParameter("@ownerID", DbOwnerId(ownerId)));
374
command.
Parameters
.Add(this.dbResourceAllocator.NewDbParameter("@now", DateTime.UtcNow));
422
command.
Parameters
.Add(this.dbResourceAllocator.NewDbParameter("@uidInstanceID", instanceStateId));
423
command.
Parameters
.Add(this.dbResourceAllocator.NewDbParameter("@ownerID", DbOwnerId(ownerId)));
424
command.
Parameters
.Add(this.dbResourceAllocator.NewDbParameter("@ownedUntil", timeout == DateTime.MaxValue ? SqlDateTime.MaxValue : timeout));
430
command.
Parameters
.Add(p1);
437
command.
Parameters
.Add(p2);
492
command.
Parameters
.Add(this.dbResourceAllocator.NewDbParameter("@completedScopeID", scopeId));
498
command.
Parameters
.Add(p1);
572
DbParameter result = command.
Parameters
["@result"];
575
if (command.
Parameters
.Contains("@currentOwnerID"))
578
if (command.
Parameters
["@currentOwnerID"].Value is System.Guid)
579
currentOwnerId = (Guid)command.
Parameters
["@currentOwnerID"].Value;
580
Guid myId = (Guid)command.
Parameters
["@ownerID"].Value;
581
Guid instId = (Guid)command.
Parameters
["@uidInstanceID"].Value;
584
DbParameter instanceId = command.
Parameters
["@uidInstanceID"];
615
DbParameter resultParam = command.
Parameters
["@result"];
Tracking\SqlTrackingService.cs (122)
279
cmd.
Parameters
.Add(this._dbResourceAllocator.NewDbParameter("@InstanceId", scheduleInstanceId));
371
cmd.
Parameters
.Add(this._dbResourceAllocator.NewDbParameter("@LastCheckDateTime", _lastProfileCheck));
378
cmd.
Parameters
.Add(param);
437
if (null != cmd.
Parameters
[1].Value)
438
_lastProfileCheck = (DateTime)cmd.
Parameters
[1].Value;
633
cmd.
Parameters
.Add(this._dbResourceAllocator.NewDbParameter("@TypeFullName", workflowType.FullName));
634
cmd.
Parameters
.Add(this._dbResourceAllocator.NewDbParameter("@AssemblyFullName", workflowType.Assembly.FullName));
637
cmd.
Parameters
.Add(this._dbResourceAllocator.NewDbParameter("@Version", profileVersionId.ToString()));
639
cmd.
Parameters
.Add(this._dbResourceAllocator.NewDbParameter("@CreateDefault", wantToCreateDefault));
830
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@WorkflowInstanceInternalId", _internalId));
865
command.
Parameters
.Clear();
869
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@WorkflowInstanceInternalId", internalId));
870
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@EndDateTime", DateTime.UtcNow));
1241
command.
Parameters
.Clear();
1248
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@WorkflowInstanceId", _parameters.InstanceId));
1249
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@TypeFullName", (xamlInst ? _parameters.InstanceId.ToString() : _parameters.WorkflowType.FullName)));
1250
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@AssemblyFullName", (xamlInst ? _parameters.InstanceId.ToString() : _parameters.WorkflowType.Assembly.FullName)));
1251
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@ContextGuid", _parameters.ContextGuid));
1254
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@CallerInstanceId", _parameters.CallerInstanceId));
1255
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@CallPath", _callPathKey));
1256
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@CallerContextGuid", _parameters.CallerContextGuid));
1257
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@CallerParentContextGuid", _parameters.CallerParentContextGuid));
1259
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@EventDateTime", this.GetSqlDateTimeString(DateTime.UtcNow)));
1289
command.
Parameters
.Clear();
1294
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@TypeFullName", (null == workflowType ? workflowInstanceId.ToString() : workflowType.FullName)));
1295
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@AssemblyFullName", (null == workflowType ? workflowInstanceId.ToString() : workflowType.Assembly.FullName)));
1296
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@IsInstanceType", (null == workflowType ? true : false)));
1299
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@WorkflowDefinition", xoml));
1301
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@WorkflowId", DbType.Int32, System.Data.ParameterDirection.Output));
1302
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@Exists", DbType.Boolean, System.Data.ParameterDirection.Output));
1304
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@Activities", GetActivitiesXml((CompositeActivity)rootActivity)));
1385
long eventId1 = (long)command.
Parameters
["@WorkflowInstanceEventId1"].Value;
1391
eventId2 = (long)command.
Parameters
["@WorkflowInstanceEventId2"].Value;
1422
command.
Parameters
.Clear();
1423
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@WorkflowInstanceInternalId", internalId));
1425
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@TrackingWorkflowEventId1", (int)record1.TrackingWorkflowEvent));
1426
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@EventDateTime1", record1.EventDateTime));
1427
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@EventOrder1", record1.EventOrder));
1439
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@EventArgTypeFullName1", t.FullName));
1440
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@EventArgAssemblyFullName1", t.Assembly.FullName));
1441
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@EventArg1", data));
1443
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@WorkflowInstanceEventId1", DbType.Int64, ParameterDirection.Output));
1447
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@TrackingWorkflowEventId2", (int)record2.TrackingWorkflowEvent));
1448
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@EventDateTime2", record2.EventDateTime));
1449
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@EventOrder2", record2.EventOrder));
1461
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@EventArgTypeFullName2", t.FullName));
1462
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@EventArgAssemblyFullName2", t.Assembly.FullName));
1463
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@EventArg2", data));
1465
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@WorkflowInstanceEventId2", DbType.Int64, ParameterDirection.Output));
1540
command.
Parameters
.Clear();
1541
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@WorkflowInstanceId", _parameters.InstanceId));
1545
command.
Parameters
.Add(param);
1549
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@WorkflowInstanceContextGuid", _parameters.ContextGuid));
1576
long aId = (long)command.
Parameters
["@ActivityInstanceId" + index].Value;
1590
long aeseId = (long)command.
Parameters
["@ActivityExecutionStatusEventId" + index].Value;
1624
command.
Parameters
.Add(param);
1629
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@QualifiedName" + paramIdString, record.QualifiedName));
1630
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@ContextGuid" + paramIdString, record.ContextGuid));
1631
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@ParentContextGuid" + paramIdString, record.ParentContextGuid));
1632
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@ExecutionStatusId" + paramIdString, (int)record.ExecutionStatus));
1633
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@EventDateTime" + paramIdString, record.EventDateTime));
1634
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@EventOrder" + paramIdString, record.EventOrder));
1635
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@ActivityExecutionStatusEventId" + paramIdString, DbType.Int64, ParameterDirection.Output));
1710
SetActivityInstanceId(id, (long)command.
Parameters
["@ActivityInstanceId"].Value);
1712
long eventId = (long)command.
Parameters
["@UserEventId"].Value;
1736
command.
Parameters
.Clear();
1739
command.
Parameters
.Add(param);
1742
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@EventOrder", record.EventOrder));
1746
command.
Parameters
.Add(param);
1757
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@QualifiedName", record.QualifiedName));
1758
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@ContextGuid", record.ContextGuid));
1759
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@ParentContextGuid", record.ParentContextGuid));
1762
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@EventDateTime", record.EventDateTime));
1763
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@UserDataKey", record.UserDataKey));
1780
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@UserDataTypeFullName", t.FullName));
1781
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@UserDataAssemblyFullName", t.Assembly.FullName));
1782
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@UserData_Str", userDataString));
1783
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@UserData_Blob", data));
1784
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@UserDataNonSerializable", nonSerializable));
1786
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@UserEventId", DbType.Int64, ParameterDirection.Output));
1837
command.
Parameters
.Clear();
1838
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@WorkflowInstanceInternalId", internalId));
1839
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@EventTypeId", eventTypeId));
1852
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@EventId" + index, kvp.Key));
1853
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@FieldName" + index, sItem.FieldName));
1854
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@TypeFullName" + index, ((null == t) ? null : t.FullName)));
1855
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@AssemblyFullName" + index, ((null == t) ? null : t.Assembly.FullName)));
1856
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@Data_Str" + index, sItem.StringData));
1857
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@Data_Blob" + index, sItem.SerializedData));
1858
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@DataNonSerializable" + index, sItem.NonSerializable));
1859
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@TrackingDataItemId" + index, DbType.Int64, System.Data.ParameterDirection.Output));
1871
ids.Insert(i, (long)command.
Parameters
["@TrackingDataItemId" + index].Value);
1911
command.
Parameters
.Clear();
1915
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@WorkflowInstanceInternalId", internalId));
1921
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@HasData" + index, true));
1922
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@TrackingDataItemId" + index, kvp.Key));
1923
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@Annotation" + index, kvp.Value));
1974
command.
Parameters
.Clear();
1978
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@WorkflowInstanceInternalId", internalId));
1979
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@EventTypeId", eventTypeId));
1985
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@HasData" + index, true));
1986
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@EventId" + index, kvp.Key));
1987
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@Annotation" + index, kvp.Value));
2068
long eventId = (long)command.
Parameters
["@WorkflowInstanceEventId1"].Value;
2096
command.
Parameters
.Clear();
2101
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@WorkflowInstanceInternalId", internalId));
2102
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@WorkflowInstanceEventId", eventId));
2103
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@QualifiedName", qualifiedName));
2104
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@TypeFullName", typeFullName));
2105
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@AssemblyFullName", assemblyFullName));
2106
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@ParentQualifiedName", parentQualifiedName));
2107
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@AddedActivityAction", addedActivityActionXoml));
2109
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@Order", DBNull.Value));
2111
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@Order", order));
2121
command.
Parameters
.Clear();
2125
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@WorkflowInstanceInternalId", internalId));
2126
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@WorkflowInstanceEventId", eventId));
2127
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@QualifiedName", qualifiedName));
2128
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@ParentQualifiedName", parentQualifiedName));
2129
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@RemovedActivityAction", removedActivityActionXoml));
2131
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@Order", DBNull.Value));
2133
command.
Parameters
.Add(DbResourceAllocator.NewDbParameter("@Order", order));