MySqlSharp.Provider
Class MySqlParameterCollection

Collects all parameters relevant to a MySqlSharp.Provider.MySqlCommand as well as their respective mappings to System.Data.DataSet columns.

Count

public int Count

Gets the number of MySqlSharp.Provider.MySqlParameter objects in the collection.

Value:

The number of MySqlSharp.Provider.MySqlParameter objects in the collection.

Item

public MySqlSharp.Provider.MySqlParameter this[int i]

Gets the MySqlSharp.Provider.MySqlParameter at the specified index.

Item

public MySqlSharp.Provider.MySqlParameter this[string parameterName]

Gets the MySqlSharp.Provider.MySqlParameter with the specified name.

Add

public int Add(object value)

Adds the specified MySqlSharp.Provider.MySqlParameter object to the MySqlSharp.Provider.MySqlParameterCollection.

Parameters:

value - The MySqlSharp.Provider.MySqlParameter to add to the collection.

Returns:

The index in the collection of the new MySqlSharp.Provider.MySqlParameter object.

Throws:

System.InvalidCastException - The parameter passed was not a MySqlSharp.Provider.MySqlParameter.

Add

public int Add(MySqlSharp.Provider.MySqlParameter value)

Adds the specified MySqlSharp.Provider.MySqlParameter object to the MySqlSharp.Provider.MySqlParameterCollection.

Parameters:

value - The MySqlSharp.Provider.MySqlParameter to add to the collection.

Returns:

The index in the collection of the new MySqlSharp.Provider.MySqlParameter object.

Add

public MySqlSharp.Provider.MySqlParameter Add(string parameterName,
                                              object value)

Adds a MySqlSharp.Provider.MySqlParameter to the MySqlSharp.Provider.MySqlParameterCollection with the specified parameter name and value.

Parameters:

parameterName - The name of the parameter.

value - The MySqlSharp.Provider.MySqlParameter.Value of the MySqlSharp.Provider.MySqlParameter to add to the collection.

Returns:

A reference to the new MySqlSharp.Provider.MySqlParameter object.

Add

public MySqlSharp.Provider.MySqlParameter Add(string parameterName,
                                              MySqlSharp.Provider.MySqlDbType dbType)

Adds a MySqlSharp.Provider.MySqlParameter to the MySqlSharp.Provider.MySqlParameterCollection with the parameter name and the data type.

Parameters:

parameterName - The name of the parameter.

dbType - One of the System.Data.SqlDbType values.

Returns:

A reference to the new MySqlSharp.Provider.MySqlParameter object.

Add

public MySqlSharp.Provider.MySqlParameter Add(string parameterName,
                                              MySqlSharp.Provider.MySqlDbType dbType,
                                              int size)

Adds a MySqlSharp.Provider.MySqlParameter to the MySqlSharp.Provider.MySqlParameterCollection with the parameter name, the data type, and the parameter size (column width).

Parameters:

parameterName - The name of the parameter.

dbType - One of the System.Data.SqlDbType values.

size - The size of the parameter (width of the column).

Returns:

A reference to the new MySqlSharp.Provider.MySqlParameter object.

Add

public MySqlSharp.Provider.MySqlParameter Add(string parameterName,
                                              MySqlSharp.Provider.MySqlDbType dbType,
                                              int size,
                                              string sourceColumn)

Adds a MySqlSharp.Provider.MySqlParameter to the MySqlSharp.Provider.MySqlParameterCollection with the parameter name, the data type, the parameter size (column width), and the source column name.

Parameters:

parameterName - The name of the parameter.

dbType - One of the System.Data.SqlDbType values.

size - The size of the parameter (width of the column).

sourceColumn - The name of the source column.

Returns:

A reference to the new MySqlSharp.Provider.MySqlParameter object.

Clear

public void Clear()

Removes all items from the collection.

Contains

public bool Contains(object value)

Indicates whether a MySqlSharp.Provider.MySqlParameter exists in the collection.

Parameters:

value - A MySqlSharp.Provider.MySqlParameter object.

Returns:

true if the collection contains the MySqlSharp.Provider.MySqlParameter object; otherwise, false.

Contains

public bool Contains(string value)

Indicates whether a MySqlSharp.Provider.MySqlParameter with the specified parameter name exists in the collection.

Parameters:

value - The name of the parameter to retrieve.

Returns:

true if the collection contains the parameter; otherwise, false.

CopyTo

public void CopyTo(System.Array array,
                   int index)

Copies MySqlSharp.Provider.MySqlParameter objects from the MySqlSharp.Provider.MySqlParameterCollection to the specified array.

Parameters:

array - An Array to which to copy the MySqlSharp.Provider.MySqlParameter objects in the collection.

index - The starting index of the array.

GetEnumerator

public System.Collections.IEnumerator GetEnumerator()

This member supports the .NET Framework infrastructure and is not intended to be used directly from your code.

IndexOf

public int IndexOf(object value)

Gets the location of a MySqlSharp.Provider.MySqlParameter in the collection.

Parameters:

value - The MySqlSharp.Provider.MySqlParameter object to locate.

Returns:

The zero-based location of the MySqlSharp.Provider.MySqlParameter in the collection.

IndexOf

public int IndexOf(string value)

Gets the location of the MySqlSharp.Provider.MySqlParameter in the collection with a specific parameter name.

Parameters:

value - The name of the parameter to retrieve.

Returns:

The zero-based location of the MySqlSharp.Provider.MySqlParameter in the collection.

Insert

public void Insert(int index,
                   object value)

Inserts a MySqlSharp.Provider.MySqlParameter in the collection at the specified index.

Parameters:

index - The zero-based index within the collection to insert the value parameter.

value - The MySqlSharp.Provider.MySqlParameter to add to the collection.

Remove

public void Remove(object value)

Removes the specified MySqlSharp.Provider.MySqlParameter from the collection.

Parameters:

value - A MySqlSharp.Provider.MySqlParameter object to remove from the collection.

RemoveAt

public void RemoveAt(int i)

Removes the specified MySqlSharp.Provider.MySqlParameter from the collection using a specific index.

Parameters:

i - The zero-based index of the parameter.

RemoveAt

public void RemoveAt(string parameterName)

Removes the specified MySqlSharp.Provider.MySqlParameter from the collection using the parameter name.

Parameters:

parameterName - The name of the parameter to retrieve.