422 references to Add
System.Activities.DurableInstancing (89)
System\Activities\DurableInstancing\CreateWorkflowOwnerAsyncResult.cs (12)
88
parameters.
Add
(new SqlParameter { ParameterName = "@lockTimeout", SqlDbType = SqlDbType.Int, Value = lockTimeout });
89
parameters.
Add
(new SqlParameter { ParameterName = "@lockOwnerId", SqlDbType = SqlDbType.UniqueIdentifier, Value = this.lockOwnerId });
90
parameters.
Add
(new SqlParameter { ParameterName = "@workflowHostType", SqlDbType = SqlDbType.UniqueIdentifier, Value = (base.Store.WorkflowHostType != Guid.Empty) ? base.Store.WorkflowHostType : (object) DBNull.Value });
91
parameters.
Add
(new SqlParameter { ParameterName = "@enqueueCommand", SqlDbType = SqlDbType.Bit, Value = base.Store.EnqueueRunCommands });
92
parameters.
Add
(new SqlParameter { ParameterName = "@deleteInstanceOnCompletion", SqlDbType = SqlDbType.Bit, Value = (base.Store.InstanceCompletionAction == InstanceCompletionAction.DeleteAll) });
93
parameters.
Add
(new SqlParameter { ParameterName = "@primitiveLockOwnerData", SqlDbType = SqlDbType.VarBinary, Size = properties[0].Count, Value = (object)(properties[0].Array) ?? DBNull.Value });
94
parameters.
Add
(new SqlParameter { ParameterName = "@complexLockOwnerData", SqlDbType = SqlDbType.VarBinary, Size = properties[1].Count, Value = (object)(properties[1].Array) ?? DBNull.Value });
95
parameters.
Add
(new SqlParameter { ParameterName = "@writeOnlyPrimitiveLockOwnerData", SqlDbType = SqlDbType.VarBinary, Size = properties[2].Count, Value = (object)(properties[2].Array) ?? DBNull.Value });
96
parameters.
Add
(new SqlParameter { ParameterName = "@writeOnlyComplexLockOwnerData", SqlDbType = SqlDbType.VarBinary, Size = properties[3].Count, Value = (object)(properties[3].Array) ?? DBNull.Value });
97
parameters.
Add
(new SqlParameter { ParameterName = "@encodingOption", SqlDbType = SqlDbType.TinyInt, Value = base.Store.InstanceEncodingOption });
98
parameters.
Add
(new SqlParameter { ParameterName = "@machineName", SqlDbType = SqlDbType.NVarChar, Value = SqlWorkflowInstanceStoreConstants.MachineName });
105
parameters.
Add
(new SqlParameter { ParameterName = "@identityMetadata", SqlDbType = SqlDbType.Xml, Value = identityMetadataXml });
System\Activities\DurableInstancing\DeleteWorkflowOwnerAsyncResult.cs (1)
37
sqlCommand.Parameters.
Add
(new SqlParameter { ParameterName = "@surrogateLockOwnerId", SqlDbType = SqlDbType.BigInt, Value = this.surrogateLockOwnerId });
System\Activities\DurableInstancing\DetectActivatableWorkflowsAsyncResult.cs (1)
46
sqlCommand.Parameters.
Add
(new SqlParameter { ParameterName = "@machineName", SqlDbType = SqlDbType.NVarChar, Value = SqlWorkflowInstanceStoreConstants.MachineName });
System\Activities\DurableInstancing\DetectRunnableInstancesAsyncResult.cs (2)
46
sqlCommand.Parameters.
Add
(new SqlParameter { ParameterName = "@workflowHostType", SqlDbType = SqlDbType.UniqueIdentifier, Value = base.Store.WorkflowHostType });
49
sqlCommand.Parameters.
Add
(new SqlParameter { ParameterName = "@surrogateLockOwnerId", SqlDbType = SqlDbType.BigInt, Value = base.StoreLock.SurrogateLockOwnerId });
System\Activities\DurableInstancing\ExtendLockAsyncResult.cs (2)
48
sqlCommand.Parameters.
Add
(new SqlParameter { ParameterName = "@surrogateLockOwnerId", SqlDbType = SqlDbType.BigInt, Value = surrogateOwnerId });
49
sqlCommand.Parameters.
Add
(new SqlParameter { ParameterName = "@lockTimeout", SqlDbType = SqlDbType.Int, Value = lockTimeout });
System\Activities\DurableInstancing\LoadWorkflowAsyncResult.cs (11)
65
parameters.
Add
(new SqlParameter { ParameterName = "@surrogateLockOwnerId", SqlDbType = SqlDbType.BigInt, Value = surrogateLockOwnerId });
66
parameters.
Add
(new SqlParameter { ParameterName = "@operationType", SqlDbType = SqlDbType.TinyInt, Value = loadType });
67
parameters.
Add
(new SqlParameter { ParameterName = "@keyToLoadBy", SqlDbType = SqlDbType.UniqueIdentifier, Value = keyToLoadBy });
68
parameters.
Add
(new SqlParameter { ParameterName = "@instanceId", SqlDbType = SqlDbType.UniqueIdentifier, Value = instanceId });
69
parameters.
Add
(new SqlParameter { ParameterName = "@handleInstanceVersion", SqlDbType = SqlDbType.BigInt, Value = base.InstancePersistenceContext.InstanceVersion });
70
parameters.
Add
(new SqlParameter { ParameterName = "@handleIsBoundToLock", SqlDbType = SqlDbType.Bit, Value = base.InstancePersistenceContext.InstanceView.IsBoundToLock });
71
parameters.
Add
(new SqlParameter { ParameterName = "@keysToAssociate", SqlDbType = SqlDbType.Xml, Value = singleKeyToAssociate ? DBNull.Value : SerializationUtilities.CreateCorrelationKeyXmlBlob(keysToAssociate) });
72
parameters.
Add
(new SqlParameter { ParameterName = "@encodingOption", SqlDbType = SqlDbType.TinyInt, Value = base.Store.InstanceEncodingOption });
73
parameters.
Add
(new SqlParameter { ParameterName = "@concatenatedKeyProperties", SqlDbType = SqlDbType.VarBinary, Value = (object) concatenatedKeyProperties ?? DBNull.Value });
74
parameters.
Add
(new SqlParameter { ParameterName = "@operationTimeout", SqlDbType = SqlDbType.Int, Value = (operationTimeout < Int32.MaxValue) ? Convert.ToInt32(operationTimeout) : Int32.MaxValue });
75
parameters.
Add
(new SqlParameter { ParameterName = "@singleKeyId", SqlDbType = SqlDbType.UniqueIdentifier, Value = singleKeyToAssociate ? keysToAssociate[0].KeyId : (object) DBNull.Value });
System\Activities\DurableInstancing\SaveWorkflowAsyncResult.cs (50)
74
parameters.
Add
(new SqlParameter { ParameterName = "@instanceId", SqlDbType = SqlDbType.UniqueIdentifier, Value = base.InstancePersistenceContext.InstanceView.InstanceId });
75
parameters.
Add
(new SqlParameter { ParameterName = "@surrogateLockOwnerId", SqlDbType = SqlDbType.BigInt, Value = base.StoreLock.SurrogateLockOwnerId });
76
parameters.
Add
(new SqlParameter { ParameterName = "@handleInstanceVersion", SqlDbType = SqlDbType.BigInt, Value = base.InstancePersistenceContext.InstanceVersion });
77
parameters.
Add
(new SqlParameter { ParameterName = "@handleIsBoundToLock", SqlDbType = SqlDbType.Bit, Value = base.InstancePersistenceContext.InstanceView.IsBoundToLock });
78
parameters.
Add
(new SqlParameter { ParameterName = "@timerDurationMilliseconds", SqlDbType = SqlDbType.BigInt, Value = (object)GetPendingTimerExpiration(saveWorkflowCommand) ?? DBNull.Value });
79
parameters.
Add
(new SqlParameter { ParameterName = "@unlockInstance", SqlDbType = SqlDbType.Bit, Value = saveWorkflowCommand.UnlockInstance });
80
parameters.
Add
(new SqlParameter { ParameterName = "@suspensionStateChange", SqlDbType = SqlDbType.TinyInt, Value = GetSuspensionReason(saveWorkflowCommand, out suspensionReason, out suspensionExceptionName) });
81
parameters.
Add
(new SqlParameter { ParameterName = "@suspensionReason", SqlDbType = SqlDbType.NVarChar, Value = (object)suspensionReason ?? DBNull.Value });
82
parameters.
Add
(new SqlParameter { ParameterName = "@suspensionExceptionName", SqlDbType = SqlDbType.NVarChar, Size = 450, Value = (object)suspensionExceptionName ?? DBNull.Value });
83
parameters.
Add
(new SqlParameter { ParameterName = "@isCompleted", SqlDbType = SqlDbType.Bit, Value = saveWorkflowCommand.CompleteInstance });
84
parameters.
Add
(new SqlParameter { ParameterName = "@isReadyToRun", SqlDbType = SqlDbType.Bit, Value = IsReadyToRun(saveWorkflowCommand) });
85
parameters.
Add
(new SqlParameter { ParameterName = "@workflowHostType", SqlDbType = SqlDbType.UniqueIdentifier, Value = (object)GetWorkflowHostType(saveWorkflowCommand) ?? DBNull.Value });
86
parameters.
Add
(new SqlParameter { ParameterName = "@operationTimeout", SqlDbType = SqlDbType.Int, Value = (operationTimeout < Int32.MaxValue) ? Convert.ToInt32(operationTimeout) : Int32.MaxValue });
92
parameters.
Add
(new SqlParameter { ParameterName = "@identityMetadata", SqlDbType = SqlDbType.Xml, Value = (object)identityMetadataXml ?? DBNull.Value });
194
parameters.
Add
(new SqlParameter { ParameterName = parameterName, SqlDbType = SqlDbType.VarBinary, Size = parameterSize, Value = parameterValue });
436
parameters.
Add
(new SqlParameter { ParameterName = "@serviceDeploymentHash", SqlDbType = SqlDbType.UniqueIdentifier, Value = this.serviceDeploymentHash });
437
parameters.
Add
(new SqlParameter { ParameterName = "@serviceName", Size = -1, SqlDbType = SqlDbType.NVarChar, Value = serviceName ?? (object)DBNull.Value });
438
parameters.
Add
(new SqlParameter { ParameterName = "@serviceNamespace", Size = -1, SqlDbType = SqlDbType.NVarChar, Value = serviceNamespace ?? (object)DBNull.Value });
439
parameters.
Add
(new SqlParameter { ParameterName = "@siteName", Size = -1, SqlDbType = SqlDbType.NVarChar, Value = site ?? (object)DBNull.Value });
440
parameters.
Add
(new SqlParameter { ParameterName = "@relativeServicePath", Size = -1, SqlDbType = SqlDbType.NVarChar, Value = relativeServicePath ?? (object)DBNull.Value });
441
parameters.
Add
(new SqlParameter { ParameterName = "@relativeApplicationPath", Size = -1, SqlDbType = SqlDbType.NVarChar, Value = relativeApplicationPath ?? (object)DBNull.Value });
445
parameters.
Add
(new SqlParameter { ParameterName = "@serviceDeploymentId", SqlDbType = SqlDbType.BigInt, Value = (this.serviceDeploymentId != 0) ? (object)this.serviceDeploymentId : (object)DBNull.Value });
479
parameters.
Add
(new SqlParameter { ParameterName = "@keysToAssociate", SqlDbType = SqlDbType.Xml, Value = DBNull.Value });
480
parameters.
Add
(new SqlParameter { ParameterName = "@singleKeyId", SqlDbType = SqlDbType.UniqueIdentifier, Value = DBNull.Value });
481
parameters.
Add
(new SqlParameter { ParameterName = "@keysToComplete", SqlDbType = SqlDbType.Xml, Value = DBNull.Value });
482
parameters.
Add
(new SqlParameter { ParameterName = "@keysToFree", SqlDbType = SqlDbType.Xml, Value = DBNull.Value });
483
parameters.
Add
(new SqlParameter { ParameterName = "@concatenatedKeyProperties", SqlDbType = SqlDbType.VarBinary, Value = DBNull.Value });
484
parameters.
Add
(new SqlParameter { ParameterName = "@primitiveDataProperties", SqlDbType = SqlDbType.VarBinary, Value = DBNull.Value });
485
parameters.
Add
(new SqlParameter { ParameterName = "@complexDataProperties", SqlDbType = SqlDbType.VarBinary, Value = DBNull.Value });
486
parameters.
Add
(new SqlParameter { ParameterName = "@writeOnlyPrimitiveDataProperties", SqlDbType = SqlDbType.VarBinary, Value = DBNull.Value });
487
parameters.
Add
(new SqlParameter { ParameterName = "@writeOnlyComplexDataProperties", SqlDbType = SqlDbType.VarBinary, Value = DBNull.Value });
488
parameters.
Add
(new SqlParameter { ParameterName = "@metadataProperties", SqlDbType = SqlDbType.VarBinary, Value = DBNull.Value });
489
parameters.
Add
(new SqlParameter { ParameterName = "@metadataIsConsistent", SqlDbType = SqlDbType.Bit, Value = DBNull.Value });
490
parameters.
Add
(new SqlParameter { ParameterName = "@encodingOption", SqlDbType = SqlDbType.TinyInt, Value = DBNull.Value });
491
parameters.
Add
(new SqlParameter { ParameterName = "@lastMachineRunOn", SqlDbType = SqlDbType.NVarChar, Value = DBNull.Value });
492
parameters.
Add
(new SqlParameter { ParameterName = "@executionStatus", SqlDbType = SqlDbType.NVarChar, Value = DBNull.Value });
493
parameters.
Add
(new SqlParameter { ParameterName = "@blockingBookmarks", SqlDbType = SqlDbType.NVarChar, Value = DBNull.Value });
507
parameters.
Add
(new SqlParameter { ParameterName = "@keysToAssociate", SqlDbType = SqlDbType.Xml, Value = singleKeyToAssociate ? DBNull.Value : SerializationUtilities.CreateCorrelationKeyXmlBlob(keysToAssociate) });
508
parameters.
Add
(new SqlParameter { ParameterName = "@singleKeyId", SqlDbType = SqlDbType.UniqueIdentifier, Value = singleKeyToAssociate ? keysToAssociate[0].KeyId : (object)DBNull.Value });
509
parameters.
Add
(new SqlParameter { ParameterName = "@keysToComplete", SqlDbType = SqlDbType.Xml, Value = SerializationUtilities.CreateCorrelationKeyXmlBlob(keysToComplete) });
510
parameters.
Add
(new SqlParameter { ParameterName = "@keysToFree", SqlDbType = SqlDbType.Xml, Value = SerializationUtilities.CreateCorrelationKeyXmlBlob(keysToFree) });
511
parameters.
Add
(new SqlParameter { ParameterName = "@concatenatedKeyProperties", SqlDbType = SqlDbType.VarBinary, Size = -1, Value = (object)concatenatedKeyProperties ?? DBNull.Value });
512
parameters.
Add
(new SqlParameter { ParameterName = "@metadataIsConsistent", SqlDbType = SqlDbType.Bit, Value = metadataConsistency });
513
parameters.
Add
(new SqlParameter { ParameterName = "@encodingOption", SqlDbType = SqlDbType.TinyInt, Value = base.Store.InstanceEncodingOption });
514
parameters.
Add
(new SqlParameter { ParameterName = "@lastMachineRunOn", SqlDbType = SqlDbType.NVarChar, Size = 450, Value = SqlWorkflowInstanceStoreConstants.MachineName });
515
parameters.
Add
(new SqlParameter { ParameterName = "@executionStatus", SqlDbType = SqlDbType.NVarChar, Size = 450, Value = GetExecutionStatus(saveWorkflowCommand) ?? (object)DBNull.Value });
516
parameters.
Add
(new SqlParameter { ParameterName = "@blockingBookmarks", SqlDbType = SqlDbType.NVarChar, Size = -1, Value = GetBlockingBookmarks(saveWorkflowCommand) ?? (object)DBNull.Value });
564
parameters.
Add
(new SqlParameter() { SqlDbType = SqlDbType.Variant, ParameterName = argumentName, Value = propertyValue.Value ?? DBNull.Value });
597
parameters.
Add
(new SqlParameter() { SqlDbType = SqlDbType.NVarChar, Size = 400, ParameterName = promotionNameArgument, Value = promotion.Key });
598
parameters.
Add
(new SqlParameter() { SqlDbType = SqlDbType.UniqueIdentifier, ParameterName = instanceIdArgument, Value = base.InstancePersistenceContext.InstanceView.InstanceId });
System\Activities\DurableInstancing\TryLoadRunnableWorkflowAsyncResult.cs (7)
41
command.Parameters.
Add
(new SqlParameter { ParameterName = "@surrogateLockOwnerId", SqlDbType = SqlDbType.BigInt, Value = base.StoreLock.SurrogateLockOwnerId });
42
command.Parameters.
Add
(new SqlParameter { ParameterName = "@workflowHostType", SqlDbType = SqlDbType.UniqueIdentifier, Value = base.Store.WorkflowHostType });
43
command.Parameters.
Add
(new SqlParameter { ParameterName = "@operationType", SqlDbType = SqlDbType.TinyInt, Value = LoadType.LoadByInstance });
44
command.Parameters.
Add
(new SqlParameter { ParameterName = "@handleInstanceVersion", SqlDbType = SqlDbType.BigInt, Value = base.InstancePersistenceContext.InstanceVersion });
45
command.Parameters.
Add
(new SqlParameter { ParameterName = "@handleIsBoundToLock", SqlDbType = SqlDbType.Bit, Value = base.InstancePersistenceContext.InstanceView.IsBoundToLock });
46
command.Parameters.
Add
(new SqlParameter { ParameterName = "@encodingOption", SqlDbType = SqlDbType.TinyInt, Value = base.Store.InstanceEncodingOption });
47
command.Parameters.
Add
(new SqlParameter { ParameterName = "@operationTimeout", SqlDbType = SqlDbType.Int, Value = (operationTimeout < Int32.MaxValue) ? Convert.ToInt32(operationTimeout) : Int32.MaxValue });
System\Activities\DurableInstancing\UnlockInstanceAsyncResult.cs (3)
36
sqlCommand.Parameters.
Add
(new SqlParameter { ParameterName = "@instanceId", SqlDbType = SqlDbType.UniqueIdentifier, Value = unlockCommand.InstanceId });
37
sqlCommand.Parameters.
Add
(new SqlParameter { ParameterName = "@surrogateLockOwnerId", SqlDbType = SqlDbType.BigInt, Value = unlockCommand.SurrogateOwnerId });
38
sqlCommand.Parameters.
Add
(new SqlParameter { ParameterName = "@handleInstanceVersion", SqlDbType = SqlDbType.BigInt, Value = unlockCommand.InstanceVersion });
System.Data (21)
fx\src\data\System\Data\SqlClient\SqlCommand.cs (5)
2796
paramsCmd.Parameters.
Add
(new SqlParameter("@procedure_name", SqlDbType.NVarChar, 255));
2800
SqlParameter param = paramsCmd.Parameters.
Add
(new SqlParameter("@group_number", SqlDbType.Int));
2805
SqlParameter param = paramsCmd.Parameters.
Add
(new SqlParameter("@procedure_schema", SqlDbType.NVarChar, 255));
2959
this._parameters.
Add
(temp);
3771
tempCollection.
Add
(paramCopy);
fx\src\data\System\Data\SqlClient\SqlCommandSet.cs (1)
145
parameters.
Add
(p);
fx\src\data\System\Data\SqlClient\SqlConnection.cs (6)
1994
c.Parameters.
Add
(p);
2000
c.Parameters.
Add
(p);
2004
c.Parameters.
Add
(p);
2011
c.Parameters.
Add
(p);
2015
c.Parameters.
Add
(p);
2022
c.Parameters.
Add
(p);
fx\src\data\System\Data\SqlClient\SqlDependencyListener.cs (3)
155
_com.Parameters.
Add
(_timeoutParam);
439
com.Parameters.
Add
(param);
592
_com.Parameters.
Add
(_conversationGuidParam);
fx\src\data\System\Data\SqlClient\sqlinternaltransaction.cs (1)
340
transactionLevelCommand.Parameters.
Add
(parameter);
fx\src\data\System\Data\SqlClient\SqlParameterCollection.cs (5)
75
return
Add
(new SqlParameter(parameterName, value));
78
return
Add
(new SqlParameter(parameterName, value));
82
return
Add
(new SqlParameter(parameterName, sqlDbType));
86
return
Add
(new SqlParameter(parameterName, sqlDbType, size));
90
return
Add
(new SqlParameter(parameterName, sqlDbType, size, sourceColumn));
System.Data.Entity (2)
System\Data\SqlClient\SqlProviderServices.cs (2)
134
command.Parameters.
Add
(parameter);
146
command.Parameters.
Add
(parameter);
System.Web (266)
Cache\SqlCacheDependency.cs (1)
1501
sqlCmd.Parameters.
Add
(new SqlParameter("@tableName", SqlDbType.NVarChar, table.Length));
Management\SqlServices.cs (2)
559
cmd.Parameters.
Add
(new SqlParameter("@database", databaseNoSquareBrackets));
610
cmd.Parameters.
Add
(new SqlParameter("@TablesToCheck", itablesToCheck));
Management\SqlWebEventProvider.cs (15)
103
sqlCommand.Parameters.
Add
(new SqlParameter("@EventId", SqlDbType.Char, 32));
104
sqlCommand.Parameters.
Add
(new SqlParameter("@EventTimeUtc", SqlDbType.DateTime));
105
sqlCommand.Parameters.
Add
(new SqlParameter("@EventTime", SqlDbType.DateTime));
106
sqlCommand.Parameters.
Add
(new SqlParameter("@EventType", SqlDbType.NVarChar, 256));
107
sqlCommand.Parameters.
Add
(new SqlParameter("@EventSequence", SqlDbType.Decimal));
108
sqlCommand.Parameters.
Add
(new SqlParameter("@EventOccurrence", SqlDbType.Decimal));
109
sqlCommand.Parameters.
Add
(new SqlParameter("@EventCode", SqlDbType.Int));
110
sqlCommand.Parameters.
Add
(new SqlParameter("@EventDetailCode", SqlDbType.Int));
111
sqlCommand.Parameters.
Add
(new SqlParameter("@Message", SqlDbType.NVarChar, 1024));
112
sqlCommand.Parameters.
Add
(new SqlParameter("@ApplicationPath", SqlDbType.NVarChar, 256));
113
sqlCommand.Parameters.
Add
(new SqlParameter("@ApplicationVirtualPath", SqlDbType.NVarChar, 256));
114
sqlCommand.Parameters.
Add
(new SqlParameter("@MachineName", SqlDbType.NVarChar, 256));
115
sqlCommand.Parameters.
Add
(new SqlParameter("@RequestUrl", SqlDbType.NVarChar, 1024));
116
sqlCommand.Parameters.
Add
(new SqlParameter("@ExceptionType", SqlDbType.NVarChar, 256));
117
sqlCommand.Parameters.
Add
(new SqlParameter("@Details", SqlDbType.NText));
Profile\SqlProfileProvider.cs (23)
167
cmd.Parameters.
Add
(CreateInputParam("@ApplicationName", SqlDbType.NVarChar, ApplicationName));
168
cmd.Parameters.
Add
(CreateInputParam("@UserName", SqlDbType.NVarChar, userName));
169
cmd.Parameters.
Add
(CreateInputParam("@CurrentTimeUtc", SqlDbType.DateTime, DateTime.UtcNow));
232
cmd.Parameters.
Add
(CreateInputParam("@ApplicationName", SqlDbType.NVarChar, ApplicationName));
233
cmd.Parameters.
Add
(CreateInputParam("@UserName", SqlDbType.NVarChar, username));
234
cmd.Parameters.
Add
(CreateInputParam("@PropertyNames", SqlDbType.NText, names));
235
cmd.Parameters.
Add
(CreateInputParam("@PropertyValuesString", SqlDbType.NText, values));
236
cmd.Parameters.
Add
(CreateInputParam("@PropertyValuesBinary", SqlDbType.Image, buf));
237
cmd.Parameters.
Add
(CreateInputParam("@IsUserAnonymous", SqlDbType.Bit, !userIsAuthenticated));
238
cmd.Parameters.
Add
(CreateInputParam("@CurrentTimeUtc", SqlDbType.DateTime, DateTime.UtcNow));
342
cmd.Parameters.
Add
(CreateInputParam("@ApplicationName", SqlDbType.NVarChar, ApplicationName));
343
cmd.Parameters.
Add
(CreateInputParam("@UserNames", SqlDbType.NVarChar, allUsers));
390
cmd.Parameters.
Add
(CreateInputParam("@ApplicationName", SqlDbType.NVarChar, ApplicationName));
391
cmd.Parameters.
Add
(CreateInputParam("@ProfileAuthOptions", SqlDbType.Int, (int) authenticationOption));
392
cmd.Parameters.
Add
(CreateInputParam("@InactiveSinceDate", SqlDbType.DateTime, userInactiveSinceDate.ToUniversalTime()));
424
cmd.Parameters.
Add
(CreateInputParam("@ApplicationName", SqlDbType.NVarChar, ApplicationName));
425
cmd.Parameters.
Add
(CreateInputParam("@ProfileAuthOptions", SqlDbType.Int, (int) authenticationOption));
426
cmd.Parameters.
Add
(CreateInputParam("@InactiveSinceDate", SqlDbType.DateTime, userInactiveSinceDate.ToUniversalTime()));
511
cmd.Parameters.
Add
(CreateInputParam("@ApplicationName", SqlDbType.NVarChar, ApplicationName));
512
cmd.Parameters.
Add
(CreateInputParam("@ProfileAuthOptions", SqlDbType.Int, (int) authenticationOption));
513
cmd.Parameters.
Add
(CreateInputParam("@PageIndex", SqlDbType.Int, pageIndex));
514
cmd.Parameters.
Add
(CreateInputParam("@PageSize", SqlDbType.Int, pageSize));
516
cmd.Parameters.
Add
(arg);
Security\SQLMembershipProvider.cs (105)
365
cmd.Parameters.
Add
(CreateInputParam("@ApplicationName", SqlDbType.NVarChar, ApplicationName));
366
cmd.Parameters.
Add
(CreateInputParam("@UserName", SqlDbType.NVarChar, username));
367
cmd.Parameters.
Add
(CreateInputParam("@Password", SqlDbType.NVarChar, pass));
368
cmd.Parameters.
Add
(CreateInputParam("@PasswordSalt", SqlDbType.NVarChar, salt));
369
cmd.Parameters.
Add
(CreateInputParam("@Email", SqlDbType.NVarChar, email));
370
cmd.Parameters.
Add
(CreateInputParam("@PasswordQuestion", SqlDbType.NVarChar, passwordQuestion));
371
cmd.Parameters.
Add
(CreateInputParam("@PasswordAnswer", SqlDbType.NVarChar, encodedPasswordAnswer));
372
cmd.Parameters.
Add
(CreateInputParam("@IsApproved", SqlDbType.Bit, isApproved));
373
cmd.Parameters.
Add
(CreateInputParam("@UniqueEmail", SqlDbType.Int, RequiresUniqueEmail ? 1 : 0));
374
cmd.Parameters.
Add
(CreateInputParam("@PasswordFormat", SqlDbType.Int, (int)PasswordFormat));
375
cmd.Parameters.
Add
(CreateInputParam("@CurrentTimeUtc", SqlDbType.DateTime, dt));
378
cmd.Parameters.
Add
( p );
382
cmd.Parameters.
Add
(p);
468
cmd.Parameters.
Add
(CreateInputParam("@ApplicationName", SqlDbType.NVarChar, ApplicationName));
469
cmd.Parameters.
Add
(CreateInputParam("@UserName", SqlDbType.NVarChar, username));
470
cmd.Parameters.
Add
(CreateInputParam("@NewPasswordQuestion", SqlDbType.NVarChar, newPasswordQuestion));
471
cmd.Parameters.
Add
(CreateInputParam("@NewPasswordAnswer", SqlDbType.NVarChar, encodedPasswordAnswer));
475
cmd.Parameters.
Add
(p);
625
cmd.Parameters.
Add
(CreateInputParam("@ApplicationName", SqlDbType.NVarChar, ApplicationName));
626
cmd.Parameters.
Add
(CreateInputParam("@UserName", SqlDbType.NVarChar, username));
627
cmd.Parameters.
Add
(CreateInputParam("@NewPassword", SqlDbType.NVarChar, pass));
628
cmd.Parameters.
Add
(CreateInputParam("@PasswordSalt", SqlDbType.NVarChar, salt));
629
cmd.Parameters.
Add
(CreateInputParam("@PasswordFormat", SqlDbType.Int, passwordFormat));
630
cmd.Parameters.
Add
(CreateInputParam("@CurrentTimeUtc", SqlDbType.DateTime, DateTime.UtcNow));
634
cmd.Parameters.
Add
(p);
745
cmd.Parameters.
Add
(CreateInputParam("@ApplicationName", SqlDbType.NVarChar, ApplicationName));
746
cmd.Parameters.
Add
(CreateInputParam("@UserName", SqlDbType.NVarChar, username));
747
cmd.Parameters.
Add
(CreateInputParam("@NewPassword", SqlDbType.NVarChar, EncodePassword(newPassword, (int) passwordFormat, salt)));
748
cmd.Parameters.
Add
(CreateInputParam("@MaxInvalidPasswordAttempts", SqlDbType.Int, MaxInvalidPasswordAttempts ) );
749
cmd.Parameters.
Add
(CreateInputParam("@PasswordAttemptWindow", SqlDbType.Int, PasswordAttemptWindow ) );
750
cmd.Parameters.
Add
(CreateInputParam("@PasswordSalt", SqlDbType.NVarChar, salt));
751
cmd.Parameters.
Add
(CreateInputParam("@PasswordFormat", SqlDbType.Int, (int)passwordFormat));
752
cmd.Parameters.
Add
(CreateInputParam("@CurrentTimeUtc", SqlDbType.DateTime, DateTime.UtcNow));
754
cmd.Parameters.
Add
(CreateInputParam("@PasswordAnswer", SqlDbType.NVarChar, encodedPasswordAnswer));
759
cmd.Parameters.
Add
(p);
825
cmd.Parameters.
Add
(CreateInputParam("@ApplicationName", SqlDbType.NVarChar, ApplicationName));
826
cmd.Parameters.
Add
(CreateInputParam("@UserName", SqlDbType.NVarChar, user.UserName));
827
cmd.Parameters.
Add
(CreateInputParam("@Email", SqlDbType.NVarChar, user.Email));
828
cmd.Parameters.
Add
(CreateInputParam("@Comment", SqlDbType.NText, user.Comment));
829
cmd.Parameters.
Add
(CreateInputParam("@IsApproved", SqlDbType.Bit, user.IsApproved ? 1 : 0));
830
cmd.Parameters.
Add
(CreateInputParam("@LastLoginDate", SqlDbType.DateTime, user.LastLoginDate.ToUniversalTime()));
831
cmd.Parameters.
Add
(CreateInputParam("@LastActivityDate", SqlDbType.DateTime, user.LastActivityDate.ToUniversalTime()));
832
cmd.Parameters.
Add
(CreateInputParam("@UniqueEmail", SqlDbType.Int, RequiresUniqueEmail ? 1 : 0));
833
cmd.Parameters.
Add
(CreateInputParam("@CurrentTimeUtc", SqlDbType.DateTime, DateTime.UtcNow));
837
cmd.Parameters.
Add
(p);
890
cmd.Parameters.
Add
(CreateInputParam("@ApplicationName", SqlDbType.NVarChar, ApplicationName));
891
cmd.Parameters.
Add
(CreateInputParam("@UserName", SqlDbType.NVarChar, username));
895
cmd.Parameters.
Add
(p);
942
cmd.Parameters.
Add
(CreateInputParam("@UserId", SqlDbType.UniqueIdentifier, providerUserKey ) );
943
cmd.Parameters.
Add
(CreateInputParam("@UpdateLastActivity", SqlDbType.Bit, userIsOnline));
944
cmd.Parameters.
Add
(CreateInputParam("@CurrentTimeUtc", SqlDbType.DateTime, DateTime.UtcNow));
947
cmd.Parameters.
Add
(p);
1030
cmd.Parameters.
Add
(CreateInputParam("@ApplicationName", SqlDbType.NVarChar, ApplicationName));
1031
cmd.Parameters.
Add
(CreateInputParam("@UserName", SqlDbType.NVarChar, username));
1032
cmd.Parameters.
Add
(CreateInputParam("@UpdateLastActivity", SqlDbType.Bit, userIsOnline));
1033
cmd.Parameters.
Add
(CreateInputParam("@CurrentTimeUtc", SqlDbType.DateTime, DateTime.UtcNow));
1036
cmd.Parameters.
Add
(p);
1121
cmd.Parameters.
Add
(CreateInputParam("@ApplicationName", SqlDbType.NVarChar, ApplicationName));
1122
cmd.Parameters.
Add
(CreateInputParam("@Email", SqlDbType.NVarChar, email));
1126
cmd.Parameters.
Add
(p);
1175
cmd.Parameters.
Add
(CreateInputParam("@ApplicationName", SqlDbType.NVarChar, ApplicationName));
1176
cmd.Parameters.
Add
(CreateInputParam("@UserName", SqlDbType.NVarChar, username));
1180
cmd.Parameters.
Add
(CreateInputParam("@TablesToDeleteFrom", SqlDbType.Int, 0xF));
1184
cmd.Parameters.
Add
(CreateInputParam("@TablesToDeleteFrom", SqlDbType.Int, 1));
1189
cmd.Parameters.
Add
(p);
1240
cmd.Parameters.
Add
(CreateInputParam("@ApplicationName", SqlDbType.NVarChar, ApplicationName));
1241
cmd.Parameters.
Add
(CreateInputParam("@PageIndex", SqlDbType.Int, pageIndex));
1242
cmd.Parameters.
Add
(CreateInputParam("@PageSize", SqlDbType.Int, pageSize));
1244
cmd.Parameters.
Add
(p);
1322
cmd.Parameters.
Add
(CreateInputParam("@ApplicationName", SqlDbType.NVarChar, ApplicationName));
1323
cmd.Parameters.
Add
(CreateInputParam("@MinutesSinceLastInActive", SqlDbType.Int, Membership.UserIsOnlineTimeWindow));
1324
cmd.Parameters.
Add
(CreateInputParam("@CurrentTimeUtc", SqlDbType.DateTime, DateTime.UtcNow));
1326
cmd.Parameters.
Add
(p);
1377
cmd.Parameters.
Add
(CreateInputParam("@ApplicationName", SqlDbType.NVarChar, ApplicationName));
1378
cmd.Parameters.
Add
(CreateInputParam("@UserNameToMatch", SqlDbType.NVarChar, usernameToMatch));
1379
cmd.Parameters.
Add
(CreateInputParam("@PageIndex", SqlDbType.Int, pageIndex));
1380
cmd.Parameters.
Add
(CreateInputParam("@PageSize", SqlDbType.Int, pageSize));
1381
cmd.Parameters.
Add
(p);
1475
cmd.Parameters.
Add
(CreateInputParam("@ApplicationName", SqlDbType.NVarChar, ApplicationName));
1476
cmd.Parameters.
Add
(CreateInputParam("@EmailToMatch", SqlDbType.NVarChar, emailToMatch));
1477
cmd.Parameters.
Add
(CreateInputParam("@PageIndex", SqlDbType.Int, pageIndex));
1478
cmd.Parameters.
Add
(CreateInputParam("@PageSize", SqlDbType.Int, pageSize));
1479
cmd.Parameters.
Add
(p);
1585
cmd.Parameters.
Add
( CreateInputParam( "@ApplicationName", SqlDbType.NVarChar, ApplicationName ) );
1586
cmd.Parameters.
Add
( CreateInputParam( "@UserName", SqlDbType.NVarChar, username ) );
1587
cmd.Parameters.
Add
( CreateInputParam( "@IsPasswordCorrect", SqlDbType.Bit, isPasswordCorrect ) );
1588
cmd.Parameters.
Add
( CreateInputParam( "@UpdateLastLoginActivityDate", SqlDbType.Bit, updateLastLoginActivityDate ) );
1589
cmd.Parameters.
Add
( CreateInputParam( "@MaxInvalidPasswordAttempts", SqlDbType.Int, MaxInvalidPasswordAttempts ) );
1590
cmd.Parameters.
Add
( CreateInputParam( "@PasswordAttemptWindow", SqlDbType.Int, PasswordAttemptWindow ) );
1591
cmd.Parameters.
Add
( CreateInputParam( "@CurrentTimeUtc", SqlDbType.DateTime, dtNow));
1592
cmd.Parameters.
Add
( CreateInputParam( "@LastLoginDate", SqlDbType.DateTime, isPasswordCorrect ? dtNow : lastLoginDate));
1593
cmd.Parameters.
Add
( CreateInputParam( "@LastActivityDate", SqlDbType.DateTime, isPasswordCorrect ? dtNow : lastActivityDate));
1596
cmd.Parameters.
Add
(p);
1646
cmd.Parameters.
Add
(CreateInputParam( "@ApplicationName", SqlDbType.NVarChar, ApplicationName ) );
1647
cmd.Parameters.
Add
(CreateInputParam( "@UserName", SqlDbType.NVarChar, username ) );
1648
cmd.Parameters.
Add
(CreateInputParam("@UpdateLastLoginActivityDate", SqlDbType.Bit, updateLastLoginActivityDate));
1649
cmd.Parameters.
Add
(CreateInputParam("@CurrentTimeUtc", SqlDbType.DateTime, DateTime.UtcNow));
1653
cmd.Parameters.
Add
(p);
1726
cmd.Parameters.
Add
( CreateInputParam( "@ApplicationName", SqlDbType.NVarChar, ApplicationName ) );
1727
cmd.Parameters.
Add
( CreateInputParam( "@UserName", SqlDbType.NVarChar, username ) );
1728
cmd.Parameters.
Add
( CreateInputParam( "@MaxInvalidPasswordAttempts", SqlDbType.Int, MaxInvalidPasswordAttempts ) );
1729
cmd.Parameters.
Add
( CreateInputParam( "@PasswordAttemptWindow", SqlDbType.Int, PasswordAttemptWindow ) );
1730
cmd.Parameters.
Add
(CreateInputParam("@CurrentTimeUtc", SqlDbType.DateTime, DateTime.UtcNow));
1734
cmd.Parameters.
Add
( CreateInputParam( "@PasswordAnswer", SqlDbType.NVarChar, passwordAnswer ) );
1739
cmd.Parameters.
Add
(p);
Security\SQLRoleProvider.cs (35)
120
cmd.Parameters.
Add
(p);
121
cmd.Parameters.
Add
(CreateInputParam("@ApplicationName", SqlDbType.NVarChar, ApplicationName));
122
cmd.Parameters.
Add
(CreateInputParam("@UserName", SqlDbType.NVarChar, username));
123
cmd.Parameters.
Add
(CreateInputParam("@RoleName", SqlDbType.NVarChar, roleName));
181
cmd.Parameters.
Add
(p);
182
cmd.Parameters.
Add
(CreateInputParam("@ApplicationName", SqlDbType.NVarChar, ApplicationName));
183
cmd.Parameters.
Add
(CreateInputParam("@UserName", SqlDbType.NVarChar, username));
251
cmd.Parameters.
Add
(p);
252
cmd.Parameters.
Add
(CreateInputParam("@ApplicationName", SqlDbType.NVarChar, ApplicationName));
253
cmd.Parameters.
Add
(CreateInputParam("@RoleName", SqlDbType.NVarChar, roleName));
304
cmd.Parameters.
Add
(p);
305
cmd.Parameters.
Add
(CreateInputParam("@ApplicationName", SqlDbType.NVarChar, ApplicationName));
306
cmd.Parameters.
Add
(CreateInputParam("@RoleName", SqlDbType.NVarChar, roleName));
307
cmd.Parameters.
Add
(CreateInputParam("@DeleteOnlyIfRoleIsEmpty", SqlDbType.Bit, throwOnPopulatedRole ? 1 : 0));
355
cmd.Parameters.
Add
(p);
356
cmd.Parameters.
Add
(CreateInputParam("@ApplicationName", SqlDbType.NVarChar, ApplicationName));
357
cmd.Parameters.
Add
(CreateInputParam("@RoleName", SqlDbType.NVarChar, roleName));
470
cmd.Parameters.
Add
(p);
471
cmd.Parameters.
Add
(CreateInputParam("@ApplicationName", SqlDbType.NVarChar, ApplicationName));
472
cmd.Parameters.
Add
(CreateInputParam("@RoleNames", SqlDbType.NVarChar, roleNames));
473
cmd.Parameters.
Add
(CreateInputParam("@UserNames", SqlDbType.NVarChar, usernames));
474
cmd.Parameters.
Add
(CreateInputParam("@CurrentTimeUtc", SqlDbType.DateTime, DateTime.UtcNow));
582
cmd.Parameters.
Add
(p);
583
cmd.Parameters.
Add
(CreateInputParam("@ApplicationName", SqlDbType.NVarChar, ApplicationName));
584
cmd.Parameters.
Add
(CreateInputParam("@UserNames", SqlDbType.NVarChar, usernames));
585
cmd.Parameters.
Add
(CreateInputParam("@RoleNames", SqlDbType.NVarChar, roleNames));
637
cmd.Parameters.
Add
(p);
638
cmd.Parameters.
Add
(CreateInputParam("@ApplicationName", SqlDbType.NVarChar, ApplicationName));
639
cmd.Parameters.
Add
(CreateInputParam("@RoleName", SqlDbType.NVarChar, roleName));
706
cmd.Parameters.
Add
(p);
707
cmd.Parameters.
Add
(CreateInputParam("@ApplicationName", SqlDbType.NVarChar, ApplicationName));
766
cmd.Parameters.
Add
(p);
767
cmd.Parameters.
Add
(CreateInputParam("@ApplicationName", SqlDbType.NVarChar, ApplicationName));
768
cmd.Parameters.
Add
(CreateInputParam("@RoleName", SqlDbType.NVarChar, roleName));
769
cmd.Parameters.
Add
(CreateInputParam("@UserNameToMatch", SqlDbType.NVarChar, usernameToMatch));
State\sqlstateclientmanager.cs (57)
1031
p = cmd.Parameters.
Add
(new SqlParameter("@@ver", SqlDbType.Int));
1074
p = cmdTempGetAppId.Parameters.
Add
(new SqlParameter("@appName", SqlDbType.VarChar, APPID_MAX));
1077
p = cmdTempGetAppId.Parameters.
Add
(new SqlParameter("@appId", SqlDbType.Int));
1289
_cmdTempGet.Parameters.
Add
(new SqlParameter("@id", SqlDbType.NVarChar, ID_LENGTH));
1290
p = _cmdTempGet.Parameters.
Add
(new SqlParameter("@itemShort", SqlDbType.VarBinary, ITEM_SHORT_LENGTH));
1292
p = _cmdTempGet.Parameters.
Add
(new SqlParameter("@locked", SqlDbType.Bit));
1294
p = _cmdTempGet.Parameters.
Add
(new SqlParameter("@lockAge", SqlDbType.Int));
1296
p = _cmdTempGet.Parameters.
Add
(new SqlParameter("@lockCookie", SqlDbType.Int));
1298
p = _cmdTempGet.Parameters.
Add
(new SqlParameter("@actionFlags", SqlDbType.Int));
1302
_cmdTempGet.Parameters.
Add
(new SqlParameter("@id", SqlDbType.NVarChar, ID_LENGTH));
1303
p = _cmdTempGet.Parameters.
Add
(new SqlParameter("@itemShort", SqlDbType.VarBinary, ITEM_SHORT_LENGTH));
1305
p = _cmdTempGet.Parameters.
Add
(new SqlParameter("@locked", SqlDbType.Bit));
1307
p = _cmdTempGet.Parameters.
Add
(new SqlParameter("@lockDate", SqlDbType.DateTime));
1309
p = _cmdTempGet.Parameters.
Add
(new SqlParameter("@lockCookie", SqlDbType.Int));
1311
p = _cmdTempGet.Parameters.
Add
(new SqlParameter("@actionFlags", SqlDbType.Int));
1331
_cmdTempGetExclusive.Parameters.
Add
(new SqlParameter("@id", SqlDbType.NVarChar, ID_LENGTH));
1332
p = _cmdTempGetExclusive.Parameters.
Add
(new SqlParameter("@itemShort", SqlDbType.VarBinary, ITEM_SHORT_LENGTH));
1334
p = _cmdTempGetExclusive.Parameters.
Add
(new SqlParameter("@locked", SqlDbType.Bit));
1336
p = _cmdTempGetExclusive.Parameters.
Add
(new SqlParameter("@lockAge", SqlDbType.Int));
1338
p = _cmdTempGetExclusive.Parameters.
Add
(new SqlParameter("@lockCookie", SqlDbType.Int));
1340
p = _cmdTempGetExclusive.Parameters.
Add
(new SqlParameter("@actionFlags", SqlDbType.Int));
1344
_cmdTempGetExclusive.Parameters.
Add
(new SqlParameter("@id", SqlDbType.NVarChar, ID_LENGTH));
1345
p = _cmdTempGetExclusive.Parameters.
Add
(new SqlParameter("@itemShort", SqlDbType.VarBinary, ITEM_SHORT_LENGTH));
1347
p = _cmdTempGetExclusive.Parameters.
Add
(new SqlParameter("@locked", SqlDbType.Bit));
1349
p = _cmdTempGetExclusive.Parameters.
Add
(new SqlParameter("@lockDate", SqlDbType.DateTime));
1351
p = _cmdTempGetExclusive.Parameters.
Add
(new SqlParameter("@lockCookie", SqlDbType.Int));
1353
p = _cmdTempGetExclusive.Parameters.
Add
(new SqlParameter("@actionFlags", SqlDbType.Int));
1369
_cmdTempReleaseExclusive.Parameters.
Add
(new SqlParameter("@id", SqlDbType.NVarChar, ID_LENGTH));
1370
_cmdTempReleaseExclusive.Parameters.
Add
(new SqlParameter("@lockCookie", SqlDbType.Int));
1383
_cmdTempInsertLong.Parameters.
Add
(new SqlParameter("@id", SqlDbType.NVarChar, ID_LENGTH));
1384
_cmdTempInsertLong.Parameters.
Add
(new SqlParameter("@itemLong", SqlDbType.Image, 8000));
1385
_cmdTempInsertLong.Parameters.
Add
(new SqlParameter("@timeout", SqlDbType.Int));
1399
_cmdTempInsertShort.Parameters.
Add
(new SqlParameter("@id", SqlDbType.NVarChar, ID_LENGTH));
1400
_cmdTempInsertShort.Parameters.
Add
(new SqlParameter("@itemShort", SqlDbType.VarBinary, ITEM_SHORT_LENGTH));
1401
_cmdTempInsertShort.Parameters.
Add
(new SqlParameter("@timeout", SqlDbType.Int));
1414
_cmdTempUpdateLong.Parameters.
Add
(new SqlParameter("@id", SqlDbType.NVarChar, ID_LENGTH));
1415
_cmdTempUpdateLong.Parameters.
Add
(new SqlParameter("@itemLong", SqlDbType.Image, 8000));
1416
_cmdTempUpdateLong.Parameters.
Add
(new SqlParameter("@timeout", SqlDbType.Int));
1417
_cmdTempUpdateLong.Parameters.
Add
(new SqlParameter("@lockCookie", SqlDbType.Int));
1431
_cmdTempUpdateShort.Parameters.
Add
(new SqlParameter("@id", SqlDbType.NVarChar, ID_LENGTH));
1432
_cmdTempUpdateShort.Parameters.
Add
(new SqlParameter("@itemShort", SqlDbType.VarBinary, ITEM_SHORT_LENGTH));
1433
_cmdTempUpdateShort.Parameters.
Add
(new SqlParameter("@timeout", SqlDbType.Int));
1434
_cmdTempUpdateShort.Parameters.
Add
(new SqlParameter("@lockCookie", SqlDbType.Int));
1448
_cmdTempUpdateShortNullLong.Parameters.
Add
(new SqlParameter("@id", SqlDbType.NVarChar, ID_LENGTH));
1449
_cmdTempUpdateShortNullLong.Parameters.
Add
(new SqlParameter("@itemShort", SqlDbType.VarBinary, ITEM_SHORT_LENGTH));
1450
_cmdTempUpdateShortNullLong.Parameters.
Add
(new SqlParameter("@timeout", SqlDbType.Int));
1451
_cmdTempUpdateShortNullLong.Parameters.
Add
(new SqlParameter("@lockCookie", SqlDbType.Int));
1464
_cmdTempUpdateLongNullShort.Parameters.
Add
(new SqlParameter("@id", SqlDbType.NVarChar, ID_LENGTH));
1465
_cmdTempUpdateLongNullShort.Parameters.
Add
(new SqlParameter("@itemLong", SqlDbType.Image, 8000));
1466
_cmdTempUpdateLongNullShort.Parameters.
Add
(new SqlParameter("@timeout", SqlDbType.Int));
1467
_cmdTempUpdateLongNullShort.Parameters.
Add
(new SqlParameter("@lockCookie", SqlDbType.Int));
1481
_cmdTempRemove.Parameters.
Add
(new SqlParameter("@id", SqlDbType.NVarChar, ID_LENGTH));
1482
_cmdTempRemove.Parameters.
Add
(new SqlParameter("@lockCookie", SqlDbType.Int));
1496
_cmdTempInsertUninitializedItem.Parameters.
Add
(new SqlParameter("@id", SqlDbType.NVarChar, ID_LENGTH));
1497
_cmdTempInsertUninitializedItem.Parameters.
Add
(new SqlParameter("@itemShort", SqlDbType.VarBinary, ITEM_SHORT_LENGTH));
1498
_cmdTempInsertUninitializedItem.Parameters.
Add
(new SqlParameter("@timeout", SqlDbType.Int));
1512
_cmdTempResetTimeout.Parameters.
Add
(new SqlParameter("@id", SqlDbType.NVarChar, ID_LENGTH));
UI\WebParts\SqlPersonalizationProvider.cs (25)
92
SqlParameter parameter = parameters.
Add
(new SqlParameter("AllUsersScope", SqlDbType.Bit));
101
parameters.
Add
(returnValue);
212
SqlParameter parameter = parameters.
Add
(new SqlParameter("AllUsersScope", SqlDbType.Bit));
221
parameters.
Add
(returnValue);
318
SqlParameter parameter = parameters.
Add
(new SqlParameter("Count", SqlDbType.Int));
321
parameter = parameters.
Add
(new SqlParameter("AllUsersScope", SqlDbType.Bit));
394
SqlParameter parameter = parameters.
Add
(new SqlParameter("Count", SqlDbType.Int));
397
parameter = parameters.
Add
(new SqlParameter("AllUsersScope", SqlDbType.Bit));
517
command.Parameters.
Add
(CreateParameter("@ApplicationName", SqlDbType.NVarChar, this.ApplicationName));
518
command.Parameters.
Add
(CreateParameter("@Path", SqlDbType.NVarChar, path));
520
command.Parameters.
Add
(CreateParameter("@UserName", SqlDbType.NVarChar, userName));
521
command.Parameters.
Add
(CreateParameter("@CurrentTimeUtc", SqlDbType.DateTime, DateTime.UtcNow));
593
command.Parameters.
Add
(CreateParameter("@ApplicationName", SqlDbType.NVarChar, ApplicationName));
594
command.Parameters.
Add
(CreateParameter("@Path", SqlDbType.NVarChar, path));
596
command.Parameters.
Add
(CreateParameter("@UserName", SqlDbType.NVarChar, userName));
597
command.Parameters.
Add
(CreateParameter("@CurrentTimeUtc", SqlDbType.DateTime, DateTime.UtcNow));
648
SqlParameter parameter = parameters.
Add
(new SqlParameter("AllUsersScope", SqlDbType.Bit));
653
parameter = parameters.
Add
(new SqlParameter("Count", SqlDbType.Int));
700
SqlParameter parameter = parameters.
Add
(new SqlParameter("Count", SqlDbType.Int));
813
SqlParameter parameter = parameters.
Add
(new SqlParameter("Count", SqlDbType.Int));
919
command.Parameters.
Add
(CreateParameter("@ApplicationName", SqlDbType.NVarChar, ApplicationName));
920
command.Parameters.
Add
(CreateParameter("@Path", SqlDbType.NVarChar, path));
921
command.Parameters.
Add
(CreateParameter("@PageSettings", SqlDbType.Image, state));
922
command.Parameters.
Add
(CreateParameter("@CurrentTimeUtc", SqlDbType.DateTime, DateTime.UtcNow));
924
command.Parameters.
Add
(CreateParameter("@UserName", SqlDbType.NVarChar, userName));
Util\SecUtil.cs (3)
273
cmd.Parameters.
Add
(p);
276
cmd.Parameters.
Add
(p);
280
cmd.Parameters.
Add
(p);
System.Workflow.Runtime (17)
Tracking\SqlTrackingQuery.cs (7)
176
cmd.Parameters.
Add
(param);
192
cmd.Parameters.
Add
(param);
205
cmd.Parameters.
Add
(param);
215
cmd.Parameters.
Add
(param);
224
cmd.Parameters.
Add
(param);
229
cmd.Parameters.
Add
(param);
279
cmd.Parameters.
Add
(param);
Tracking\SqlTrackingWorkflowInstance.cs (10)
553
cmd.Parameters.
Add
(new SqlParameter("@WorkflowInstanceInternalId", _internalId));
554
cmd.Parameters.
Add
(new SqlParameter("@BeginDateTime", SqlDateTime.MinValue.Value));
555
cmd.Parameters.
Add
(new SqlParameter("@WorkflowInstanceEventId", kvp.Key));
670
cmd.Parameters.
Add
(new SqlParameter("@WorkflowInstanceInternalId", _internalId));
767
cmd.Parameters.
Add
(param);
771
cmd.Parameters.
Add
(param);
775
cmd.Parameters.
Add
(param);
859
cmd.Parameters.
Add
(param);
863
cmd.Parameters.
Add
(param);
867
cmd.Parameters.
Add
(param);
System.WorkflowServices (27)
System\ServiceModel\Persistence\SqlPersistenceProviderFactory.cs (27)
771
command.Parameters.
Add
(idParameter);
787
command.Parameters.
Add
(instanceParameter);
788
command.Parameters.
Add
(instanceXmlParameter);
792
command.Parameters.
Add
(unlockInstanceParameter);
796
command.Parameters.
Add
(lockOwnerParameter);
800
command.Parameters.
Add
(lockTimeoutParameter);
804
command.Parameters.
Add
(resultParameter);
848
command.Parameters.
Add
(idParameter);
852
command.Parameters.
Add
(hostIdParameter);
856
command.Parameters.
Add
(lockTimeoutParameter);
860
command.Parameters.
Add
(resultParameter);
950
command.Parameters.
Add
(idParameter);
954
command.Parameters.
Add
(lockInstanceParameter);
958
command.Parameters.
Add
(hostIdParameter);
962
command.Parameters.
Add
(lockTimeoutParameter);
966
command.Parameters.
Add
(resultParameter);
1413
command.Parameters.
Add
(idParameter);
1417
command.Parameters.
Add
(hostIdParameter);
1421
command.Parameters.
Add
(lockTimeoutParameter);
1425
command.Parameters.
Add
(resultParameter);
1472
command.Parameters.
Add
(idParameter);
1488
command.Parameters.
Add
(instanceParameter);
1489
command.Parameters.
Add
(instanceXmlParameter);
1493
command.Parameters.
Add
(unlockInstanceParameter);
1497
command.Parameters.
Add
(lockOwnerParameter);
1501
command.Parameters.
Add
(lockTimeoutParameter);
1505
command.Parameters.
Add
(resultParameter);