296 instantiations of SqlParameter
System.Activities.DurableInstancing (89)
System\Activities\DurableInstancing\CreateWorkflowOwnerAsyncResult.cs (12)
88parameters.Add(new SqlParameter { ParameterName = "@lockTimeout", SqlDbType = SqlDbType.Int, Value = lockTimeout }); 89parameters.Add(new SqlParameter { ParameterName = "@lockOwnerId", SqlDbType = SqlDbType.UniqueIdentifier, Value = this.lockOwnerId }); 90parameters.Add(new SqlParameter { ParameterName = "@workflowHostType", SqlDbType = SqlDbType.UniqueIdentifier, Value = (base.Store.WorkflowHostType != Guid.Empty) ? base.Store.WorkflowHostType : (object) DBNull.Value }); 91parameters.Add(new SqlParameter { ParameterName = "@enqueueCommand", SqlDbType = SqlDbType.Bit, Value = base.Store.EnqueueRunCommands }); 92parameters.Add(new SqlParameter { ParameterName = "@deleteInstanceOnCompletion", SqlDbType = SqlDbType.Bit, Value = (base.Store.InstanceCompletionAction == InstanceCompletionAction.DeleteAll) }); 93parameters.Add(new SqlParameter { ParameterName = "@primitiveLockOwnerData", SqlDbType = SqlDbType.VarBinary, Size = properties[0].Count, Value = (object)(properties[0].Array) ?? DBNull.Value }); 94parameters.Add(new SqlParameter { ParameterName = "@complexLockOwnerData", SqlDbType = SqlDbType.VarBinary, Size = properties[1].Count, Value = (object)(properties[1].Array) ?? DBNull.Value }); 95parameters.Add(new SqlParameter { ParameterName = "@writeOnlyPrimitiveLockOwnerData", SqlDbType = SqlDbType.VarBinary, Size = properties[2].Count, Value = (object)(properties[2].Array) ?? DBNull.Value }); 96parameters.Add(new SqlParameter { ParameterName = "@writeOnlyComplexLockOwnerData", SqlDbType = SqlDbType.VarBinary, Size = properties[3].Count, Value = (object)(properties[3].Array) ?? DBNull.Value }); 97parameters.Add(new SqlParameter { ParameterName = "@encodingOption", SqlDbType = SqlDbType.TinyInt, Value = base.Store.InstanceEncodingOption }); 98parameters.Add(new SqlParameter { ParameterName = "@machineName", SqlDbType = SqlDbType.NVarChar, Value = SqlWorkflowInstanceStoreConstants.MachineName }); 105parameters.Add(new SqlParameter { ParameterName = "@identityMetadata", SqlDbType = SqlDbType.Xml, Value = identityMetadataXml });
System\Activities\DurableInstancing\DeleteWorkflowOwnerAsyncResult.cs (1)
37sqlCommand.Parameters.Add(new SqlParameter { ParameterName = "@surrogateLockOwnerId", SqlDbType = SqlDbType.BigInt, Value = this.surrogateLockOwnerId });
System\Activities\DurableInstancing\DetectActivatableWorkflowsAsyncResult.cs (1)
46sqlCommand.Parameters.Add(new SqlParameter { ParameterName = "@machineName", SqlDbType = SqlDbType.NVarChar, Value = SqlWorkflowInstanceStoreConstants.MachineName });
System\Activities\DurableInstancing\DetectRunnableInstancesAsyncResult.cs (2)
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 });
System\Activities\DurableInstancing\ExtendLockAsyncResult.cs (2)
48sqlCommand.Parameters.Add(new SqlParameter { ParameterName = "@surrogateLockOwnerId", SqlDbType = SqlDbType.BigInt, Value = surrogateOwnerId }); 49sqlCommand.Parameters.Add(new SqlParameter { ParameterName = "@lockTimeout", SqlDbType = SqlDbType.Int, Value = lockTimeout });
System\Activities\DurableInstancing\LoadWorkflowAsyncResult.cs (11)
65parameters.Add(new SqlParameter { ParameterName = "@surrogateLockOwnerId", SqlDbType = SqlDbType.BigInt, Value = surrogateLockOwnerId }); 66parameters.Add(new SqlParameter { ParameterName = "@operationType", SqlDbType = SqlDbType.TinyInt, Value = loadType }); 67parameters.Add(new SqlParameter { ParameterName = "@keyToLoadBy", SqlDbType = SqlDbType.UniqueIdentifier, Value = keyToLoadBy }); 68parameters.Add(new SqlParameter { ParameterName = "@instanceId", SqlDbType = SqlDbType.UniqueIdentifier, Value = instanceId }); 69parameters.Add(new SqlParameter { ParameterName = "@handleInstanceVersion", SqlDbType = SqlDbType.BigInt, Value = base.InstancePersistenceContext.InstanceVersion }); 70parameters.Add(new SqlParameter { ParameterName = "@handleIsBoundToLock", SqlDbType = SqlDbType.Bit, Value = base.InstancePersistenceContext.InstanceView.IsBoundToLock }); 71parameters.Add(new SqlParameter { ParameterName = "@keysToAssociate", SqlDbType = SqlDbType.Xml, Value = singleKeyToAssociate ? DBNull.Value : SerializationUtilities.CreateCorrelationKeyXmlBlob(keysToAssociate) }); 72parameters.Add(new SqlParameter { ParameterName = "@encodingOption", SqlDbType = SqlDbType.TinyInt, Value = base.Store.InstanceEncodingOption }); 73parameters.Add(new SqlParameter { ParameterName = "@concatenatedKeyProperties", SqlDbType = SqlDbType.VarBinary, Value = (object) concatenatedKeyProperties ?? DBNull.Value }); 74parameters.Add(new SqlParameter { ParameterName = "@operationTimeout", SqlDbType = SqlDbType.Int, Value = (operationTimeout < Int32.MaxValue) ? Convert.ToInt32(operationTimeout) : Int32.MaxValue }); 75parameters.Add(new SqlParameter { ParameterName = "@singleKeyId", SqlDbType = SqlDbType.UniqueIdentifier, Value = singleKeyToAssociate ? keysToAssociate[0].KeyId : (object) DBNull.Value });
System\Activities\DurableInstancing\SaveWorkflowAsyncResult.cs (50)
74parameters.Add(new SqlParameter { ParameterName = "@instanceId", SqlDbType = SqlDbType.UniqueIdentifier, Value = base.InstancePersistenceContext.InstanceView.InstanceId }); 75parameters.Add(new SqlParameter { ParameterName = "@surrogateLockOwnerId", SqlDbType = SqlDbType.BigInt, Value = base.StoreLock.SurrogateLockOwnerId }); 76parameters.Add(new SqlParameter { ParameterName = "@handleInstanceVersion", SqlDbType = SqlDbType.BigInt, Value = base.InstancePersistenceContext.InstanceVersion }); 77parameters.Add(new SqlParameter { ParameterName = "@handleIsBoundToLock", SqlDbType = SqlDbType.Bit, Value = base.InstancePersistenceContext.InstanceView.IsBoundToLock }); 78parameters.Add(new SqlParameter { ParameterName = "@timerDurationMilliseconds", SqlDbType = SqlDbType.BigInt, Value = (object)GetPendingTimerExpiration(saveWorkflowCommand) ?? DBNull.Value }); 79parameters.Add(new SqlParameter { ParameterName = "@unlockInstance", SqlDbType = SqlDbType.Bit, Value = saveWorkflowCommand.UnlockInstance }); 80parameters.Add(new SqlParameter { ParameterName = "@suspensionStateChange", SqlDbType = SqlDbType.TinyInt, Value = GetSuspensionReason(saveWorkflowCommand, out suspensionReason, out suspensionExceptionName) }); 81parameters.Add(new SqlParameter { ParameterName = "@suspensionReason", SqlDbType = SqlDbType.NVarChar, Value = (object)suspensionReason ?? DBNull.Value }); 82parameters.Add(new SqlParameter { ParameterName = "@suspensionExceptionName", SqlDbType = SqlDbType.NVarChar, Size = 450, Value = (object)suspensionExceptionName ?? DBNull.Value }); 83parameters.Add(new SqlParameter { ParameterName = "@isCompleted", SqlDbType = SqlDbType.Bit, Value = saveWorkflowCommand.CompleteInstance }); 84parameters.Add(new SqlParameter { ParameterName = "@isReadyToRun", SqlDbType = SqlDbType.Bit, Value = IsReadyToRun(saveWorkflowCommand) }); 85parameters.Add(new SqlParameter { ParameterName = "@workflowHostType", SqlDbType = SqlDbType.UniqueIdentifier, Value = (object)GetWorkflowHostType(saveWorkflowCommand) ?? DBNull.Value }); 86parameters.Add(new SqlParameter { ParameterName = "@operationTimeout", SqlDbType = SqlDbType.Int, Value = (operationTimeout < Int32.MaxValue) ? Convert.ToInt32(operationTimeout) : Int32.MaxValue }); 92parameters.Add(new SqlParameter { ParameterName = "@identityMetadata", SqlDbType = SqlDbType.Xml, Value = (object)identityMetadataXml ?? DBNull.Value }); 194parameters.Add(new SqlParameter { ParameterName = parameterName, SqlDbType = SqlDbType.VarBinary, Size = parameterSize, Value = parameterValue }); 436parameters.Add(new SqlParameter { ParameterName = "@serviceDeploymentHash", SqlDbType = SqlDbType.UniqueIdentifier, Value = this.serviceDeploymentHash }); 437parameters.Add(new SqlParameter { ParameterName = "@serviceName", Size = -1, SqlDbType = SqlDbType.NVarChar, Value = serviceName ?? (object)DBNull.Value }); 438parameters.Add(new SqlParameter { ParameterName = "@serviceNamespace", Size = -1, SqlDbType = SqlDbType.NVarChar, Value = serviceNamespace ?? (object)DBNull.Value }); 439parameters.Add(new SqlParameter { ParameterName = "@siteName", Size = -1, SqlDbType = SqlDbType.NVarChar, Value = site ?? (object)DBNull.Value }); 440parameters.Add(new SqlParameter { ParameterName = "@relativeServicePath", Size = -1, SqlDbType = SqlDbType.NVarChar, Value = relativeServicePath ?? (object)DBNull.Value }); 441parameters.Add(new SqlParameter { ParameterName = "@relativeApplicationPath", Size = -1, SqlDbType = SqlDbType.NVarChar, Value = relativeApplicationPath ?? (object)DBNull.Value }); 445parameters.Add(new SqlParameter { ParameterName = "@serviceDeploymentId", SqlDbType = SqlDbType.BigInt, Value = (this.serviceDeploymentId != 0) ? (object)this.serviceDeploymentId : (object)DBNull.Value }); 479parameters.Add(new SqlParameter { ParameterName = "@keysToAssociate", SqlDbType = SqlDbType.Xml, Value = DBNull.Value }); 480parameters.Add(new SqlParameter { ParameterName = "@singleKeyId", SqlDbType = SqlDbType.UniqueIdentifier, Value = DBNull.Value }); 481parameters.Add(new SqlParameter { ParameterName = "@keysToComplete", SqlDbType = SqlDbType.Xml, Value = DBNull.Value }); 482parameters.Add(new SqlParameter { ParameterName = "@keysToFree", SqlDbType = SqlDbType.Xml, Value = DBNull.Value }); 483parameters.Add(new SqlParameter { ParameterName = "@concatenatedKeyProperties", SqlDbType = SqlDbType.VarBinary, Value = DBNull.Value }); 484parameters.Add(new SqlParameter { ParameterName = "@primitiveDataProperties", SqlDbType = SqlDbType.VarBinary, Value = DBNull.Value }); 485parameters.Add(new SqlParameter { ParameterName = "@complexDataProperties", SqlDbType = SqlDbType.VarBinary, Value = DBNull.Value }); 486parameters.Add(new SqlParameter { ParameterName = "@writeOnlyPrimitiveDataProperties", SqlDbType = SqlDbType.VarBinary, Value = DBNull.Value }); 487parameters.Add(new SqlParameter { ParameterName = "@writeOnlyComplexDataProperties", SqlDbType = SqlDbType.VarBinary, Value = DBNull.Value }); 488parameters.Add(new SqlParameter { ParameterName = "@metadataProperties", SqlDbType = SqlDbType.VarBinary, Value = DBNull.Value }); 489parameters.Add(new SqlParameter { ParameterName = "@metadataIsConsistent", SqlDbType = SqlDbType.Bit, Value = DBNull.Value }); 490parameters.Add(new SqlParameter { ParameterName = "@encodingOption", SqlDbType = SqlDbType.TinyInt, Value = DBNull.Value }); 491parameters.Add(new SqlParameter { ParameterName = "@lastMachineRunOn", SqlDbType = SqlDbType.NVarChar, Value = DBNull.Value }); 492parameters.Add(new SqlParameter { ParameterName = "@executionStatus", SqlDbType = SqlDbType.NVarChar, Value = DBNull.Value }); 493parameters.Add(new SqlParameter { ParameterName = "@blockingBookmarks", SqlDbType = SqlDbType.NVarChar, Value = DBNull.Value }); 507parameters.Add(new SqlParameter { ParameterName = "@keysToAssociate", SqlDbType = SqlDbType.Xml, Value = singleKeyToAssociate ? DBNull.Value : SerializationUtilities.CreateCorrelationKeyXmlBlob(keysToAssociate) }); 508parameters.Add(new SqlParameter { ParameterName = "@singleKeyId", SqlDbType = SqlDbType.UniqueIdentifier, Value = singleKeyToAssociate ? keysToAssociate[0].KeyId : (object)DBNull.Value }); 509parameters.Add(new SqlParameter { ParameterName = "@keysToComplete", SqlDbType = SqlDbType.Xml, Value = SerializationUtilities.CreateCorrelationKeyXmlBlob(keysToComplete) }); 510parameters.Add(new SqlParameter { ParameterName = "@keysToFree", SqlDbType = SqlDbType.Xml, Value = SerializationUtilities.CreateCorrelationKeyXmlBlob(keysToFree) }); 511parameters.Add(new SqlParameter { ParameterName = "@concatenatedKeyProperties", SqlDbType = SqlDbType.VarBinary, Size = -1, Value = (object)concatenatedKeyProperties ?? DBNull.Value }); 512parameters.Add(new SqlParameter { ParameterName = "@metadataIsConsistent", SqlDbType = SqlDbType.Bit, Value = metadataConsistency }); 513parameters.Add(new SqlParameter { ParameterName = "@encodingOption", SqlDbType = SqlDbType.TinyInt, Value = base.Store.InstanceEncodingOption }); 514parameters.Add(new SqlParameter { ParameterName = "@lastMachineRunOn", SqlDbType = SqlDbType.NVarChar, Size = 450, Value = SqlWorkflowInstanceStoreConstants.MachineName }); 515parameters.Add(new SqlParameter { ParameterName = "@executionStatus", SqlDbType = SqlDbType.NVarChar, Size = 450, Value = GetExecutionStatus(saveWorkflowCommand) ?? (object)DBNull.Value }); 516parameters.Add(new SqlParameter { ParameterName = "@blockingBookmarks", SqlDbType = SqlDbType.NVarChar, Size = -1, Value = GetBlockingBookmarks(saveWorkflowCommand) ?? (object)DBNull.Value }); 564parameters.Add(new SqlParameter() { SqlDbType = SqlDbType.Variant, ParameterName = argumentName, Value = propertyValue.Value ?? DBNull.Value }); 597parameters.Add(new SqlParameter() { SqlDbType = SqlDbType.NVarChar, Size = 400, ParameterName = promotionNameArgument, Value = promotion.Key }); 598parameters.Add(new SqlParameter() { SqlDbType = SqlDbType.UniqueIdentifier, ParameterName = instanceIdArgument, Value = base.InstancePersistenceContext.InstanceView.InstanceId });
System\Activities\DurableInstancing\TryLoadRunnableWorkflowAsyncResult.cs (7)
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 });
System\Activities\DurableInstancing\UnlockInstanceAsyncResult.cs (3)
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 });
System.Data (37)
fx\src\data\System\Data\SqlClient\SqlClientFactory.cs (1)
52return new SqlParameter();
fx\src\data\System\Data\SqlClient\SqlCommand.cs (20)
1103return new SqlParameter(); 2796paramsCmd.Parameters.Add(new SqlParameter("@procedure_name", SqlDbType.NVarChar, 255)); 2800SqlParameter param = paramsCmd.Parameters.Add(new SqlParameter("@group_number", SqlDbType.Int)); 2805SqlParameter param = paramsCmd.Parameters.Add(new SqlParameter("@procedure_schema", SqlDbType.NVarChar, 255)); 2822p = new SqlParameter(); 3696SqlParameter sqlParam = new SqlParameter(null, ((queryText.Length << 1) <= TdsEnums.TYPE_SIZE_LIMIT) ? SqlDbType.NVarChar : SqlDbType.NText, queryText.Length); 3762paramCopy = new SqlParameter(param.ParameterName, param.SqlDbType, param.Size, param.Direction, param.Precision, param.Scale, param.SourceColumn, param.SourceVersion, 3790sqlParam = new SqlParameter(null, ((parameterList.Length << 1) <= TdsEnums.TYPE_SIZE_LIMIT) ? SqlDbType.NVarChar : SqlDbType.NText, parameterList.Length); 3795var attestationParametersParam = new SqlParameter(null, SqlDbType.VarBinary) { 5484sqlParam = new SqlParameter(null, SqlDbType.Int); 5492sqlParam = new SqlParameter(null, ((paramList.Length<<1)<=TdsEnums.TYPE_SIZE_LIMIT)?SqlDbType.NVarChar:SqlDbType.NText, paramList.Length); 5498sqlParam = new SqlParameter(null, ((text.Length<<1)<=TdsEnums.TYPE_SIZE_LIMIT)?SqlDbType.NVarChar:SqlDbType.NText, text.Length); 5576sqlParam = new SqlParameter(null, SqlDbType.Int); 5604sqlParam = new SqlParameter(null, SqlDbType.Int); 5640sqlParam = new SqlParameter(null, ((commandText.Length<<1)<=TdsEnums.TYPE_SIZE_LIMIT)?SqlDbType.NVarChar:SqlDbType.NText, commandText.Length); 5646sqlParam = new SqlParameter(null, ((paramList.Length<<1)<=TdsEnums.TYPE_SIZE_LIMIT)?SqlDbType.NVarChar:SqlDbType.NText, paramList.Length); 5732SqlParameter tsqlParameter = new SqlParameter(null, ((execStatement.Length << 1) <= TdsEnums.TYPE_SIZE_LIMIT) ? SqlDbType.NVarChar : SqlDbType.NText, execStatement.Length); 5961sqlParam = new SqlParameter(null, SqlDbType.Int); 5968sqlParam = new SqlParameter(null, ((paramList.Length<<1)<=TdsEnums.TYPE_SIZE_LIMIT)?SqlDbType.NVarChar:SqlDbType.NText, paramList.Length); 5974sqlParam = new SqlParameter(null, ((text.Length<<1)<=TdsEnums.TYPE_SIZE_LIMIT)?SqlDbType.NVarChar:SqlDbType.NText, text.Length);
fx\src\data\System\Data\SqlClient\SqlCommandSet.cs (1)
143SqlParameter p = new SqlParameter();
fx\src\data\System\Data\SqlClient\SqlConnection.cs (6)
1992SqlParameter p = new SqlParameter(null, SqlDbType.VarChar, TdsEnums.SQLDEBUG_MODE_NAMES[option].Length); 1998p = new SqlParameter(null, SqlDbType.VarChar, sdiDllName.Length); 2002p = new SqlParameter(null, SqlDbType.VarChar, machineName.Length); 2009p = new SqlParameter(null, SqlDbType.Int); 2013p = new SqlParameter(null, SqlDbType.Int); 2020p = new SqlParameter(null, SqlDbType.VarBinary, (null != data) ? data.Length : 0);
fx\src\data\System\Data\SqlClient\SqlDependencyListener.cs (3)
152_conversationGuidParam = new SqlParameter("@p1", SqlDbType.UniqueIdentifier); 153_timeoutParam = new SqlParameter("@p2", SqlDbType.Int); 435SqlParameter param = new SqlParameter();
fx\src\data\System\Data\SqlClient\sqlinternaltransaction.cs (1)
338SqlParameter parameter = new SqlParameter("@out", SqlDbType.Int);
fx\src\data\System\Data\SqlClient\SqlParameterCollection.cs (5)
75return Add(new SqlParameter(parameterName, value)); 78return Add(new SqlParameter(parameterName, value)); 82return Add(new SqlParameter(parameterName, sqlDbType)); 86return Add(new SqlParameter(parameterName, sqlDbType, size)); 90return Add(new SqlParameter(parameterName, sqlDbType, size, sourceColumn));
System.Data.Entity (1)
System\Data\SqlClient\SqlProviderServices.cs (1)
329SqlParameter result = new SqlParameter(name, value);
System.Web (121)
Cache\SqlCacheDependency.cs (1)
1501sqlCmd.Parameters.Add(new SqlParameter("@tableName", SqlDbType.NVarChar, table.Length));
Management\SqlServices.cs (2)
559cmd.Parameters.Add(new SqlParameter("@database", databaseNoSquareBrackets)); 610cmd.Parameters.Add(new SqlParameter("@TablesToCheck", itablesToCheck));
Management\SqlWebEventProvider.cs (15)
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));
Profile\SqlProfileProvider.cs (1)
258SqlParameter param = new SqlParameter(paramName, dbType);
Security\SQLMembershipProvider.cs (18)
380p = new SqlParameter("@ReturnValue", SqlDbType.Int); 473SqlParameter p = new SqlParameter("@ReturnValue", SqlDbType.Int); 632SqlParameter p = new SqlParameter("@ReturnValue", SqlDbType.Int); 757SqlParameter p = new SqlParameter("@ReturnValue", SqlDbType.Int); 835SqlParameter p = new SqlParameter("@ReturnValue", SqlDbType.Int); 893SqlParameter p = new SqlParameter("@ReturnValue", SqlDbType.Int); 945SqlParameter p = new SqlParameter("@ReturnValue", SqlDbType.Int); 1034SqlParameter p = new SqlParameter("@ReturnValue", SqlDbType.Int); 1124SqlParameter p = new SqlParameter("@ReturnValue", SqlDbType.Int); 1187SqlParameter p = new SqlParameter("@NumTablesDeletedFrom", SqlDbType.Int); 1236SqlParameter p = new SqlParameter("@ReturnValue", SqlDbType.Int); 1318SqlParameter p = new SqlParameter("@ReturnValue", SqlDbType.Int); 1365SqlParameter p = new SqlParameter("@ReturnValue", SqlDbType.Int); 1463SqlParameter p = new SqlParameter("@ReturnValue", SqlDbType.Int); 1594SqlParameter p = new SqlParameter("@ReturnValue", SqlDbType.Int); 1651p = new SqlParameter( "@ReturnValue", SqlDbType.Int ); 1737p = new SqlParameter( "@ReturnValue", SqlDbType.Int ); 1823SqlParameter param = new SqlParameter( paramName, dbType );
Security\SQLRoleProvider.cs (11)
118SqlParameter p = new SqlParameter("@ReturnValue", SqlDbType.Int); 173SqlParameter p = new SqlParameter("@ReturnValue", SqlDbType.Int); 248SqlParameter p = new SqlParameter("@ReturnValue", SqlDbType.Int); 302SqlParameter p = new SqlParameter("@ReturnValue", SqlDbType.Int); 353SqlParameter p = new SqlParameter("@ReturnValue", SqlDbType.Int); 463SqlParameter p = new SqlParameter("@ReturnValue", SqlDbType.Int); 575SqlParameter p = new SqlParameter("@ReturnValue", SqlDbType.Int); 630SqlParameter p = new SqlParameter("@ReturnValue", SqlDbType.Int); 699SqlParameter p = new SqlParameter("@ReturnValue", SqlDbType.Int); 759SqlParameter p = new SqlParameter("@ReturnValue", SqlDbType.Int); 837SqlParameter param = new SqlParameter(paramName, dbType);
State\sqlstateclientmanager.cs (57)
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)); 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));
UI\WebParts\SqlPersonalizationProvider.cs (13)
64SqlParameter param = new SqlParameter(name, dbType); 92SqlParameter parameter = parameters.Add(new SqlParameter("AllUsersScope", SqlDbType.Bit)); 99SqlParameter returnValue = new SqlParameter("@ReturnValue", SqlDbType.Int); 212SqlParameter parameter = parameters.Add(new SqlParameter("AllUsersScope", SqlDbType.Bit)); 219SqlParameter returnValue = new SqlParameter("@ReturnValue", SqlDbType.Int); 318SqlParameter parameter = parameters.Add(new SqlParameter("Count", SqlDbType.Int)); 321parameter = parameters.Add(new SqlParameter("AllUsersScope", SqlDbType.Bit)); 394SqlParameter parameter = parameters.Add(new SqlParameter("Count", SqlDbType.Int)); 397parameter = parameters.Add(new SqlParameter("AllUsersScope", SqlDbType.Bit)); 648SqlParameter parameter = parameters.Add(new SqlParameter("AllUsersScope", SqlDbType.Bit)); 653parameter = parameters.Add(new SqlParameter("Count", SqlDbType.Int)); 700SqlParameter parameter = parameters.Add(new SqlParameter("Count", SqlDbType.Int)); 813SqlParameter parameter = parameters.Add(new SqlParameter("Count", SqlDbType.Int));
Util\SecUtil.cs (3)
272p = new SqlParameter("@Feature", feature); 275p = new SqlParameter("@CompatibleSchemaVersion", version); 278p = new SqlParameter("@ReturnValue", SqlDbType.Int);
System.Web.Extensions (1)
ClientServices\Providers\SqlHelper.cs (1)
73cmd.Parameters.Add(new SqlParameter(paramName, paramValue));
System.Workflow.Runtime (20)
Hosting\DbResourceAllocator.cs (3)
249return new SqlParameter(parameterName, SqlDbType.BigInt); 251return new SqlParameter(parameterName, type); 274return new SqlParameter(parameterName, value);
Tracking\SqlTrackingQuery.cs (7)
172SqlParameter param = new SqlParameter(); 186SqlParameter param = new SqlParameter(); 197param = new SqlParameter(); 207param = new SqlParameter(); 221param = new SqlParameter("@TypeFullName", opt.WorkflowType.FullName); 226param = new SqlParameter("@AssemblyFullName", opt.WorkflowType.Assembly.FullName); 274SqlParameter param = new SqlParameter();
Tracking\SqlTrackingWorkflowInstance.cs (10)
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)); 765SqlParameter param = new SqlParameter("@WorkflowInstanceId", SqlDbType.UniqueIdentifier); 769param = new SqlParameter("@BeginDateTime", SqlDbType.DateTime); 773param = new SqlParameter("@EndDateTime", SqlDbType.DateTime); 857SqlParameter param = new SqlParameter("@WorkflowInstanceInternalId", SqlDbType.BigInt); 861param = new SqlParameter("@BeginDateTime", SqlDbType.DateTime); 865param = new SqlParameter("@EndDateTime", SqlDbType.DateTime);
System.WorkflowServices (27)
System\ServiceModel\Persistence\SqlPersistenceProviderFactory.cs (27)
769SqlParameter idParameter = new SqlParameter("@id", SqlDbType.UniqueIdentifier); 773SqlParameter instanceParameter = new SqlParameter("@instance", SqlDbType.Image); 774SqlParameter instanceXmlParameter = new SqlParameter("@instanceXml", SqlDbType.Xml); 790SqlParameter unlockInstanceParameter = new SqlParameter("@unlockInstance", SqlDbType.Bit); 794SqlParameter lockOwnerParameter = new SqlParameter("@hostId", SqlDbType.UniqueIdentifier); 798SqlParameter lockTimeoutParameter = new SqlParameter("@lockTimeout", SqlDbType.Int); 802SqlParameter resultParameter = new SqlParameter("@result", SqlDbType.Int); 846SqlParameter idParameter = new SqlParameter("@id", SqlDbType.UniqueIdentifier); 850SqlParameter hostIdParameter = new SqlParameter("@hostId", SqlDbType.UniqueIdentifier); 854SqlParameter lockTimeoutParameter = new SqlParameter("@lockTimeout", SqlDbType.Int); 858SqlParameter resultParameter = new SqlParameter("@result", SqlDbType.Int); 948SqlParameter idParameter = new SqlParameter("@id", SqlDbType.UniqueIdentifier); 952SqlParameter lockInstanceParameter = new SqlParameter("@lockInstance", SqlDbType.Bit); 956SqlParameter hostIdParameter = new SqlParameter("@hostId", SqlDbType.UniqueIdentifier); 960SqlParameter lockTimeoutParameter = new SqlParameter("@lockTimeout", SqlDbType.Int); 964SqlParameter resultParameter = new SqlParameter("@result", SqlDbType.Int); 1411SqlParameter idParameter = new SqlParameter("@id", SqlDbType.UniqueIdentifier); 1415SqlParameter hostIdParameter = new SqlParameter("@hostId", SqlDbType.UniqueIdentifier); 1419SqlParameter lockTimeoutParameter = new SqlParameter("@lockTimeout", SqlDbType.Int); 1423SqlParameter resultParameter = new SqlParameter("@result", SqlDbType.Int); 1470SqlParameter idParameter = new SqlParameter("@id", SqlDbType.UniqueIdentifier); 1474SqlParameter instanceParameter = new SqlParameter("@instance", SqlDbType.Image); 1475SqlParameter instanceXmlParameter = new SqlParameter("@instanceXml", SqlDbType.Xml); 1491SqlParameter unlockInstanceParameter = new SqlParameter("@unlockInstance", SqlDbType.Bit); 1495SqlParameter lockOwnerParameter = new SqlParameter("@hostId", SqlDbType.UniqueIdentifier); 1499SqlParameter lockTimeoutParameter = new SqlParameter("@lockTimeout", SqlDbType.Int); 1503SqlParameter resultParameter = new SqlParameter("@result", SqlDbType.Int);
205 references to SqlParameter
System.Activities.DurableInstancing (3)
System\Activities\DurableInstancing\SqlCommandAsyncResult.cs (2)
237SqlParameter[] tempParameterList = new SqlParameter[command.Parameters.Count];
System\Activities\DurableInstancing\StoreUtilities.cs (1)
146foreach (SqlParameter sqlParameter in command.Parameters)
System.Data (80)
fx\src\data\Microsoft\SqlServer\Server\MetadataUtilsSmi.cs (1)
529String[] names = SqlParameter.ParseTypeName(typeName, true /* is for UdtTypeName */);
fx\src\data\System\Data\SqlClient\SqlBulkCopy.cs (3)
1337value = SqlParameter.CoerceValue(value, mt, out coercedToDataFeed, out typeChanged, false); 1402value = SqlParameter.CoerceValue(value, mt, out coercedToDataFeed, out typeChanged, false); 1408value = SqlParameter.CoerceValue(value, mt, out coercedToDataFeed, out typeChanged, false);
fx\src\data\System\Data\SqlClient\SqlCommand.cs (37)
1102new public SqlParameter CreateParameter() { 2800SqlParameter param = paramsCmd.Parameters.Add(new SqlParameter("@group_number", SqlDbType.Int)); 2805SqlParameter param = paramsCmd.Parameters.Add(new SqlParameter("@procedure_schema", SqlDbType.NVarChar, 255)); 2811List<SqlParameter> parameters = new List<SqlParameter>(); 2817SqlParameter p = null; 2958foreach (SqlParameter temp in parameters) { 3651foreach (SqlParameter sqlParam in _parameters) { 3694private SqlParameter GetSqlParameterWithQueryText(string queryText) 3696SqlParameter sqlParam = new SqlParameter(null, ((queryText.Length << 1) <= TdsEnums.TYPE_SIZE_LIMIT) ? SqlDbType.NVarChar : SqlDbType.NText, queryText.Length); 3719SqlParameter sqlParam; 3756SqlParameter paramCopy; 3761SqlParameter param = originalRpcRequest.parameters[i]; 3795var attestationParametersParam = new SqlParameter(null, SqlDbType.VarBinary) { 3986SqlParameter sqlParameter = rpc.parameters[paramIdx]; 5111SqlParameter parameter = parameters[i]; 5157SqlParameter thisParam = GetParameterForOutputValueExtraction(parameters, rec.parameter, count); 5291SqlParameter param = GetParameterForOutputValueExtraction(parameters, name, count); 5331private SqlParameter GetParameterForOutputValueExtraction( SqlParameterCollection parameters, 5333SqlParameter thisParam = null; 5402rpc.parameters = new SqlParameter[paramCount]; 5424SqlParameter parameter = parameters[ii]; 5472SqlParameter sqlParam; 5511private static bool ShouldSendParameter(SqlParameter p, bool includeReturnValue = false) { 5570SqlParameter sqlParam; 5598SqlParameter sqlParam; 5622SqlParameter sqlParam; 5663private SqlParameter BuildStoredProcedureStatementForColumnEncryption(string storedProcedureName, SqlParameter[] parameters) { 5672SqlParameter returnValueParameter = null; 5673foreach (SqlParameter parameter in parameters) { 5732SqlParameter tsqlParameter = new SqlParameter(null, ((execStatement.Length << 1) <= TdsEnums.TYPE_SIZE_LIMIT) ? SqlDbType.NVarChar : SqlDbType.NText, execStatement.Length); 5749SqlParameter sqlParam = parameters[i]; 5876string[] strings = SqlParameter.ParseTypeName(identifier, isUdtTypeName); 5955SqlParameter sqlParam; 6218SqlParameter param = Parameters[index]; 6249SqlParameter param = Parameters[index];
fx\src\data\System\Data\SqlClient\SqlCommandBuilder.cs (2)
161SqlParameter p = (SqlParameter) parameter;
fx\src\data\System\Data\SqlClient\SqlCommandSet.cs (3)
143SqlParameter p = new SqlParameter(); 153foreach(SqlParameter p in parameters) { 274internal SqlParameter GetParameter(int commandIndex, int parameterIndex) {
fx\src\data\System\Data\SqlClient\SqlConnection.cs (1)
1992SqlParameter p = new SqlParameter(null, SqlDbType.VarChar, TdsEnums.SQLDEBUG_MODE_NAMES[option].Length);
fx\src\data\System\Data\SqlClient\SqlDependencyListener.cs (3)
47private SqlParameter _conversationGuidParam; 48private SqlParameter _timeoutParam; 435SqlParameter param = new SqlParameter();
fx\src\data\System\Data\SqlClient\sqlinternaltransaction.cs (1)
338SqlParameter parameter = new SqlParameter("@out", SqlDbType.Int);
fx\src\data\System\Data\SqlClient\SqlParameter.cs (6)
58System.ComponentModel.TypeConverterAttribute(typeof(System.Data.SqlClient.SqlParameter.SqlParameterConverter)) 1043private void CloneHelper(SqlParameter destination) { 1774if ((typeof(System.ComponentModel.Design.Serialization.InstanceDescriptor) == destinationType) && (value is SqlParameter)) { 1775return ConvertToInstanceDescriptor(value as SqlParameter); 1780private System.ComponentModel.Design.Serialization.InstanceDescriptor ConvertToInstanceDescriptor(SqlParameter p) { 1863System.Reflection.ConstructorInfo ctor = typeof(SqlParameter).GetConstructor(ctorParams);
fx\src\data\System\Data\SqlClient\SqlParameterCollection.cs (18)
27private static Type ItemType = typeof(SqlParameter); 45new public SqlParameter this[int index] { 47return (SqlParameter)GetParameter(index); 58new public SqlParameter this[string parameterName] { 60return (SqlParameter)GetParameter(parameterName); 67public SqlParameter Add(SqlParameter value) { 74public SqlParameter Add(string parameterName, object value) { 77public SqlParameter AddWithValue(string parameterName, object value) { // 79027 81public SqlParameter Add(string parameterName, SqlDbType sqlDbType) { 85public SqlParameter Add(string parameterName, SqlDbType sqlDbType, int size) { 89public SqlParameter Add(string parameterName, SqlDbType sqlDbType, int size, string sourceColumn) { 93public void AddRange(SqlParameter[] values) { 101public bool Contains(SqlParameter value) { 105public void CopyTo(SqlParameter[] array, int index) { 109public int IndexOf(SqlParameter value) { 113public void Insert(int index, SqlParameter value) { 121public void Remove(SqlParameter value) {
fx\src\data\System\Data\SqlClient\TdsParser.cs (4)
8126SqlParameter[] parameters = rpcext.parameters; 8131SqlParameter param = parameters[i]; 8398String[] names = SqlParameter.ParseTypeName(param.UdtTypeName, true /* is UdtTypeName */); 8759private void WriteSmiParameter(SqlParameter param, int paramIndex, bool sendDefault, TdsParserStateObject stateObj) {
fx\src\data\System\Data\SqlClient\TdsParserHelperClasses.cs (1)
1044internal SqlParameter[] parameters;
System.Data.Entity (20)
System\Data\SqlClient\SqlGen\DmlSqlGenerator.cs (13)
33internal static string GenerateUpdateSql(DbUpdateCommandTree tree, SqlVersion sqlVersion, out List<SqlParameter> parameters) 90internal static string GenerateDeleteSql(DbDeleteCommandTree tree, SqlVersion sqlVersion, out List<SqlParameter> parameters) 108internal static string GenerateInsertSql(DbInsertCommandTree tree, SqlVersion sqlVersion, out List<SqlParameter> parameters) 387SqlParameter value; 470_parameters = new List<SqlParameter>(); 471_memberValues = preserveMemberValues ? new Dictionary<EdmMember, SqlParameter>() : 477private readonly List<SqlParameter> _parameters; 478private readonly Dictionary<EdmMember, SqlParameter> _memberValues; 482internal List<SqlParameter> Parameters { get { return _parameters; } } 483internal Dictionary<EdmMember, SqlParameter> MemberValues { get { return _memberValues; } } 487internal SqlParameter CreateParameter(object value, TypeUsage type) 492SqlParameter parameter = SqlProviderServices.CreateSqlParameter(s_parameterNames.GetName(_parameters.Count), type, ParameterMode.In, value, preventTruncation, _version); 563SqlParameter parameter = CreateParameter(expression.Value, expression.ResultType);
System\Data\SqlClient\SqlGen\SqlGenerator.cs (1)
408internal static string GenerateSql(DbCommandTree tree, SqlVersion sqlVersion, out List<SqlParameter> parameters, out CommandType commandType, out HashSet<string> paramsToForceNonUnicode)
System\Data\SqlClient\SqlProviderServices.cs (6)
98List<SqlParameter> parameters; 111SqlParameter parameter; 145foreach (SqlParameter parameter in parameters) { 190int suggestedLength = GetNonMaxLength(((SqlParameter)parameter).SqlDbType); 321internal static SqlParameter CreateSqlParameter(string name, TypeUsage type, ParameterMode mode, object value, bool preventTruncation, SqlVersion version) { 329SqlParameter result = new SqlParameter(name, value);
System.Data.Linq (4)
SqlClient\SqlProvider.cs (2)
1166var sp = p as System.Data.SqlClient.SqlParameter;
SqlClient\SqlTypeSystemProvider.cs (2)
976System.Data.SqlClient.SqlParameter sParameter = parameter as System.Data.SqlClient.SqlParameter;
System.Web (66)
Profile\SqlProfileProvider.cs (11)
257private SqlParameter CreateInputParam(string paramName, SqlDbType dbType, object objValue){ 258SqlParameter param = new SqlParameter(paramName, dbType); 448return GetProfilesForQuery(new SqlParameter[0], authenticationOption, pageIndex, pageSize, out totalRecords); 456SqlParameter [] args = new SqlParameter[1]; 465SqlParameter[] args = new SqlParameter[1]; 475SqlParameter[] args = new SqlParameter[2]; 487private ProfileInfoCollection GetProfilesForQuery(SqlParameter [] args, ProfileAuthenticationOption authenticationOption, int pageIndex, int pageSize, out int totalRecords) 515foreach (SqlParameter arg in args)
Security\SQLMembershipProvider.cs (19)
376SqlParameter p = CreateInputParam("@UserId", SqlDbType.UniqueIdentifier, providerUserKey); 473SqlParameter p = new SqlParameter("@ReturnValue", SqlDbType.Int); 632SqlParameter p = new SqlParameter("@ReturnValue", SqlDbType.Int); 757SqlParameter p = new SqlParameter("@ReturnValue", SqlDbType.Int); 835SqlParameter p = new SqlParameter("@ReturnValue", SqlDbType.Int); 893SqlParameter p = new SqlParameter("@ReturnValue", SqlDbType.Int); 945SqlParameter p = new SqlParameter("@ReturnValue", SqlDbType.Int); 1034SqlParameter p = new SqlParameter("@ReturnValue", SqlDbType.Int); 1124SqlParameter p = new SqlParameter("@ReturnValue", SqlDbType.Int); 1187SqlParameter p = new SqlParameter("@NumTablesDeletedFrom", SqlDbType.Int); 1236SqlParameter p = new SqlParameter("@ReturnValue", SqlDbType.Int); 1318SqlParameter p = new SqlParameter("@ReturnValue", SqlDbType.Int); 1365SqlParameter p = new SqlParameter("@ReturnValue", SqlDbType.Int); 1463SqlParameter p = new SqlParameter("@ReturnValue", SqlDbType.Int); 1594SqlParameter p = new SqlParameter("@ReturnValue", SqlDbType.Int); 1636SqlParameter p = null; 1716SqlParameter p = null; 1818private SqlParameter CreateInputParam( string paramName, 1823SqlParameter param = new SqlParameter( paramName, dbType );
Security\SQLRoleProvider.cs (13)
118SqlParameter p = new SqlParameter("@ReturnValue", SqlDbType.Int); 173SqlParameter p = new SqlParameter("@ReturnValue", SqlDbType.Int); 248SqlParameter p = new SqlParameter("@ReturnValue", SqlDbType.Int); 302SqlParameter p = new SqlParameter("@ReturnValue", SqlDbType.Int); 353SqlParameter p = new SqlParameter("@ReturnValue", SqlDbType.Int); 463SqlParameter p = new SqlParameter("@ReturnValue", SqlDbType.Int); 575SqlParameter p = new SqlParameter("@ReturnValue", SqlDbType.Int); 630SqlParameter p = new SqlParameter("@ReturnValue", SqlDbType.Int); 699SqlParameter p = new SqlParameter("@ReturnValue", SqlDbType.Int); 759SqlParameter p = new SqlParameter("@ReturnValue", SqlDbType.Int); 836private SqlParameter CreateInputParam(string paramName, SqlDbType dbType, object objValue){ 837SqlParameter param = new SqlParameter(paramName, dbType); 848foreach(SqlParameter param in cmd.Parameters){
State\sqlstateclientmanager.cs (5)
1000SqlParameter p; 1066SqlParameter p; 1273foreach (SqlParameter param in cmd.Parameters) { 1281SqlParameter p; 1323SqlParameter p;
UI\WebControls\SqlDataSourceView.cs (2)
1213SqlParameter sqlParameter = dbParameter as SqlParameter;
UI\WebParts\SqlPersonalizationProvider.cs (15)
63private SqlParameter CreateParameter(string name, SqlDbType dbType, object value) { 64SqlParameter param = new SqlParameter(name, dbType); 92SqlParameter parameter = parameters.Add(new SqlParameter("AllUsersScope", SqlDbType.Bit)); 99SqlParameter returnValue = new SqlParameter("@ReturnValue", SqlDbType.Int); 212SqlParameter parameter = parameters.Add(new SqlParameter("AllUsersScope", SqlDbType.Bit)); 219SqlParameter returnValue = new SqlParameter("@ReturnValue", SqlDbType.Int); 318SqlParameter parameter = parameters.Add(new SqlParameter("Count", SqlDbType.Int)); 394SqlParameter parameter = parameters.Add(new SqlParameter("Count", SqlDbType.Int)); 648SqlParameter parameter = parameters.Add(new SqlParameter("AllUsersScope", SqlDbType.Bit)); 700SqlParameter parameter = parameters.Add(new SqlParameter("Count", SqlDbType.Int)); 714SqlParameter countParam = command.Parameters[0]; 813SqlParameter parameter = parameters.Add(new SqlParameter("Count", SqlDbType.Int)); 833SqlParameter countParam = command.Parameters[0]; 849SqlParameter countParam = command.Parameters[0]; 870SqlParameter countParam = command.Parameters[0];
Util\SecUtil.cs (1)
265SqlParameter p = null;
System.Workflow.Runtime (5)
Tracking\SqlTrackingQuery.cs (3)
172SqlParameter param = new SqlParameter(); 186SqlParameter param = new SqlParameter(); 274SqlParameter param = new SqlParameter();
Tracking\SqlTrackingWorkflowInstance.cs (2)
765SqlParameter param = new SqlParameter("@WorkflowInstanceId", SqlDbType.UniqueIdentifier); 857SqlParameter param = new SqlParameter("@WorkflowInstanceInternalId", SqlDbType.BigInt);
System.WorkflowServices (27)
System\ServiceModel\Persistence\SqlPersistenceProviderFactory.cs (27)
769SqlParameter idParameter = new SqlParameter("@id", SqlDbType.UniqueIdentifier); 773SqlParameter instanceParameter = new SqlParameter("@instance", SqlDbType.Image); 774SqlParameter instanceXmlParameter = new SqlParameter("@instanceXml", SqlDbType.Xml); 790SqlParameter unlockInstanceParameter = new SqlParameter("@unlockInstance", SqlDbType.Bit); 794SqlParameter lockOwnerParameter = new SqlParameter("@hostId", SqlDbType.UniqueIdentifier); 798SqlParameter lockTimeoutParameter = new SqlParameter("@lockTimeout", SqlDbType.Int); 802SqlParameter resultParameter = new SqlParameter("@result", SqlDbType.Int); 846SqlParameter idParameter = new SqlParameter("@id", SqlDbType.UniqueIdentifier); 850SqlParameter hostIdParameter = new SqlParameter("@hostId", SqlDbType.UniqueIdentifier); 854SqlParameter lockTimeoutParameter = new SqlParameter("@lockTimeout", SqlDbType.Int); 858SqlParameter resultParameter = new SqlParameter("@result", SqlDbType.Int); 948SqlParameter idParameter = new SqlParameter("@id", SqlDbType.UniqueIdentifier); 952SqlParameter lockInstanceParameter = new SqlParameter("@lockInstance", SqlDbType.Bit); 956SqlParameter hostIdParameter = new SqlParameter("@hostId", SqlDbType.UniqueIdentifier); 960SqlParameter lockTimeoutParameter = new SqlParameter("@lockTimeout", SqlDbType.Int); 964SqlParameter resultParameter = new SqlParameter("@result", SqlDbType.Int); 1411SqlParameter idParameter = new SqlParameter("@id", SqlDbType.UniqueIdentifier); 1415SqlParameter hostIdParameter = new SqlParameter("@hostId", SqlDbType.UniqueIdentifier); 1419SqlParameter lockTimeoutParameter = new SqlParameter("@lockTimeout", SqlDbType.Int); 1423SqlParameter resultParameter = new SqlParameter("@result", SqlDbType.Int); 1470SqlParameter idParameter = new SqlParameter("@id", SqlDbType.UniqueIdentifier); 1474SqlParameter instanceParameter = new SqlParameter("@instance", SqlDbType.Image); 1475SqlParameter instanceXmlParameter = new SqlParameter("@instanceXml", SqlDbType.Xml); 1491SqlParameter unlockInstanceParameter = new SqlParameter("@unlockInstance", SqlDbType.Bit); 1495SqlParameter lockOwnerParameter = new SqlParameter("@hostId", SqlDbType.UniqueIdentifier); 1499SqlParameter lockTimeoutParameter = new SqlParameter("@lockTimeout", SqlDbType.Int); 1503SqlParameter resultParameter = new SqlParameter("@result", SqlDbType.Int);