=> dbType != EnumerableMultiParameter; // just in case called with non-nullable /// <summary> /// Add all the parameters needed to the command just before it executes /// </summary> /// <param name="command">The raw command prior to execution</param> /// <param name="identity">Information about the query</param> protected void AddParameters(IDbCommand command, SqlMapper.Identity identity) { var literals = SqlMapper.GetLiteralTokens(identity.sql); if (templates != null) { foreach (var template in templates) { var newIdent = identity.ForDynamicParameters(template.GetType()); Action <IDbCommand, object> appender; lock (paramReaderCache) { if (!paramReaderCache.TryGetValue(newIdent, out appender)) { appender = SqlMapper.CreateParamInfoGenerator(newIdent, true, RemoveUnused, literals); paramReaderCache[newIdent] = appender; } } appender(command, template); } // The parameters were added to the command, but not the // DynamicParameters until now. foreach (IDbDataParameter param in command.Parameters) { // If someone makes a DynamicParameters with a template, // then explicitly adds a parameter of a matching name, // it will already exist in 'parameters'. if (!parameters.ContainsKey(param.ParameterName)) { parameters.Add(param.ParameterName, new ParamInfo { AttachedParam = param, CameFromTemplate = true, DbType = param.DbType, Name = param.ParameterName, ParameterDirection = param.Direction, Size = param.Size, Value = param.Value }); } } // Now that the parameters are added to the command, let's place our output callbacks var tmp = outputCallbacks; if (tmp != null) { foreach (var generator in tmp) { generator(); } } } foreach (var param in parameters.Values) { if (param.CameFromTemplate) { continue; } var dbType = param.DbType; var val = param.Value; string name = Clean(param.Name); var isCustomQueryParameter = val is SqlMapper.ICustomQueryParameter; SqlMapper.ITypeHandler handler = null; if (dbType == null && val != null && !isCustomQueryParameter) { #pragma warning disable 618 dbType = SqlMapper.LookupDbType(val.GetType(), name, true, out handler); #pragma warning disable 618 } if (isCustomQueryParameter) { ((SqlMapper.ICustomQueryParameter)val).AddParameter(command, name); } else if (dbType == EnumerableMultiParameter) { #pragma warning disable 612, 618 SqlMapper.PackListParameters(command, name, val); #pragma warning restore 612, 618 } else { bool add = !command.Parameters.Contains(name); IDbDataParameter p; if (add) { p = command.CreateParameter(); p.ParameterName = name; } else { p = (IDbDataParameter)command.Parameters[name]; } p.Direction = param.ParameterDirection; if (handler == null) { #pragma warning disable 0618 p.Value = SqlMapper.SanitizeParameterValue(val); #pragma warning restore 0618 if (ShouldSetDbType(dbType) && p.DbType != dbType.GetValueOrDefault()) { p.DbType = dbType.GetValueOrDefault(); } var s = val as string; if (s?.Length <= DbString.DefaultLength) { p.Size = DbString.DefaultLength; } if (param.Size != null) { p.Size = param.Size.Value; } if (param.Precision != null) { p.Precision = param.Precision.Value; } if (param.Scale != null) { p.Scale = param.Scale.Value; } } else { if (ShouldSetDbType(dbType)) { p.DbType = dbType.GetValueOrDefault(); } if (param.Size != null) { p.Size = param.Size.Value; } if (param.Precision != null) { p.Precision = param.Precision.Value; } if (param.Scale != null) { p.Scale = param.Scale.Value; } handler.SetValue(p, val ?? DBNull.Value); } if (add) { command.Parameters.Add(p); } param.AttachedParam = p; } } // note: most non-privileged implementations would use: this.ReplaceLiterals(command); if (literals.Count != 0) { SqlMapper.ReplaceLiterals(this, command, literals); } }
// Token: 0x0600003A RID: 58 RVA: 0x00002DA0 File Offset: 0x00000FA0 protected void AddParameters(IDbCommand command, SqlMapper.Identity identity) { IList <SqlMapper.LiteralToken> literalTokens = SqlMapper.GetLiteralTokens(identity.sql); if (this.templates != null) { foreach (object obj in this.templates) { SqlMapper.Identity identity2 = identity.ForDynamicParameters(obj.GetType()); Dictionary <SqlMapper.Identity, Action <IDbCommand, object> > obj2 = DynamicParameters.paramReaderCache; Action <IDbCommand, object> action; lock (obj2) { if (!DynamicParameters.paramReaderCache.TryGetValue(identity2, out action)) { action = SqlMapper.CreateParamInfoGenerator(identity2, true, this.RemoveUnused, literalTokens); DynamicParameters.paramReaderCache[identity2] = action; } } action(command, obj); } foreach (object obj3 in command.Parameters) { IDbDataParameter dbDataParameter = (IDbDataParameter)obj3; if (!this.parameters.ContainsKey(dbDataParameter.ParameterName)) { this.parameters.Add(dbDataParameter.ParameterName, new DynamicParameters.ParamInfo { AttachedParam = dbDataParameter, CameFromTemplate = true, DbType = new DbType?(dbDataParameter.DbType), Name = dbDataParameter.ParameterName, ParameterDirection = dbDataParameter.Direction, Size = new int?(dbDataParameter.Size), Value = dbDataParameter.Value }); } } List <Action> list = this.outputCallbacks; if (list != null) { foreach (Action action2 in list) { action2(); } } } foreach (DynamicParameters.ParamInfo paramInfo in this.parameters.Values) { if (!paramInfo.CameFromTemplate) { DbType?dbType = paramInfo.DbType; object value = paramInfo.Value; string text = DynamicParameters.Clean(paramInfo.Name); bool flag2 = value is SqlMapper.ICustomQueryParameter; SqlMapper.ITypeHandler typeHandler = null; if (dbType == null && value != null && !flag2) { dbType = new DbType?(SqlMapper.LookupDbType(value.GetType(), text, true, out typeHandler)); } if (flag2) { ((SqlMapper.ICustomQueryParameter)value).AddParameter(command, text); } else if (dbType == (DbType)(-1)) { SqlMapper.PackListParameters(command, text, value); } else { bool flag3 = !command.Parameters.Contains(text); IDbDataParameter dbDataParameter2; if (flag3) { dbDataParameter2 = command.CreateParameter(); dbDataParameter2.ParameterName = text; } else { dbDataParameter2 = (IDbDataParameter)command.Parameters[text]; } dbDataParameter2.Direction = paramInfo.ParameterDirection; if (typeHandler == null) { dbDataParameter2.Value = SqlMapper.SanitizeParameterValue(value); if (dbType != null && dbDataParameter2.DbType != dbType) { dbDataParameter2.DbType = dbType.Value; } string text2 = value as string; if (text2 != null && text2.Length <= 4000) { dbDataParameter2.Size = 4000; } if (paramInfo.Size != null) { dbDataParameter2.Size = paramInfo.Size.Value; } if (paramInfo.Precision != null) { dbDataParameter2.Precision = paramInfo.Precision.Value; } if (paramInfo.Scale != null) { dbDataParameter2.Scale = paramInfo.Scale.Value; } } else { if (dbType != null) { dbDataParameter2.DbType = dbType.Value; } if (paramInfo.Size != null) { dbDataParameter2.Size = paramInfo.Size.Value; } if (paramInfo.Precision != null) { dbDataParameter2.Precision = paramInfo.Precision.Value; } if (paramInfo.Scale != null) { dbDataParameter2.Scale = paramInfo.Scale.Value; } typeHandler.SetValue(dbDataParameter2, value ?? DBNull.Value); } if (flag3) { command.Parameters.Add(dbDataParameter2); } paramInfo.AttachedParam = dbDataParameter2; } } } if (literalTokens.Count != 0) { SqlMapper.ReplaceLiterals(this, command, literalTokens); } }