/// <summary>

/// Represents a collection of parameters relevant to a <see cref="NpgsqlCommand">NpgsqlCommand</see>

/// as well as their respective mappings to columns in a DataSet.

/// This class cannot be inherited.

/// </summary>

public sealed class NpgsqlParameterCollection : DbParameterCollection, IList<NpgsqlParameter>

{

readonly List<NpgsqlParameter> _internalList = new List<NpgsqlParameter>(5);

// Dictionary lookups for GetValue to improve performance

Dictionary<string, int> _lookup;

Dictionary<string, int> _lookupIgnoreCase;

/// <summary>

/// Initializes a new instance of the NpgsqlParameterCollection class.

/// </summary>

internal NpgsqlParameterCollection()

{

InvalidateHashLookups();

}

/// <summary>

/// Invalidate the hash lookup tables. This should be done any time a change

/// may throw the lookups out of sync with the list.

/// </summary>

internal void InvalidateHashLookups()

{

_lookup = null;

_lookupIgnoreCase = null;

}

#region NpgsqlParameterCollection Member

/// <summary>

/// Gets the <see cref="NpgsqlParameter">NpgsqlParameter</see> with the specified name.

/// </summary>

/// <param name="parameterName">The name of the <see cref="NpgsqlParameter">NpgsqlParameter</see> to retrieve.</param>

/// <value>The <see cref="NpgsqlParameter">NpgsqlParameter</see> with the specified name, or a null reference if the parameter is not found.</value>

[PublicAPI]

public new NpgsqlParameter this[string parameterName]

{

get

{

var index = IndexOf(parameterName);

if (index == -1)

throw new ArgumentException("Parameter not found");

return _internalList[index];

}

set

{

var index = IndexOf(parameterName);

if (index == -1)

{

throw new ArgumentException("Parameter not found");

}

var oldValue = _internalList[index];

if (value.CleanName != oldValue.CleanName)

{

InvalidateHashLookups();

}

_internalList[index] = value;

}

}

/// <summary>

/// Gets the <see cref="NpgsqlParameter">NpgsqlParameter</see> at the specified index.

/// </summary>

/// <param name="index">The zero-based index of the <see cref="NpgsqlParameter">NpgsqlParameter</see> to retrieve.</param>

/// <value>The <see cref="NpgsqlParameter">NpgsqlParameter</see> at the specified index.</value>

[PublicAPI]

public new NpgsqlParameter this[int index]

{

get => _internalList[index];

set

{

var oldValue = _internalList[index];

if (oldValue == value)

{

// Reasigning the same value is a non-op.

return;

}

if (value.Collection != null)

{

throw new InvalidOperationException("The parameter already belongs to a collection");

}

if (value.CleanName != oldValue.CleanName)

{

InvalidateHashLookups();

}

_internalList[index] = value;

value.Collection = this;

oldValue.Collection = null;

}

}

/// <summary>

/// Adds the specified <see cref="NpgsqlParameter">NpgsqlParameter</see> object to the <see cref="NpgsqlParameterCollection">NpgsqlParameterCollection</see>.

/// </summary>

/// <param name="value">The <see cref="NpgsqlParameter">NpgsqlParameter</see> to add to the collection.</param>

/// <returns>The index of the new <see cref="NpgsqlParameter">NpgsqlParameter</see> object.</returns>

public NpgsqlParameter Add(NpgsqlParameter value)

{

// Do not allow parameters without name.

if (value.Collection != null)

{

throw new InvalidOperationException("The parameter already belongs to a collection");

}

_internalList.Add(value);

value.Collection = this;

InvalidateHashLookups();

// Check if there is a name. If not, add a name based of the index+1 of the parameter.

if (value.ParameterName.Trim() == string.Empty || (value.ParameterName.Length == 1 && value.ParameterName[0] == ':'))

{

value.ParameterName = ":" + "Parameter" + _internalList.Count;

value.AutoAssignedName = true;

}

return value;

}

void ICollection<NpgsqlParameter>.Add([NotNull] NpgsqlParameter item)

{

Add(item);

}

/// <summary>

/// Adds a <see cref="NpgsqlParameter">NpgsqlParameter</see> to the <see cref="NpgsqlParameterCollection">NpgsqlParameterCollection</see> given the specified parameter name and value.

/// </summary>

/// <param name="parameterName">The name of the <see cref="NpgsqlParameter">NpgsqlParameter</see>.</param>

/// <param name="value">The Value of the <see cref="NpgsqlParameter">NpgsqlParameter</see> to add to the collection.</param>

/// <returns>The paramater that was added.</returns>

[PublicAPI]

public NpgsqlParameter AddWithValue(string parameterName, object value)

{

return Add(new NpgsqlParameter(parameterName, value));

}

/// <summary>

/// Adds a <see cref="NpgsqlParameter">NpgsqlParameter</see> to the <see cref="NpgsqlParameterCollection">NpgsqlParameterCollection</see> given the specified parameter name, data type and value.

/// </summary>

/// <param name="parameterName">The name of the <see cref="NpgsqlParameter">NpgsqlParameter</see>.</param>

/// <param name="parameterType">One of the NpgsqlDbType values.</param>

/// <param name="value">The Value of the <see cref="NpgsqlParameter">NpgsqlParameter</see> to add to the collection.</param>

/// <returns>The paramater that was added.</returns>

[PublicAPI]

public NpgsqlParameter AddWithValue(string parameterName, NpgsqlDbType parameterType, object value)

{

return Add(new NpgsqlParameter(parameterName, parameterType) { Value = value });

}

/// <summary>

/// Adds a <see cref="NpgsqlParameter">NpgsqlParameter</see> to the <see cref="NpgsqlParameterCollection">NpgsqlParameterCollection</see> given the specified parameter name and value.

/// </summary>

/// <param name="parameterName">The name of the <see cref="NpgsqlParameter">NpgsqlParameter</see>.</param>

/// <param name="value">The Value of the <see cref="NpgsqlParameter">NpgsqlParameter</see> to add to the collection.</param>

/// <param name="parameterType">One of the NpgsqlDbType values.</param>

/// <param name="size">The length of the column.</param>

/// <returns>The paramater that was added.</returns>

[PublicAPI]

public NpgsqlParameter AddWithValue(string parameterName, NpgsqlDbType parameterType, int size, object value)

{

return Add(new NpgsqlParameter(parameterName, parameterType, size) { Value = value });

}

/// <summary>

/// Adds a <see cref="NpgsqlParameter">NpgsqlParameter</see> to the <see cref="NpgsqlParameterCollection">NpgsqlParameterCollection</see> given the specified parameter name and value.

/// </summary>

/// <param name="parameterName">The name of the <see cref="NpgsqlParameter">NpgsqlParameter</see>.</param>

/// <param name="value">The Value of the <see cref="NpgsqlParameter">NpgsqlParameter</see> to add to the collection.</param>

/// <param name="parameterType">One of the NpgsqlDbType values.</param>

/// <param name="size">The length of the column.</param>

/// <param name="sourceColumn">The name of the source column.</param>

/// <returns>The paramater that was added.</returns>

[PublicAPI]

public NpgsqlParameter AddWithValue(string parameterName, NpgsqlDbType parameterType, int size, string sourceColumn, object value)

{

return Add(new NpgsqlParameter(parameterName, parameterType, size, sourceColumn) { Value = value });

}

/// <summary>

/// Adds a <see cref="NpgsqlParameter">NpgsqlParameter</see> to the <see cref="NpgsqlParameterCollection">NpgsqlParameterCollection</see> given the specified value.

/// </summary>

/// <param name="value">The Value of the <see cref="NpgsqlParameter">NpgsqlParameter</see> to add to the collection.</param>

/// <returns>The paramater that was added.</returns>

[PublicAPI]

public NpgsqlParameter AddWithValue(object value)

{

return Add(new NpgsqlParameter() { Value = value });

}

/// <summary>

/// Adds a <see cref="NpgsqlParameter">NpgsqlParameter</see> to the <see cref="NpgsqlParameterCollection">NpgsqlParameterCollection</see> given the specified data type and value.

/// </summary>

/// <param name="parameterType">One of the NpgsqlDbType values.</param>

/// <param name="value">The Value of the <see cref="NpgsqlParameter">NpgsqlParameter</see> to add to the collection.</param>

/// <returns>The paramater that was added.</returns>

[PublicAPI]

public NpgsqlParameter AddWithValue(NpgsqlDbType parameterType, object value)

{

return Add(new NpgsqlParameter {

NpgsqlDbType = parameterType,

Value = value

});

}

/// <summary>

/// Adds a <see cref="NpgsqlParameter">NpgsqlParameter</see> to the <see cref="NpgsqlParameterCollection">NpgsqlParameterCollection</see> given the parameter name and the data type.

/// </summary>

/// <param name="parameterName">The name of the parameter.</param>

/// <param name="parameterType">One of the DbType values.</param>

/// <returns>The index of the new <see cref="NpgsqlParameter">NpgsqlParameter</see> object.</returns>

[PublicAPI]

public NpgsqlParameter Add(string parameterName, NpgsqlDbType parameterType)

{

return Add(new NpgsqlParameter(parameterName, parameterType));

}

/// <summary>

/// Adds a <see cref="NpgsqlParameter">NpgsqlParameter</see> to the <see cref="NpgsqlParameterCollection">NpgsqlParameterCollection</see> with the parameter name, the data type, and the column length.

/// </summary>

/// <param name="parameterName">The name of the parameter.</param>

/// <param name="parameterType">One of the DbType values.</param>

/// <param name="size">The length of the column.</param>

/// <returns>The index of the new <see cref="NpgsqlParameter">NpgsqlParameter</see> object.</returns>

[PublicAPI]

public NpgsqlParameter Add(string parameterName, NpgsqlDbType parameterType, int size)

{

return Add(new NpgsqlParameter(parameterName, parameterType, size));

}

/// <summary>

/// Adds a <see cref="NpgsqlParameter">NpgsqlParameter</see> to the <see cref="NpgsqlParameterCollection">NpgsqlParameterCollection</see> with the parameter name, the data type, the column length, and the source column name.

/// </summary>

/// <param name="parameterName">The name of the parameter.</param>

/// <param name="parameterType">One of the DbType values.</param>

/// <param name="size">The length of the column.</param>

/// <param name="sourceColumn">The name of the source column.</param>

/// <returns>The index of the new <see cref="NpgsqlParameter">NpgsqlParameter</see> object.</returns>

[PublicAPI]

public NpgsqlParameter Add(string parameterName, NpgsqlDbType parameterType, int size, string sourceColumn)

{

return Add(new NpgsqlParameter(parameterName, parameterType, size, sourceColumn));

}

#endregion

#region IDataParameterCollection Member

/// <summary>

/// Removes the specified <see cref="NpgsqlParameter">NpgsqlParameter</see> from the collection using the parameter name.

/// </summary>

/// <param name="parameterName">The name of the <see cref="NpgsqlParameter">NpgsqlParameter</see> object to retrieve.</param>

[PublicAPI]

// ReSharper disable once ImplicitNotNullOverridesUnknownExternalMember

public override void RemoveAt(string parameterName)

{

if (parameterName == null)

throw new ArgumentNullException(nameof(parameterName));

RemoveAt(IndexOf(parameterName));

}

/// <summary>

/// Gets a value indicating whether a <see cref="NpgsqlParameter">NpgsqlParameter</see> with the specified parameter name exists in the collection.

/// </summary>

/// <param name="parameterName">The name of the <see cref="NpgsqlParameter">NpgsqlParameter</see> object to find.</param>

/// <returns><b>true</b> if the collection contains the parameter; otherwise, <b>false</b>.</returns>

// ReSharper disable once ImplicitNotNullOverridesUnknownExternalMember

public override bool Contains(string parameterName)

{

if (parameterName == null)

throw new ArgumentNullException(nameof(parameterName));

return (IndexOf(parameterName) != -1);

}

/// <summary>

/// Gets the location of the <see cref="NpgsqlParameter">NpgsqlParameter</see> in the collection with a specific parameter name.

/// </summary>

/// <param name="parameterName">The name of the <see cref="NpgsqlParameter">NpgsqlParameter</see> object to find.</param>

/// <returns>The zero-based location of the <see cref="NpgsqlParameter">NpgsqlParameter</see> in the collection.</returns>

public override int IndexOf([CanBeNull] string parameterName)

{

if (parameterName == null)

{

return -1;

}

int retIndex;

int scanIndex;

if (parameterName.Length > 0 && ((parameterName[0] == ':') || (parameterName[0] == '@')))

{

parameterName = parameterName.Remove(0, 1);

}

// Using a dictionary is much faster for 5 or more items

if (_internalList.Count >= 5)

{

if (_lookup == null)

{

_lookup = new Dictionary<string, int>();

for (scanIndex = 0 ; scanIndex < _internalList.Count ; scanIndex++)

{

var item = _internalList[scanIndex];

// Store only the first of each distinct value

if (! _lookup.ContainsKey(item.CleanName))

{

_lookup.Add(item.CleanName, scanIndex);

}

}

}

// Try to access the case sensitive parameter name first

if (_lookup.TryGetValue(parameterName, out retIndex))

{

return retIndex;

}

// Case sensitive lookup failed, generate a case insensitive lookup

if (_lookupIgnoreCase == null)

{

_lookupIgnoreCase = new Dictionary<string, int>(PGUtil.InvariantCaseIgnoringStringComparer);

for (scanIndex = 0 ; scanIndex < _internalList.Count ; scanIndex++)

{

var item = _internalList[scanIndex];

// Store only the first of each distinct value

if (!_lookupIgnoreCase.ContainsKey(item.CleanName))

{

_lookupIgnoreCase.Add(item.CleanName, scanIndex);

}

}

}

// Then try to access the case insensitive parameter name

if (_lookupIgnoreCase.TryGetValue(parameterName, out retIndex))

{

return retIndex;

}

return -1;

}

retIndex = -1;

// Scan until a case insensitive match is found, and save its index for possible return.

// Items that don't match loosely cannot possibly match exactly.

for (scanIndex = 0 ; scanIndex < _internalList.Count ; scanIndex++)

{

var item = _internalList[scanIndex];

var comparer = PGUtil.InvariantCaseIgnoringStringComparer;

if (comparer.Compare(parameterName, item.CleanName) == 0)

{

retIndex = scanIndex;

break;

}

}

// Then continue the scan until a case sensitive match is found, and return it.

// If a case insensitive match was found, it will be re-checked for an exact match.

for ( ; scanIndex < _internalList.Count ; scanIndex++)

{

var item = _internalList[scanIndex];

if (item.CleanName == parameterName)

{

return scanIndex;

}

}

// If a case insensitive match was found, it will be returned here.

return retIndex;

}

#endregion

#region IList Member

#if !NETSTANDARD1_3

/// <summary>

/// Report whether the collection is read only. Always false.

/// </summary>

public override bool IsReadOnly => false;

#endif

/// <summary>

/// Removes the specified <see cref="NpgsqlParameter">NpgsqlParameter</see> from the collection using a specific index.

/// </summary>

/// <param name="index">The zero-based index of the parameter.</param>

public override void RemoveAt(int index)

{

if (_internalList.Count - 1 < index)

{

throw new IndexOutOfRangeException();

}

Remove(_internalList[index]);

}

/// <summary>

/// Inserts a <see cref="NpgsqlParameter">NpgsqlParameter</see> into the collection at the specified index.

/// </summary>

/// <param name="index">The zero-based index where the parameter is to be inserted within the collection.</param>

/// <param name="oValue">The <see cref="NpgsqlParameter">NpgsqlParameter</see> to add to the collection.</param>

public override void Insert(int index, [NotNull] object oValue)

{

if (oValue == null)

throw new ArgumentNullException(nameof(oValue));

CheckType(oValue);

var value = oValue as NpgsqlParameter;

Debug.Assert(value != null);

if (value.Collection != null)

{

throw new InvalidOperationException("The parameter already belongs to a collection");

}

value.Collection = this;

_internalList.Insert(index, value);

InvalidateHashLookups();

}

/// <summary>

/// Removes the specified <see cref="NpgsqlParameter">NpgsqlParameter</see> from the collection.

/// </summary>

/// <param name="parameterName">The name of the <see cref="NpgsqlParameter">NpgsqlParameter</see> to remove from the collection.</param>

[PublicAPI]

public void Remove(string parameterName)

{

var index = IndexOf(parameterName);

if (index < 0)

{

throw new InvalidOperationException("No parameter with the specified name exists in the collection");

}

RemoveAt(index);

}

/// <summary>

/// Removes the specified <see cref="NpgsqlParameter">NpgsqlParameter</see> from the collection.

/// </summary>

/// <param name="oValue">The <see cref="NpgsqlParameter">NpgsqlParameter</see> to remove from the collection.</param>

public override void Remove([NotNull] object oValue)

{

if (oValue == null)

throw new ArgumentNullException(nameof(oValue));

CheckType(oValue);

var p = oValue as NpgsqlParameter;

Debug.Assert(p != null);

Remove(p);

}

/// <summary>

/// Gets a value indicating whether a <see cref="NpgsqlParameter">NpgsqlParameter</see> exists in the collection.

/// </summary>

/// <param name="value">The value of the <see cref="NpgsqlParameter">NpgsqlParameter</see> object to find.</param>

/// <returns>true if the collection contains the <see cref="NpgsqlParameter">NpgsqlParameter</see> object; otherwise, false.</returns>

// ReSharper disable once AnnotationRedundancyInHierarchy

public override bool Contains([CanBeNull] object value)

{

if (!(value is NpgsqlParameter))

{

return false;

}

return _internalList.Contains((NpgsqlParameter) value);

}

/// <summary>

/// Gets a value indicating whether a <see cref="NpgsqlParameter">NpgsqlParameter</see> with the specified parameter name exists in the collection.

/// </summary>

/// <param name="parameterName">The name of the <see cref="NpgsqlParameter">NpgsqlParameter</see> object to find.</param>

/// <param name="parameter">A reference to the requested parameter is returned in this out param if it is found in the list. This value is null if the parameter is not found.</param>

/// <returns><b>true</b> if the collection contains the parameter and param will contain the parameter; otherwise, <b>false</b>.</returns>

[ContractAnnotation("=>true,parameter:notnull; =>false,parameter:null")]

public bool TryGetValue(string parameterName, [CanBeNull] out NpgsqlParameter parameter)

{

var index = IndexOf(parameterName);

if (index != -1)

{

parameter = _internalList[index];

return true;

}

else

{

parameter = null;

return false;

}

}

/// <summary>

/// Removes all items from the collection.

/// </summary>

public override void Clear()

{

foreach (var toRemove in _internalList)

{

// clean up the parameter so it can be added to another command if required.

toRemove.Collection = null;

}

_internalList.Clear();

InvalidateHashLookups();

}

/// <summary>

/// Gets the location of a <see cref="NpgsqlParameter">NpgsqlParameter</see> in the collection.

/// </summary>

/// <param name="value">The value of the <see cref="NpgsqlParameter">NpgsqlParameter</see> object to find.</param>

/// <returns>The zero-based index of the <see cref="NpgsqlParameter">NpgsqlParameter</see> object in the collection.</returns>

// ReSharper disable once ImplicitNotNullConflictInHierarchy

public override int IndexOf([NotNull] object value)

{

if (value == null)

throw new ArgumentNullException(nameof(value));

CheckType(value);

return _internalList.IndexOf((NpgsqlParameter) value);

}

/// <summary>

/// Adds the specified <see cref="NpgsqlParameter">NpgsqlParameter</see> object to the <see cref="NpgsqlParameterCollection">NpgsqlParameterCollection</see>.

/// </summary>

/// <param name="value">The <see cref="NpgsqlParameter">NpgsqlParameter</see> to add to the collection.</param>

/// <returns>The zero-based index of the new <see cref="NpgsqlParameter">NpgsqlParameter</see> object.</returns>

public override int Add([NotNull] object value)

{

CheckType(value);

Add((NpgsqlParameter) value);

return Count - 1;

}

#if !NETSTANDARD1_3

/// <summary>

/// Report whether the collection is fixed size. Always false.

/// </summary>

public override bool IsFixedSize => false;

#endif

#endregion

#region ICollection Member

#if !NETSTANDARD1_3

/// <summary>

/// Report whether the collection is synchronized.

/// </summary>

public override bool IsSynchronized => (_internalList as ICollection).IsSynchronized;

#endif

/// <summary>

/// Gets the number of <see cref="NpgsqlParameter">NpgsqlParameter</see> objects in the collection.

/// </summary>

/// <value>The number of <see cref="NpgsqlParameter">NpgsqlParameter</see> objects in the collection.</value>

public override int Count => _internalList.Count;

/// <summary>

/// Copies <see cref="NpgsqlParameter">NpgsqlParameter</see> objects from the <see cref="NpgsqlParameterCollection">NpgsqlParameterCollection</see> to the specified array.

/// </summary>

/// <param name="array">An <see cref="System.Array">Array</see> to which to copy the <see cref="NpgsqlParameter">NpgsqlParameter</see> objects in the collection.</param>

/// <param name="index">The starting index of the array.</param>

// ReSharper disable once ImplicitNotNullConflictInHierarchy

public override void CopyTo([NotNull] Array array, int index)

{

if (array == null)

throw new ArgumentNullException(nameof(array));

(_internalList as ICollection).CopyTo(array, index);

}

/// <summary>

/// Gets a value indicating whether the ICollection{T} is read-only.

/// </summary>

bool ICollection<NpgsqlParameter>.IsReadOnly => false;

/// <summary>

/// Sync root.

/// </summary>

public override object SyncRoot => (_internalList as ICollection).SyncRoot;

#endregion

#region IEnumerable Member

IEnumerator<NpgsqlParameter> IEnumerable<NpgsqlParameter>.GetEnumerator()

{

return _internalList.GetEnumerator();

}

/// <summary>

/// Returns an enumerator that can iterate through the collection.

/// </summary>

/// <returns>An <see cref="System.Collections.IEnumerator">IEnumerator</see> that can be used to iterate through the collection.</returns>

public override IEnumerator GetEnumerator()

{

return _internalList.GetEnumerator();

}

#endregion

/// <summary>

/// Add an Array of parameters to the collection.

/// </summary>

/// <param name="values">Parameters to add.</param>

public override void AddRange([NotNull]Array values)

{

foreach (NpgsqlParameter parameter in values)

Add(parameter);

}

/// <summary>

/// Get parameter.

/// </summary>

/// <param name="parameterName"></param>

/// <returns></returns>

// ReSharper disable once ImplicitNotNullOverridesUnknownExternalMember

protected override DbParameter GetParameter(string parameterName)

{

if (parameterName == null)

throw new ArgumentNullException(nameof(parameterName));

return this[parameterName];

}

/// <summary>

/// Get parameter.

/// </summary>

/// <param name="index"></param>

/// <returns></returns>

protected override DbParameter GetParameter(int index)

{

return this[index];

}

/// <summary>

/// Set parameter.

/// </summary>

/// <param name="parameterName"></param>

/// <param name="value"></param>

// ReSharper disable once ImplicitNotNullOverridesUnknownExternalMember

protected override void SetParameter(string parameterName, [NotNull] DbParameter value)

{

if (parameterName == null) throw new ArgumentNullException(nameof(parameterName));

this[parameterName] = (NpgsqlParameter) value;

}

/// <summary>

/// Set parameter.

/// </summary>

/// <param name="index"></param>

/// <param name="value"></param>

protected override void SetParameter(int index, [NotNull] DbParameter value)

{

this[index] = (NpgsqlParameter) value;

}

void CheckType(object o)

{

if (!(o is NpgsqlParameter))

throw new InvalidCastException($"Can't cast {o.GetType()} into NpgsqlParameter");

}

/// <summary>

/// Report the offset within the collection of the given parameter.

/// </summary>

/// <param name="item">Parameter to find.</param>

/// <returns>Index of the parameter, or -1 if the parameter is not present.</returns>

[PublicAPI]

public int IndexOf([NotNull] NpgsqlParameter item)

{

return _internalList.IndexOf(item);

}

/// <summary>

/// Insert the specified parameter into the collection.

/// </summary>

/// <param name="index">Index of the existing parameter before which to insert the new one.</param>

/// <param name="item">Parameter to insert.</param>

[PublicAPI]

public void Insert(int index, [NotNull] NpgsqlParameter item)

{

if (item.Collection != null)

throw new Exception("The parameter already belongs to a collection");

_internalList.Insert(index, item);

item.Collection = this;

InvalidateHashLookups();

}

/// <summary>

/// Report whether the specified parameter is present in the collection.

/// </summary>

/// <param name="item">Parameter to find.</param>

/// <returns>True if the parameter was found, otherwise false.</returns>

[PublicAPI]

public bool Contains([NotNull] NpgsqlParameter item) => _internalList.Contains(item);

/// <summary>

/// Remove the specified parameter from the collection.

/// </summary>

/// <param name="item">Parameter to remove.</param>

/// <returns>True if the parameter was found and removed, otherwise false.</returns>

[PublicAPI]

public bool Remove([NotNull] NpgsqlParameter item)

{

if (item == null)

throw new ArgumentNullException(nameof(item));

if (item.Collection != this)

throw new InvalidOperationException("The item does not belong to this collection");

if (_internalList.Remove(item))

{

item.Collection = null;

InvalidateHashLookups();

return true;

}

return false;

}

/// <summary>

/// Convert collection to a System.Array.

/// </summary>

/// <param name="array">Destination array.</param>

/// <param name="arrayIndex">Starting index in destination array.</param>

[PublicAPI]

public void CopyTo([NotNull] NpgsqlParameter[] array, int arrayIndex)

=> _internalList.CopyTo(array, arrayIndex);

/// <summary>

/// Convert collection to a System.Array.

/// </summary>

/// <returns>NpgsqlParameter[]</returns>

[PublicAPI]

public NpgsqlParameter[] ToArray() => _internalList.ToArray();

internal void CloneTo(NpgsqlParameterCollection other)

{

other._internalList.Clear();

foreach (var param in _internalList)

{

var newParam = param.Clone();

newParam.Collection = this;

other._internalList.Add(newParam);

}

other._lookup = _lookup;

other._lookupIgnoreCase = _lookupIgnoreCase;

}

internal bool HasOutputParameters

{

get

{

foreach (var p in _internalList)

if (p.IsOutputDirection)

return true;

return false;

}

}

}