Hitting SQL 2100 parameter limit about dbextensions HOT 3 CLOSED

public class DataContextCommandDatabase : Database
{
	private const int SQL_MAX_PARAMETER_COUNT = 2050;

	public DataContextCommandDatabase(IDbConnection connection) : base(connection) { }

	public new IDbCommand CreateCommand(string commandText, params object[] parameters)
	{
		if (parameters == null || parameters.Length < SQL_MAX_PARAMETER_COUNT)
		{
			return base.CreateCommand(commandText, parameters);
		}
		else
		{
			// this code is taken directly from Database base class
			if (commandText == null) throw new ArgumentNullException(nameof(commandText));

			IDbCommand command = this.Connection.CreateCommand();

			IDbTransaction transaction = this.Transaction;

			if (transaction != null)
			{
				command.Transaction = transaction;
			}

			int commandTimeout = this.Configuration.CommandTimeout;

			if (commandTimeout > -1)
			{
				command.CommandTimeout = commandTimeout;
			}

			var paramIndex = 0;
			var commandParameters = new Dictionary<object, IDataParameter>();
			var paramPlaceholders = new object[parameters.Length];

			// i have just added checks here to see what it is, atm i am always using parameters on strings
			for (int i = 0; i < paramPlaceholders.Length; i++)
			{
				object paramValue = parameters[i];

				if (commandParameters.ContainsKey(paramValue))
				{
					// parameter with value already exists, so use it
					var dbParam = commandParameters[paramValue];
					paramPlaceholders[i] = this.Configuration.ParameterPlaceholderBuilder(dbParam.ParameterName);
				}
				else if (commandParameters.Keys.Count < SQL_MAX_PARAMETER_COUNT)
				{
					IDataParameter dbParam = paramValue as IDataParameter;

					if (dbParam == null)
					{
						dbParam = command.CreateParameter();
						dbParam.Value = paramValue ?? DBNull.Value;
					}

					dbParam.ParameterName = this.Configuration.ParameterNameBuilder("p" + paramIndex.ToString(CultureInfo.InvariantCulture));
					command.Parameters.Add(dbParam);

					paramPlaceholders[i] = this.Configuration.ParameterPlaceholderBuilder(dbParam.ParameterName);

					commandParameters[paramValue] = dbParam;
					paramIndex++;
				}
				else if (paramValue == null)
				{
					paramPlaceholders[i] = "NULL";
				}
				else
				{
					if (paramValue is bool)
					{
						paramPlaceholders[i] = ((bool)paramValue) ? 1 : 0;
					}
					else if (paramValue is DateTime)
					{
						var asDate = (DateTime)paramValue;
						paramPlaceholders[i] = "CAST('" + asDate.ToString("yyyy-MM-dd HH:mm:ss.fff") + "' AS DATETIME2(0))";
					}
					else if (paramValue is string)
					{
						paramPlaceholders[i] = "'" + paramValue.ToString().Replace("'", "''") + "'";
					}
					else
					{
						paramPlaceholders[i] = paramValue;
					}
				}
			}

			command.CommandText = string.Format(CultureInfo.InvariantCulture, commandText, paramPlaceholders);

			return command;
		}
	}
}