C# 클래스 Npgsql.NpgsqlParameterCollection

상속: System.MarshalByRefObject, IDataParameterCollection

파일 보기 프로젝트 열기: undeadlabs/Npgsql 1 사용 예제들

Private Properties

프로퍼티	타입	설명
Add	Npgsql.NpgsqlParameter
CheckType	void
InvalidateHashLookups	void
NpgsqlParameterCollection	System
this	Npgsql.NpgsqlParameter
this	Npgsql.NpgsqlParameter

공개 메소드들

메소드	설명
Add ( Npgsql.NpgsqlParameter value ) : Npgsql.NpgsqlParameter	Adds the specified NpgsqlParameter object to the NpgsqlParameterCollection.
Add ( string parameterName, NpgsqlDbType parameterType ) : Npgsql.NpgsqlParameter	Adds a NpgsqlParameter to the NpgsqlParameterCollection given the parameter name and the data type.
Add ( string parameterName, NpgsqlDbType parameterType, int size ) : Npgsql.NpgsqlParameter	Adds a NpgsqlParameter to the NpgsqlParameterCollection with the parameter name, the data type, and the column length.
Add ( string parameterName, NpgsqlDbType parameterType, int size, string sourceColumn ) : Npgsql.NpgsqlParameter	Adds a NpgsqlParameter to the NpgsqlParameterCollection with the parameter name, the data type, the column length, and the source column name.
Add ( object value ) : int	Adds the specified NpgsqlParameter object to the NpgsqlParameterCollection.
AddRange ( Array values ) : void	Add an Array of parameters to the collection.
AddWithValue ( string parameterName, NpgsqlDbType parameterType, int size, object value ) : Npgsql.NpgsqlParameter	Adds a NpgsqlParameter to the NpgsqlParameterCollection given the specified parameter name and value.
AddWithValue ( string parameterName, NpgsqlDbType parameterType, int size, string sourceColumn, object value ) : Npgsql.NpgsqlParameter	Adds a NpgsqlParameter to the NpgsqlParameterCollection given the specified parameter name and value.
AddWithValue ( string parameterName, NpgsqlDbType parameterType, object value ) : Npgsql.NpgsqlParameter	Adds a NpgsqlParameter to the NpgsqlParameterCollection given the specified parameter name and value.
AddWithValue ( string parameterName, object value ) : Npgsql.NpgsqlParameter	Adds a NpgsqlParameter to the NpgsqlParameterCollection given the specified parameter name and value.
Clear ( ) : void	Removes all items from the collection.
Contains ( Npgsql.NpgsqlParameter item ) : bool	Report whether the specified parameter is present in the collection.
Contains ( object value ) : bool	Gets a value indicating whether a NpgsqlParameter exists in the collection.
Contains ( string parameterName ) : bool	Gets a value indicating whether a NpgsqlParameter with the specified parameter name exists in the collection.
CopyTo ( Array array, int index ) : void	Copies NpgsqlParameter objects from the NpgsqlParameterCollection to the specified array.
CopyTo ( Npgsql.NpgsqlParameter array, int arrayIndex ) : void	Convert collection to a System.Array.
GetEnumerator ( ) : IEnumerator	Returns an enumerator that can iterate through the collection.
IndexOf ( Npgsql.NpgsqlParameter item ) : int	Report the offset within the collection of the given parameter.
IndexOf ( object value ) : int	Gets the location of a NpgsqlParameter in the collection.
IndexOf ( string parameterName ) : int	Gets the location of the NpgsqlParameter in the collection with a specific parameter name.
Insert ( int index, Npgsql.NpgsqlParameter item ) : void	Insert the specified parameter into the collection.
Insert ( int index, object oValue ) : void	Inserts a NpgsqlParameter into the collection at the specified index.
Remove ( Npgsql.NpgsqlParameter item ) : bool	Remove the specified parameter from the collection.
Remove ( object oValue ) : void	Removes the specified NpgsqlParameter from the collection.
Remove ( string parameterName ) : void	Removes the specified NpgsqlParameter from the collection.
RemoveAt ( int index ) : void	Removes the specified NpgsqlParameter from the collection using a specific index.
RemoveAt ( string parameterName ) : void	Removes the specified NpgsqlParameter from the collection using the parameter name.
ToArray ( ) : Npgsql.NpgsqlParameter[]	Convert collection to a System.Array.
TryGetValue ( string parameterName, Npgsql.NpgsqlParameter &parameter ) : bool	Gets a value indicating whether a NpgsqlParameter with the specified parameter name exists in the collection.

보호된 메소드들

메소드	설명
GetParameter ( int index ) : DbParameter	Get parameter.
GetParameter ( string parameterName ) : DbParameter	Get parameter.
SetParameter ( int index, DbParameter value ) : void	Set parameter.
SetParameter ( string parameterName, DbParameter value ) : void	Set parameter.

비공개 메소드들

메소드	설명
Add ( string parameterName, object value ) : Npgsql.NpgsqlParameter
CheckType ( object Object ) : void	In methods taking an object as argument this method is used to verify that the argument has the type NpgsqlParameter
InvalidateHashLookups ( ) : void	Invalidate the hash lookup tables. This should be done any time a change may throw the lookups out of sync with the list.
NpgsqlParameterCollection ( ) : System	Initializes a new instance of the NpgsqlParameterCollection class.
this ( int index ) : Npgsql.NpgsqlParameter
this ( string parameterName ) : Npgsql.NpgsqlParameter

메소드 상세

Add() 공개 메소드

Adds the specified NpgsqlParameter object to the NpgsqlParameterCollection.

public Add ( Npgsql.NpgsqlParameter value ) : Npgsql.NpgsqlParameter
value	Npgsql.NpgsqlParameter	The NpgsqlParameter to add to the collection.
리턴	Npgsql.NpgsqlParameter

Add() 공개 메소드

Adds a NpgsqlParameter to the NpgsqlParameterCollection given the parameter name and the data type.

public Add ( string parameterName, NpgsqlDbType parameterType ) : Npgsql.NpgsqlParameter
parameterName	string	The name of the parameter.
parameterType	NpgsqlDbType	One of the DbType values.
리턴	Npgsql.NpgsqlParameter

Add() 공개 메소드

Adds a NpgsqlParameter to the NpgsqlParameterCollection with the parameter name, the data type, and the column length.

public Add ( string parameterName, NpgsqlDbType parameterType, int size ) : Npgsql.NpgsqlParameter
parameterName	string	The name of the parameter.
parameterType	NpgsqlDbType	One of the DbType values.
size	int	The length of the column.
리턴	Npgsql.NpgsqlParameter

Add() 공개 메소드

Adds a NpgsqlParameter to the NpgsqlParameterCollection with the parameter name, the data type, the column length, and the source column name.

public Add ( string parameterName, NpgsqlDbType parameterType, int size, string sourceColumn ) : Npgsql.NpgsqlParameter
parameterName	string	The name of the parameter.
parameterType	NpgsqlDbType	One of the DbType values.
size	int	The length of the column.
sourceColumn	string	The name of the source column.
리턴	Npgsql.NpgsqlParameter

Add() 공개 메소드

Adds the specified NpgsqlParameter object to the NpgsqlParameterCollection.

public Add ( object value ) : int
value	object	The NpgsqlParameter to add to the collection.
리턴	int

AddRange() 공개 메소드

Add an Array of parameters to the collection.

public AddRange ( Array values ) : void
values	System.Array	Parameters to add.
리턴	void

AddWithValue() 공개 메소드

Adds a NpgsqlParameter to the NpgsqlParameterCollection given the specified parameter name and value.

public AddWithValue ( string parameterName, NpgsqlDbType parameterType, int size, object value ) : Npgsql.NpgsqlParameter
parameterName	string	The name of the NpgsqlParameter.
parameterType	NpgsqlDbType	One of the NpgsqlDbType values.
size	int	The length of the column.
value	object	The Value of the NpgsqlParameter to add to the collection.
리턴	Npgsql.NpgsqlParameter

AddWithValue() 공개 메소드

Adds a NpgsqlParameter to the NpgsqlParameterCollection given the specified parameter name and value.

public AddWithValue ( string parameterName, NpgsqlDbType parameterType, int size, string sourceColumn, object value ) : Npgsql.NpgsqlParameter
parameterName	string	The name of the NpgsqlParameter.
parameterType	NpgsqlDbType	One of the NpgsqlDbType values.
size	int	The length of the column.
sourceColumn	string	The name of the source column.
value	object	The Value of the NpgsqlParameter to add to the collection.
리턴	Npgsql.NpgsqlParameter

AddWithValue() 공개 메소드

Adds a NpgsqlParameter to the NpgsqlParameterCollection given the specified parameter name and value.

public AddWithValue ( string parameterName, NpgsqlDbType parameterType, object value ) : Npgsql.NpgsqlParameter
parameterName	string	The name of the NpgsqlParameter.
parameterType	NpgsqlDbType	One of the NpgsqlDbType values.
value	object	The Value of the NpgsqlParameter to add to the collection.
리턴	Npgsql.NpgsqlParameter

AddWithValue() 공개 메소드

Adds a NpgsqlParameter to the NpgsqlParameterCollection given the specified parameter name and value.

public AddWithValue ( string parameterName, object value ) : Npgsql.NpgsqlParameter
parameterName	string	The name of the NpgsqlParameter.
value	object	The Value of the NpgsqlParameter to add to the collection.
리턴	Npgsql.NpgsqlParameter

Clear() 공개 메소드

Removes all items from the collection.

public Clear ( ) : void
리턴	void

Contains() 공개 메소드

Report whether the specified parameter is present in the collection.

public Contains ( Npgsql.NpgsqlParameter item ) : bool
item	Npgsql.NpgsqlParameter	Parameter to find.
리턴	bool

Contains() 공개 메소드

Gets a value indicating whether a NpgsqlParameter exists in the collection.

public Contains ( object value ) : bool
value	object	The value of the NpgsqlParameter object to find.
리턴	bool

Contains() 공개 메소드

Gets a value indicating whether a NpgsqlParameter with the specified parameter name exists in the collection.

public Contains ( string parameterName ) : bool
parameterName	string	The name of the NpgsqlParameter object to find.
리턴	bool

CopyTo() 공개 메소드

Copies NpgsqlParameter objects from the NpgsqlParameterCollection to the specified array.

public CopyTo ( Array array, int index ) : void
array	System.Array	An Array to which to copy the NpgsqlParameter objects in the collection.
index	int	The starting index of the array.
리턴	void

CopyTo() 공개 메소드

Convert collection to a System.Array.

public CopyTo ( Npgsql.NpgsqlParameter array, int arrayIndex ) : void
array	Npgsql.NpgsqlParameter	Destination array.
arrayIndex	int	Starting index in destination array.
리턴	void

GetEnumerator() 공개 메소드

Returns an enumerator that can iterate through the collection.

public GetEnumerator ( ) : IEnumerator
리턴	IEnumerator

GetParameter() 보호된 메소드

Get parameter.

protected GetParameter ( int index ) : DbParameter
index	int
리턴	DbParameter

GetParameter() 보호된 메소드

Get parameter.

protected GetParameter ( string parameterName ) : DbParameter
parameterName	string
리턴	DbParameter

IndexOf() 공개 메소드

Report the offset within the collection of the given parameter.

public IndexOf ( Npgsql.NpgsqlParameter item ) : int
item	Npgsql.NpgsqlParameter	Parameter to find.
리턴	int

IndexOf() 공개 메소드

Gets the location of a NpgsqlParameter in the collection.

public IndexOf ( object value ) : int
value	object	The value of the NpgsqlParameter object to find.
리턴	int

IndexOf() 공개 메소드

Gets the location of the NpgsqlParameter in the collection with a specific parameter name.

public IndexOf ( string parameterName ) : int
parameterName	string	The name of the NpgsqlParameter object to find.
리턴	int

Insert() 공개 메소드

Insert the specified parameter into the collection.

public Insert ( int index, Npgsql.NpgsqlParameter item ) : void
index	int	Index of the existing parameter before which to insert the new one.
item	Npgsql.NpgsqlParameter	Parameter to insert.
리턴	void

Insert() 공개 메소드

Inserts a NpgsqlParameter into the collection at the specified index.

public Insert ( int index, object oValue ) : void
index	int	The zero-based index where the parameter is to be inserted within the collection.
oValue	object	The NpgsqlParameter to add to the collection.
리턴	void

Remove() 공개 메소드

Remove the specified parameter from the collection.

public Remove ( Npgsql.NpgsqlParameter item ) : bool
item	Npgsql.NpgsqlParameter	Parameter to remove.
리턴	bool

Remove() 공개 메소드

Removes the specified NpgsqlParameter from the collection.

public Remove ( object oValue ) : void
oValue	object	The NpgsqlParameter to remove from the collection.
리턴	void

Remove() 공개 메소드

Removes the specified NpgsqlParameter from the collection.

public Remove ( string parameterName ) : void
parameterName	string	The name of the NpgsqlParameter to remove from the collection.
리턴	void

RemoveAt() 공개 메소드

Removes the specified NpgsqlParameter from the collection using a specific index.

public RemoveAt ( int index ) : void
index	int	The zero-based index of the parameter.
리턴	void

RemoveAt() 공개 메소드

Removes the specified NpgsqlParameter from the collection using the parameter name.

public RemoveAt ( string parameterName ) : void
parameterName	string	The name of the NpgsqlParameter object to retrieve.
리턴	void

SetParameter() 보호된 메소드

Set parameter.

protected SetParameter ( int index, DbParameter value ) : void
index	int
value	DbParameter
리턴	void

SetParameter() 보호된 메소드

Set parameter.

protected SetParameter ( string parameterName, DbParameter value ) : void
parameterName	string
value	DbParameter
리턴	void

ToArray() 공개 메소드

Convert collection to a System.Array.

public ToArray ( ) : Npgsql.NpgsqlParameter[]
리턴	Npgsql.NpgsqlParameter[]

TryGetValue() 공개 메소드

Gets a value indicating whether a NpgsqlParameter with the specified parameter name exists in the collection.

public TryGetValue ( string parameterName, Npgsql.NpgsqlParameter &parameter ) : bool
parameterName	string	The name of the NpgsqlParameter object to find.
parameter	Npgsql.NpgsqlParameter	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.
리턴	bool