67SqlParameterCollection parameters = sqlCommand.Parameters;

37sqlCommand.Parameters.Add(new SqlParameter { ParameterName = "@surrogateLockOwnerId", SqlDbType = SqlDbType.BigInt, Value = this.surrogateLockOwnerId });

46sqlCommand.Parameters.Add(new SqlParameter { ParameterName = "@machineName", SqlDbType = SqlDbType.NVarChar, Value = SqlWorkflowInstanceStoreConstants.MachineName });

46sqlCommand.Parameters.Add(new SqlParameter { ParameterName = "@workflowHostType", SqlDbType = SqlDbType.UniqueIdentifier, Value = base.Store.WorkflowHostType }); 49sqlCommand.Parameters.Add(new SqlParameter { ParameterName = "@surrogateLockOwnerId", SqlDbType = SqlDbType.BigInt, Value = base.StoreLock.SurrogateLockOwnerId });

48sqlCommand.Parameters.Add(new SqlParameter { ParameterName = "@surrogateLockOwnerId", SqlDbType = SqlDbType.BigInt, Value = surrogateOwnerId }); 49sqlCommand.Parameters.Add(new SqlParameter { ParameterName = "@lockTimeout", SqlDbType = SqlDbType.Int, Value = lockTimeout });

64SqlParameterCollection parameters = command.Parameters;

70SqlParameterCollection parameters = command.Parameters;

237SqlParameter[] tempParameterList = new SqlParameter[command.Parameters.Count]; 238for (int i = 0; i < command.Parameters.Count; i++) 240tempParameterList[i] = command.Parameters[i]; 242command.Parameters.Clear(); 243newCommand.Parameters.AddRange(tempParameterList);

146foreach (SqlParameter sqlParameter in command.Parameters)

41command.Parameters.Add(new SqlParameter { ParameterName = "@surrogateLockOwnerId", SqlDbType = SqlDbType.BigInt, Value = base.StoreLock.SurrogateLockOwnerId }); 42command.Parameters.Add(new SqlParameter { ParameterName = "@workflowHostType", SqlDbType = SqlDbType.UniqueIdentifier, Value = base.Store.WorkflowHostType }); 43command.Parameters.Add(new SqlParameter { ParameterName = "@operationType", SqlDbType = SqlDbType.TinyInt, Value = LoadType.LoadByInstance }); 44command.Parameters.Add(new SqlParameter { ParameterName = "@handleInstanceVersion", SqlDbType = SqlDbType.BigInt, Value = base.InstancePersistenceContext.InstanceVersion }); 45command.Parameters.Add(new SqlParameter { ParameterName = "@handleIsBoundToLock", SqlDbType = SqlDbType.Bit, Value = base.InstancePersistenceContext.InstanceView.IsBoundToLock }); 46command.Parameters.Add(new SqlParameter { ParameterName = "@encodingOption", SqlDbType = SqlDbType.TinyInt, Value = base.Store.InstanceEncodingOption }); 47command.Parameters.Add(new SqlParameter { ParameterName = "@operationTimeout", SqlDbType = SqlDbType.Int, Value = (operationTimeout < Int32.MaxValue) ? Convert.ToInt32(operationTimeout) : Int32.MaxValue });

36sqlCommand.Parameters.Add(new SqlParameter { ParameterName = "@instanceId", SqlDbType = SqlDbType.UniqueIdentifier, Value = unlockCommand.InstanceId }); 37sqlCommand.Parameters.Add(new SqlParameter { ParameterName = "@surrogateLockOwnerId", SqlDbType = SqlDbType.BigInt, Value = unlockCommand.SurrogateOwnerId }); 38sqlCommand.Parameters.Add(new SqlParameter { ParameterName = "@handleInstanceVersion", SqlDbType = SqlDbType.BigInt, Value = unlockCommand.InstanceVersion });

436SqlParameterCollection parameters = Parameters; 437foreach(object parameter in from.Parameters) { 762return Parameters; 2796paramsCmd.Parameters.Add(new SqlParameter("@procedure_name", SqlDbType.NVarChar, 255)); 2797paramsCmd.Parameters[0].Value = UnquoteProcedureName(parsedSProc[3], out groupNumber); // ProcedureName is 4rd element in parsed array 2800SqlParameter param = paramsCmd.Parameters.Add(new SqlParameter("@group_number", SqlDbType.Int)); 2805SqlParameter param = paramsCmd.Parameters.Add(new SqlParameter("@procedure_schema", SqlDbType.NVarChar, 255)); 2956this.Parameters.Clear(); 6211int count = GetParameterCount( Parameters ); 6218SqlParameter param = Parameters[index]; 6249SqlParameter param = Parameters[index];

115Bid.Trace("<sc.SqlCommandSet.Append|API> %d#, command=%d, parameterCount=%d\n", ObjectID, command.ObjectID, command.Parameters.Count); 137SqlParameterCollection collection = command.Parameters; 262BatchCommand.Parameters.Clear();

1994c.Parameters.Add(p); 2000c.Parameters.Add(p); 2004c.Parameters.Add(p); 2011c.Parameters.Add(p); 2015c.Parameters.Add(p); 2022c.Parameters.Add(p);

1169for (int i=0; i<command.Parameters.Count; i++) { 1170object value = command.Parameters[i].Value;

155_com.Parameters.Add(_timeoutParam); 439com.Parameters.Add(param); 583if (_com.Parameters.Count > 1) { // Remove conversation param since next execute is only query. 584_com.Parameters.Remove(_conversationGuidParam); 586Debug.Assert(_com.Parameters.Count == 1, "Unexpected number of parameters!"); 591if (_com.Parameters.Count == 1) { // Add parameter if previous execute was only query. 592_com.Parameters.Add(_conversationGuidParam); 594Debug.Assert(_com.Parameters.Count == 2, "Unexpected number of parameters!"); 873if (_com.Parameters.Count > 1) { // Need to close dialog before completing. 882_com.Parameters.Remove(_timeoutParam);

340transactionLevelCommand.Parameters.Add(parameter);

134command.Parameters.Add(parameter); 146command.Parameters.Add(parameter);

1501sqlCmd.Parameters.Add(new SqlParameter("@tableName", SqlDbType.NVarChar, table.Length)); 1502sqlCmd.Parameters[0].Value = table;

269command.Parameters.AddWithValue("@dbname", databaseName); 270command.Parameters.AddWithValue("@skipchecks", "true");

559cmd.Parameters.Add(new SqlParameter("@database", databaseNoSquareBrackets)); 610cmd.Parameters.Add(new SqlParameter("@TablesToCheck", itablesToCheck));

103sqlCommand.Parameters.Add(new SqlParameter("@EventId", SqlDbType.Char, 32)); 104sqlCommand.Parameters.Add(new SqlParameter("@EventTimeUtc", SqlDbType.DateTime)); 105sqlCommand.Parameters.Add(new SqlParameter("@EventTime", SqlDbType.DateTime)); 106sqlCommand.Parameters.Add(new SqlParameter("@EventType", SqlDbType.NVarChar, 256)); 107sqlCommand.Parameters.Add(new SqlParameter("@EventSequence", SqlDbType.Decimal)); 108sqlCommand.Parameters.Add(new SqlParameter("@EventOccurrence", SqlDbType.Decimal)); 109sqlCommand.Parameters.Add(new SqlParameter("@EventCode", SqlDbType.Int)); 110sqlCommand.Parameters.Add(new SqlParameter("@EventDetailCode", SqlDbType.Int)); 111sqlCommand.Parameters.Add(new SqlParameter("@Message", SqlDbType.NVarChar, 1024)); 112sqlCommand.Parameters.Add(new SqlParameter("@ApplicationPath", SqlDbType.NVarChar, 256)); 113sqlCommand.Parameters.Add(new SqlParameter("@ApplicationVirtualPath", SqlDbType.NVarChar, 256)); 114sqlCommand.Parameters.Add(new SqlParameter("@MachineName", SqlDbType.NVarChar, 256)); 115sqlCommand.Parameters.Add(new SqlParameter("@RequestUrl", SqlDbType.NVarChar, 1024)); 116sqlCommand.Parameters.Add(new SqlParameter("@ExceptionType", SqlDbType.NVarChar, 256)); 117sqlCommand.Parameters.Add(new SqlParameter("@Details", SqlDbType.NText)); 127sqlCommand.Parameters[n++].Value = eventRaised.EventID.ToString("N", CultureInfo.InstalledUICulture); // @EventId 128sqlCommand.Parameters[n++].Value = eventRaised.EventTimeUtc; // @EventTimeUtc 129sqlCommand.Parameters[n++].Value = eventRaised.EventTime; // @EventTime 130sqlCommand.Parameters[n++].Value = eventRaised.GetType().ToString(); // @EventType 131sqlCommand.Parameters[n++].Value = eventRaised.EventSequence; // @EventSequence 132sqlCommand.Parameters[n++].Value = eventRaised.EventOccurrence; // @EventOccurrence 133sqlCommand.Parameters[n++].Value = eventRaised.EventCode; // @EventCode 134sqlCommand.Parameters[n++].Value = eventRaised.EventDetailCode; // @EventDetailCode 135sqlCommand.Parameters[n++].Value = eventRaised.Message; // @Message 136sqlCommand.Parameters[n++].Value = appInfo.ApplicationPath; // @ApplicationPath 137sqlCommand.Parameters[n++].Value = appInfo.ApplicationVirtualPath; // @ApplicationVirtualPath 138sqlCommand.Parameters[n++].Value = appInfo.MachineName; // @MachineName 155sqlCommand.Parameters[n++].Value = (reqInfo != null) ? reqInfo.RequestUrl : Convert.DBNull; 161sqlCommand.Parameters[n++].Value = (exception != null) ? exception.GetType().ToString() : Convert.DBNull; 169sqlCommand.Parameters[n++].Value = details;

167cmd.Parameters.Add(CreateInputParam("@ApplicationName", SqlDbType.NVarChar, ApplicationName)); 168cmd.Parameters.Add(CreateInputParam("@UserName", SqlDbType.NVarChar, userName)); 169cmd.Parameters.Add(CreateInputParam("@CurrentTimeUtc", SqlDbType.DateTime, DateTime.UtcNow)); 232cmd.Parameters.Add(CreateInputParam("@ApplicationName", SqlDbType.NVarChar, ApplicationName)); 233cmd.Parameters.Add(CreateInputParam("@UserName", SqlDbType.NVarChar, username)); 234cmd.Parameters.Add(CreateInputParam("@PropertyNames", SqlDbType.NText, names)); 235cmd.Parameters.Add(CreateInputParam("@PropertyValuesString", SqlDbType.NText, values)); 236cmd.Parameters.Add(CreateInputParam("@PropertyValuesBinary", SqlDbType.Image, buf)); 237cmd.Parameters.Add(CreateInputParam("@IsUserAnonymous", SqlDbType.Bit, !userIsAuthenticated)); 238cmd.Parameters.Add(CreateInputParam("@CurrentTimeUtc", SqlDbType.DateTime, DateTime.UtcNow)); 342cmd.Parameters.Add(CreateInputParam("@ApplicationName", SqlDbType.NVarChar, ApplicationName)); 343cmd.Parameters.Add(CreateInputParam("@UserNames", SqlDbType.NVarChar, allUsers)); 390cmd.Parameters.Add(CreateInputParam("@ApplicationName", SqlDbType.NVarChar, ApplicationName)); 391cmd.Parameters.Add(CreateInputParam("@ProfileAuthOptions", SqlDbType.Int, (int) authenticationOption)); 392cmd.Parameters.Add(CreateInputParam("@InactiveSinceDate", SqlDbType.DateTime, userInactiveSinceDate.ToUniversalTime())); 424cmd.Parameters.Add(CreateInputParam("@ApplicationName", SqlDbType.NVarChar, ApplicationName)); 425cmd.Parameters.Add(CreateInputParam("@ProfileAuthOptions", SqlDbType.Int, (int) authenticationOption)); 426cmd.Parameters.Add(CreateInputParam("@InactiveSinceDate", SqlDbType.DateTime, userInactiveSinceDate.ToUniversalTime())); 511cmd.Parameters.Add(CreateInputParam("@ApplicationName", SqlDbType.NVarChar, ApplicationName)); 512cmd.Parameters.Add(CreateInputParam("@ProfileAuthOptions", SqlDbType.Int, (int) authenticationOption)); 513cmd.Parameters.Add(CreateInputParam("@PageIndex", SqlDbType.Int, pageIndex)); 514cmd.Parameters.Add(CreateInputParam("@PageSize", SqlDbType.Int, pageSize)); 516cmd.Parameters.Add(arg);

365cmd.Parameters.Add(CreateInputParam("@ApplicationName", SqlDbType.NVarChar, ApplicationName)); 366cmd.Parameters.Add(CreateInputParam("@UserName", SqlDbType.NVarChar, username)); 367cmd.Parameters.Add(CreateInputParam("@Password", SqlDbType.NVarChar, pass)); 368cmd.Parameters.Add(CreateInputParam("@PasswordSalt", SqlDbType.NVarChar, salt)); 369cmd.Parameters.Add(CreateInputParam("@Email", SqlDbType.NVarChar, email)); 370cmd.Parameters.Add(CreateInputParam("@PasswordQuestion", SqlDbType.NVarChar, passwordQuestion)); 371cmd.Parameters.Add(CreateInputParam("@PasswordAnswer", SqlDbType.NVarChar, encodedPasswordAnswer)); 372cmd.Parameters.Add(CreateInputParam("@IsApproved", SqlDbType.Bit, isApproved)); 373cmd.Parameters.Add(CreateInputParam("@UniqueEmail", SqlDbType.Int, RequiresUniqueEmail ? 1 : 0)); 374cmd.Parameters.Add(CreateInputParam("@PasswordFormat", SqlDbType.Int, (int)PasswordFormat)); 375cmd.Parameters.Add(CreateInputParam("@CurrentTimeUtc", SqlDbType.DateTime, dt)); 378cmd.Parameters.Add( p ); 382cmd.Parameters.Add(p); 400providerUserKey = new Guid( cmd.Parameters[ "@UserId" ].Value.ToString() ); 468cmd.Parameters.Add(CreateInputParam("@ApplicationName", SqlDbType.NVarChar, ApplicationName)); 469cmd.Parameters.Add(CreateInputParam("@UserName", SqlDbType.NVarChar, username)); 470cmd.Parameters.Add(CreateInputParam("@NewPasswordQuestion", SqlDbType.NVarChar, newPasswordQuestion)); 471cmd.Parameters.Add(CreateInputParam("@NewPasswordAnswer", SqlDbType.NVarChar, encodedPasswordAnswer)); 475cmd.Parameters.Add(p); 625cmd.Parameters.Add(CreateInputParam("@ApplicationName", SqlDbType.NVarChar, ApplicationName)); 626cmd.Parameters.Add(CreateInputParam("@UserName", SqlDbType.NVarChar, username)); 627cmd.Parameters.Add(CreateInputParam("@NewPassword", SqlDbType.NVarChar, pass)); 628cmd.Parameters.Add(CreateInputParam("@PasswordSalt", SqlDbType.NVarChar, salt)); 629cmd.Parameters.Add(CreateInputParam("@PasswordFormat", SqlDbType.Int, passwordFormat)); 630cmd.Parameters.Add(CreateInputParam("@CurrentTimeUtc", SqlDbType.DateTime, DateTime.UtcNow)); 634cmd.Parameters.Add(p); 745cmd.Parameters.Add(CreateInputParam("@ApplicationName", SqlDbType.NVarChar, ApplicationName)); 746cmd.Parameters.Add(CreateInputParam("@UserName", SqlDbType.NVarChar, username)); 747cmd.Parameters.Add(CreateInputParam("@NewPassword", SqlDbType.NVarChar, EncodePassword(newPassword, (int) passwordFormat, salt))); 748cmd.Parameters.Add(CreateInputParam("@MaxInvalidPasswordAttempts", SqlDbType.Int, MaxInvalidPasswordAttempts ) ); 749cmd.Parameters.Add(CreateInputParam("@PasswordAttemptWindow", SqlDbType.Int, PasswordAttemptWindow ) ); 750cmd.Parameters.Add(CreateInputParam("@PasswordSalt", SqlDbType.NVarChar, salt)); 751cmd.Parameters.Add(CreateInputParam("@PasswordFormat", SqlDbType.Int, (int)passwordFormat)); 752cmd.Parameters.Add(CreateInputParam("@CurrentTimeUtc", SqlDbType.DateTime, DateTime.UtcNow)); 754cmd.Parameters.Add(CreateInputParam("@PasswordAnswer", SqlDbType.NVarChar, encodedPasswordAnswer)); 759cmd.Parameters.Add(p); 825cmd.Parameters.Add(CreateInputParam("@ApplicationName", SqlDbType.NVarChar, ApplicationName)); 826cmd.Parameters.Add(CreateInputParam("@UserName", SqlDbType.NVarChar, user.UserName)); 827cmd.Parameters.Add(CreateInputParam("@Email", SqlDbType.NVarChar, user.Email)); 828cmd.Parameters.Add(CreateInputParam("@Comment", SqlDbType.NText, user.Comment)); 829cmd.Parameters.Add(CreateInputParam("@IsApproved", SqlDbType.Bit, user.IsApproved ? 1 : 0)); 830cmd.Parameters.Add(CreateInputParam("@LastLoginDate", SqlDbType.DateTime, user.LastLoginDate.ToUniversalTime())); 831cmd.Parameters.Add(CreateInputParam("@LastActivityDate", SqlDbType.DateTime, user.LastActivityDate.ToUniversalTime())); 832cmd.Parameters.Add(CreateInputParam("@UniqueEmail", SqlDbType.Int, RequiresUniqueEmail ? 1 : 0)); 833cmd.Parameters.Add(CreateInputParam("@CurrentTimeUtc", SqlDbType.DateTime, DateTime.UtcNow)); 837cmd.Parameters.Add(p); 890cmd.Parameters.Add(CreateInputParam("@ApplicationName", SqlDbType.NVarChar, ApplicationName)); 891cmd.Parameters.Add(CreateInputParam("@UserName", SqlDbType.NVarChar, username)); 895cmd.Parameters.Add(p); 942cmd.Parameters.Add(CreateInputParam("@UserId", SqlDbType.UniqueIdentifier, providerUserKey ) ); 943cmd.Parameters.Add(CreateInputParam("@UpdateLastActivity", SqlDbType.Bit, userIsOnline)); 944cmd.Parameters.Add(CreateInputParam("@CurrentTimeUtc", SqlDbType.DateTime, DateTime.UtcNow)); 947cmd.Parameters.Add(p); 1030cmd.Parameters.Add(CreateInputParam("@ApplicationName", SqlDbType.NVarChar, ApplicationName)); 1031cmd.Parameters.Add(CreateInputParam("@UserName", SqlDbType.NVarChar, username)); 1032cmd.Parameters.Add(CreateInputParam("@UpdateLastActivity", SqlDbType.Bit, userIsOnline)); 1033cmd.Parameters.Add(CreateInputParam("@CurrentTimeUtc", SqlDbType.DateTime, DateTime.UtcNow)); 1036cmd.Parameters.Add(p); 1121cmd.Parameters.Add(CreateInputParam("@ApplicationName", SqlDbType.NVarChar, ApplicationName)); 1122cmd.Parameters.Add(CreateInputParam("@Email", SqlDbType.NVarChar, email)); 1126cmd.Parameters.Add(p); 1175cmd.Parameters.Add(CreateInputParam("@ApplicationName", SqlDbType.NVarChar, ApplicationName)); 1176cmd.Parameters.Add(CreateInputParam("@UserName", SqlDbType.NVarChar, username)); 1180cmd.Parameters.Add(CreateInputParam("@TablesToDeleteFrom", SqlDbType.Int, 0xF)); 1184cmd.Parameters.Add(CreateInputParam("@TablesToDeleteFrom", SqlDbType.Int, 1)); 1189cmd.Parameters.Add(p); 1240cmd.Parameters.Add(CreateInputParam("@ApplicationName", SqlDbType.NVarChar, ApplicationName)); 1241cmd.Parameters.Add(CreateInputParam("@PageIndex", SqlDbType.Int, pageIndex)); 1242cmd.Parameters.Add(CreateInputParam("@PageSize", SqlDbType.Int, pageSize)); 1244cmd.Parameters.Add(p); 1322cmd.Parameters.Add(CreateInputParam("@ApplicationName", SqlDbType.NVarChar, ApplicationName)); 1323cmd.Parameters.Add(CreateInputParam("@MinutesSinceLastInActive", SqlDbType.Int, Membership.UserIsOnlineTimeWindow)); 1324cmd.Parameters.Add(CreateInputParam("@CurrentTimeUtc", SqlDbType.DateTime, DateTime.UtcNow)); 1326cmd.Parameters.Add(p); 1377cmd.Parameters.Add(CreateInputParam("@ApplicationName", SqlDbType.NVarChar, ApplicationName)); 1378cmd.Parameters.Add(CreateInputParam("@UserNameToMatch", SqlDbType.NVarChar, usernameToMatch)); 1379cmd.Parameters.Add(CreateInputParam("@PageIndex", SqlDbType.Int, pageIndex)); 1380cmd.Parameters.Add(CreateInputParam("@PageSize", SqlDbType.Int, pageSize)); 1381cmd.Parameters.Add(p); 1475cmd.Parameters.Add(CreateInputParam("@ApplicationName", SqlDbType.NVarChar, ApplicationName)); 1476cmd.Parameters.Add(CreateInputParam("@EmailToMatch", SqlDbType.NVarChar, emailToMatch)); 1477cmd.Parameters.Add(CreateInputParam("@PageIndex", SqlDbType.Int, pageIndex)); 1478cmd.Parameters.Add(CreateInputParam("@PageSize", SqlDbType.Int, pageSize)); 1479cmd.Parameters.Add(p); 1585cmd.Parameters.Add( CreateInputParam( "@ApplicationName", SqlDbType.NVarChar, ApplicationName ) ); 1586cmd.Parameters.Add( CreateInputParam( "@UserName", SqlDbType.NVarChar, username ) ); 1587cmd.Parameters.Add( CreateInputParam( "@IsPasswordCorrect", SqlDbType.Bit, isPasswordCorrect ) ); 1588cmd.Parameters.Add( CreateInputParam( "@UpdateLastLoginActivityDate", SqlDbType.Bit, updateLastLoginActivityDate ) ); 1589cmd.Parameters.Add( CreateInputParam( "@MaxInvalidPasswordAttempts", SqlDbType.Int, MaxInvalidPasswordAttempts ) ); 1590cmd.Parameters.Add( CreateInputParam( "@PasswordAttemptWindow", SqlDbType.Int, PasswordAttemptWindow ) ); 1591cmd.Parameters.Add( CreateInputParam( "@CurrentTimeUtc", SqlDbType.DateTime, dtNow)); 1592cmd.Parameters.Add( CreateInputParam( "@LastLoginDate", SqlDbType.DateTime, isPasswordCorrect ? dtNow : lastLoginDate)); 1593cmd.Parameters.Add( CreateInputParam( "@LastActivityDate", SqlDbType.DateTime, isPasswordCorrect ? dtNow : lastActivityDate)); 1596cmd.Parameters.Add(p); 1646cmd.Parameters.Add(CreateInputParam( "@ApplicationName", SqlDbType.NVarChar, ApplicationName ) ); 1647cmd.Parameters.Add(CreateInputParam( "@UserName", SqlDbType.NVarChar, username ) ); 1648cmd.Parameters.Add(CreateInputParam("@UpdateLastLoginActivityDate", SqlDbType.Bit, updateLastLoginActivityDate)); 1649cmd.Parameters.Add(CreateInputParam("@CurrentTimeUtc", SqlDbType.DateTime, DateTime.UtcNow)); 1653cmd.Parameters.Add(p); 1726cmd.Parameters.Add( CreateInputParam( "@ApplicationName", SqlDbType.NVarChar, ApplicationName ) ); 1727cmd.Parameters.Add( CreateInputParam( "@UserName", SqlDbType.NVarChar, username ) ); 1728cmd.Parameters.Add( CreateInputParam( "@MaxInvalidPasswordAttempts", SqlDbType.Int, MaxInvalidPasswordAttempts ) ); 1729cmd.Parameters.Add( CreateInputParam( "@PasswordAttemptWindow", SqlDbType.Int, PasswordAttemptWindow ) ); 1730cmd.Parameters.Add(CreateInputParam("@CurrentTimeUtc", SqlDbType.DateTime, DateTime.UtcNow)); 1734cmd.Parameters.Add( CreateInputParam( "@PasswordAnswer", SqlDbType.NVarChar, passwordAnswer ) ); 1739cmd.Parameters.Add(p);

120cmd.Parameters.Add(p); 121cmd.Parameters.Add(CreateInputParam("@ApplicationName", SqlDbType.NVarChar, ApplicationName)); 122cmd.Parameters.Add(CreateInputParam("@UserName", SqlDbType.NVarChar, username)); 123cmd.Parameters.Add(CreateInputParam("@RoleName", SqlDbType.NVarChar, roleName)); 181cmd.Parameters.Add(p); 182cmd.Parameters.Add(CreateInputParam("@ApplicationName", SqlDbType.NVarChar, ApplicationName)); 183cmd.Parameters.Add(CreateInputParam("@UserName", SqlDbType.NVarChar, username)); 251cmd.Parameters.Add(p); 252cmd.Parameters.Add(CreateInputParam("@ApplicationName", SqlDbType.NVarChar, ApplicationName)); 253cmd.Parameters.Add(CreateInputParam("@RoleName", SqlDbType.NVarChar, roleName)); 304cmd.Parameters.Add(p); 305cmd.Parameters.Add(CreateInputParam("@ApplicationName", SqlDbType.NVarChar, ApplicationName)); 306cmd.Parameters.Add(CreateInputParam("@RoleName", SqlDbType.NVarChar, roleName)); 307cmd.Parameters.Add(CreateInputParam("@DeleteOnlyIfRoleIsEmpty", SqlDbType.Bit, throwOnPopulatedRole ? 1 : 0)); 355cmd.Parameters.Add(p); 356cmd.Parameters.Add(CreateInputParam("@ApplicationName", SqlDbType.NVarChar, ApplicationName)); 357cmd.Parameters.Add(CreateInputParam("@RoleName", SqlDbType.NVarChar, roleName)); 470cmd.Parameters.Add(p); 471cmd.Parameters.Add(CreateInputParam("@ApplicationName", SqlDbType.NVarChar, ApplicationName)); 472cmd.Parameters.Add(CreateInputParam("@RoleNames", SqlDbType.NVarChar, roleNames)); 473cmd.Parameters.Add(CreateInputParam("@UserNames", SqlDbType.NVarChar, usernames)); 474cmd.Parameters.Add(CreateInputParam("@CurrentTimeUtc", SqlDbType.DateTime, DateTime.UtcNow)); 582cmd.Parameters.Add(p); 583cmd.Parameters.Add(CreateInputParam("@ApplicationName", SqlDbType.NVarChar, ApplicationName)); 584cmd.Parameters.Add(CreateInputParam("@UserNames", SqlDbType.NVarChar, usernames)); 585cmd.Parameters.Add(CreateInputParam("@RoleNames", SqlDbType.NVarChar, roleNames)); 637cmd.Parameters.Add(p); 638cmd.Parameters.Add(CreateInputParam("@ApplicationName", SqlDbType.NVarChar, ApplicationName)); 639cmd.Parameters.Add(CreateInputParam("@RoleName", SqlDbType.NVarChar, roleName)); 706cmd.Parameters.Add(p); 707cmd.Parameters.Add(CreateInputParam("@ApplicationName", SqlDbType.NVarChar, ApplicationName)); 766cmd.Parameters.Add(p); 767cmd.Parameters.Add(CreateInputParam("@ApplicationName", SqlDbType.NVarChar, ApplicationName)); 768cmd.Parameters.Add(CreateInputParam("@RoleName", SqlDbType.NVarChar, roleName)); 769cmd.Parameters.Add(CreateInputParam("@UserNameToMatch", SqlDbType.NVarChar, usernameToMatch)); 848foreach(SqlParameter param in cmd.Parameters){

487cmd.Parameters[0].Value = id + _partitionInfo.AppSuffix; // @id 488cmd.Parameters[1].Value = Convert.DBNull; // @itemShort 489cmd.Parameters[2].Value = Convert.DBNull; // @locked 490cmd.Parameters[3].Value = Convert.DBNull; // @lockDate or @lockAge 491cmd.Parameters[4].Value = Convert.DBNull; // @lockCookie 492cmd.Parameters[5].Value = Convert.DBNull; // @actionFlags 510if (Convert.IsDBNull(cmd.Parameters[2].Value)) { 516Debug.Assert(!Convert.IsDBNull(cmd.Parameters[3].Value), "!Convert.IsDBNull(cmd.Parameters[3].Value)"); 517Debug.Assert(!Convert.IsDBNull(cmd.Parameters[4].Value), "!Convert.IsDBNull(cmd.Parameters[4].Value)"); 519locked = (bool) cmd.Parameters[2].Value; 520lockId = (int) cmd.Parameters[4].Value; 524Debug.Assert(((int)cmd.Parameters[5].Value & (int)SessionStateActions.InitializeItem) == 0, 528lockAge = new TimeSpan(0, 0, (int) cmd.Parameters[3].Value); 532lockDate = (DateTime) cmd.Parameters[3].Value; 545actionFlags = (SessionStateActions) cmd.Parameters[5].Value; 549Debug.Assert(!Convert.IsDBNull(cmd.Parameters[1].Value), "!Convert.IsDBNull(cmd.Parameters[1].Value)"); 551buf = (byte[]) cmd.Parameters[1].Value; 610cmd.Parameters[0].Value = id + _partitionInfo.AppSuffix; 611cmd.Parameters[1].Value = lockCookie; 692cmd.Parameters[0].Value = id + _partitionInfo.AppSuffix; 693cmd.Parameters[1].Size = length; 694cmd.Parameters[1].Value = buf; 695cmd.Parameters[2].Value = item.Timeout; 697cmd.Parameters[3].Value = lockCookie; 723cmd.Parameters[0].Value = id + _partitionInfo.AppSuffix; 724cmd.Parameters[1].Value = lockCookie; 744cmd.Parameters[0].Value = id + _partitionInfo.AppSuffix; 777cmd.Parameters[0].Value = id + _partitionInfo.AppSuffix; 778cmd.Parameters[1].Size = length; 779cmd.Parameters[1].Value = buf; 780cmd.Parameters[2].Value = timeout; 1031p = cmd.Parameters.Add(new SqlParameter("@@ver", SqlDbType.Int)); 1074p = cmdTempGetAppId.Parameters.Add(new SqlParameter("@appName", SqlDbType.VarChar, APPID_MAX)); 1077p = cmdTempGetAppId.Parameters.Add(new SqlParameter("@appId", SqlDbType.Int)); 1273foreach (SqlParameter param in cmd.Parameters) { 1289_cmdTempGet.Parameters.Add(new SqlParameter("@id", SqlDbType.NVarChar, ID_LENGTH)); 1290p = _cmdTempGet.Parameters.Add(new SqlParameter("@itemShort", SqlDbType.VarBinary, ITEM_SHORT_LENGTH)); 1292p = _cmdTempGet.Parameters.Add(new SqlParameter("@locked", SqlDbType.Bit)); 1294p = _cmdTempGet.Parameters.Add(new SqlParameter("@lockAge", SqlDbType.Int)); 1296p = _cmdTempGet.Parameters.Add(new SqlParameter("@lockCookie", SqlDbType.Int)); 1298p = _cmdTempGet.Parameters.Add(new SqlParameter("@actionFlags", SqlDbType.Int)); 1302_cmdTempGet.Parameters.Add(new SqlParameter("@id", SqlDbType.NVarChar, ID_LENGTH)); 1303p = _cmdTempGet.Parameters.Add(new SqlParameter("@itemShort", SqlDbType.VarBinary, ITEM_SHORT_LENGTH)); 1305p = _cmdTempGet.Parameters.Add(new SqlParameter("@locked", SqlDbType.Bit)); 1307p = _cmdTempGet.Parameters.Add(new SqlParameter("@lockDate", SqlDbType.DateTime)); 1309p = _cmdTempGet.Parameters.Add(new SqlParameter("@lockCookie", SqlDbType.Int)); 1311p = _cmdTempGet.Parameters.Add(new SqlParameter("@actionFlags", SqlDbType.Int)); 1331_cmdTempGetExclusive.Parameters.Add(new SqlParameter("@id", SqlDbType.NVarChar, ID_LENGTH)); 1332p = _cmdTempGetExclusive.Parameters.Add(new SqlParameter("@itemShort", SqlDbType.VarBinary, ITEM_SHORT_LENGTH)); 1334p = _cmdTempGetExclusive.Parameters.Add(new SqlParameter("@locked", SqlDbType.Bit)); 1336p = _cmdTempGetExclusive.Parameters.Add(new SqlParameter("@lockAge", SqlDbType.Int)); 1338p = _cmdTempGetExclusive.Parameters.Add(new SqlParameter("@lockCookie", SqlDbType.Int)); 1340p = _cmdTempGetExclusive.Parameters.Add(new SqlParameter("@actionFlags", SqlDbType.Int)); 1344_cmdTempGetExclusive.Parameters.Add(new SqlParameter("@id", SqlDbType.NVarChar, ID_LENGTH)); 1345p = _cmdTempGetExclusive.Parameters.Add(new SqlParameter("@itemShort", SqlDbType.VarBinary, ITEM_SHORT_LENGTH)); 1347p = _cmdTempGetExclusive.Parameters.Add(new SqlParameter("@locked", SqlDbType.Bit)); 1349p = _cmdTempGetExclusive.Parameters.Add(new SqlParameter("@lockDate", SqlDbType.DateTime)); 1351p = _cmdTempGetExclusive.Parameters.Add(new SqlParameter("@lockCookie", SqlDbType.Int)); 1353p = _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));

90SqlParameterCollection parameters = command.Parameters; 210SqlParameterCollection parameters = command.Parameters; 316SqlParameterCollection parameters = command.Parameters; 335parameter = command.Parameters[0]; 392SqlParameterCollection parameters = command.Parameters; 418parameter = command.Parameters[0]; 517command.Parameters.Add(CreateParameter("@ApplicationName", SqlDbType.NVarChar, this.ApplicationName)); 518command.Parameters.Add(CreateParameter("@Path", SqlDbType.NVarChar, path)); 520command.Parameters.Add(CreateParameter("@UserName", SqlDbType.NVarChar, userName)); 521command.Parameters.Add(CreateParameter("@CurrentTimeUtc", SqlDbType.DateTime, DateTime.UtcNow)); 593command.Parameters.Add(CreateParameter("@ApplicationName", SqlDbType.NVarChar, ApplicationName)); 594command.Parameters.Add(CreateParameter("@Path", SqlDbType.NVarChar, path)); 596command.Parameters.Add(CreateParameter("@UserName", SqlDbType.NVarChar, userName)); 597command.Parameters.Add(CreateParameter("@CurrentTimeUtc", SqlDbType.DateTime, DateTime.UtcNow)); 646SqlParameterCollection parameters = command.Parameters; 657parameter = command.Parameters[2]; 698SqlParameterCollection parameters = command.Parameters; 714SqlParameter countParam = command.Parameters[0]; 811SqlParameterCollection parameters = command.Parameters; 833SqlParameter countParam = command.Parameters[0]; 849SqlParameter countParam = command.Parameters[0]; 870SqlParameter countParam = command.Parameters[0]; 919command.Parameters.Add(CreateParameter("@ApplicationName", SqlDbType.NVarChar, ApplicationName)); 920command.Parameters.Add(CreateParameter("@Path", SqlDbType.NVarChar, path)); 921command.Parameters.Add(CreateParameter("@PageSettings", SqlDbType.Image, state)); 922command.Parameters.Add(CreateParameter("@CurrentTimeUtc", SqlDbType.DateTime, DateTime.UtcNow)); 924command.Parameters.Add(CreateParameter("@UserName", SqlDbType.NVarChar, userName));

273cmd.Parameters.Add(p); 276cmd.Parameters.Add(p); 280cmd.Parameters.Add(p);

176cmd.Parameters.Add(param); 192cmd.Parameters.Add(param); 205cmd.Parameters.Add(param); 215cmd.Parameters.Add(param); 224cmd.Parameters.Add(param); 229cmd.Parameters.Add(param); 279cmd.Parameters.Add(param);

553cmd.Parameters.Add(new SqlParameter("@WorkflowInstanceInternalId", _internalId)); 554cmd.Parameters.Add(new SqlParameter("@BeginDateTime", SqlDateTime.MinValue.Value)); 555cmd.Parameters.Add(new SqlParameter("@WorkflowInstanceEventId", kvp.Key)); 670cmd.Parameters.Add(new SqlParameter("@WorkflowInstanceInternalId", _internalId)); 767cmd.Parameters.Add(param); 771cmd.Parameters.Add(param); 775cmd.Parameters.Add(param); 859cmd.Parameters.Add(param); 863cmd.Parameters.Add(param); 867cmd.Parameters.Add(param);

630resultCode = (int)command.Parameters["@result"].Value; 771command.Parameters.Add(idParameter); 787command.Parameters.Add(instanceParameter); 788command.Parameters.Add(instanceXmlParameter); 792command.Parameters.Add(unlockInstanceParameter); 796command.Parameters.Add(lockOwnerParameter); 800command.Parameters.Add(lockTimeoutParameter); 804command.Parameters.Add(resultParameter); 848command.Parameters.Add(idParameter); 852command.Parameters.Add(hostIdParameter); 856command.Parameters.Add(lockTimeoutParameter); 860command.Parameters.Add(resultParameter); 950command.Parameters.Add(idParameter); 954command.Parameters.Add(lockInstanceParameter); 958command.Parameters.Add(hostIdParameter); 962command.Parameters.Add(lockTimeoutParameter); 966command.Parameters.Add(resultParameter); 1190int resultCode = (int)this.command.Parameters["@result"].Value; 1413command.Parameters.Add(idParameter); 1417command.Parameters.Add(hostIdParameter); 1421command.Parameters.Add(lockTimeoutParameter); 1425command.Parameters.Add(resultParameter); 1472command.Parameters.Add(idParameter); 1488command.Parameters.Add(instanceParameter); 1489command.Parameters.Add(instanceXmlParameter); 1493command.Parameters.Add(unlockInstanceParameter); 1497command.Parameters.Add(lockOwnerParameter); 1501command.Parameters.Add(lockTimeoutParameter); 1505command.Parameters.Add(resultParameter);