ObjectParameterCollection.CopyTo(ObjectParameter[], Int32) Método

Definição

Permite que os parâmetros na coleção sejam copiados para uma matriz fornecida, começando com o objeto no índice especificado.Allows the parameters in the collection to be copied into a supplied array, starting with the object at the specified index.

public:
 virtual void CopyTo(cli::array <System::Data::Objects::ObjectParameter ^> ^ array, int index);
public void CopyTo (System.Data.Objects.ObjectParameter[] array, int index);
abstract member CopyTo : System.Data.Objects.ObjectParameter[] * int -> unit
override this.CopyTo : System.Data.Objects.ObjectParameter[] * int -> unit
Public Sub CopyTo (array As ObjectParameter(), index As Integer)

Parâmetros

array
ObjectParameter[]

A matriz na qual copiar os parâmetros.The array into which to copy the parameters.

index
Int32

O índice na matriz na qual iniciar a cópia dos parâmetros.The index in the array at which to start copying the parameters.

Implementações

Exemplos

O exemplo neste tópico é baseado no Microsoft SQL Server exemplos de produto: banco de dados.The example in this topic is based on the Microsoft SQL Server Product Samples: Database. O exemplo copia os parâmetros para a matriz especificada.The example copies the parameters into the specified array.

using (AdventureWorksEntities context =
    new AdventureWorksEntities())
{
    string queryString =
        @"SELECT VALUE contact FROM AdventureWorksEntities.Contacts
        AS contact WHERE contact.LastName = @ln
        AND contact.FirstName = @fn";

    ObjectQuery<Contact> contactQuery =
        new ObjectQuery<Contact>(queryString, context);

    // Add parameters to the collection.
    contactQuery.Parameters.Add(new ObjectParameter("ln", "Adams"));
    contactQuery.Parameters.Add(new ObjectParameter("fn", "Frances"));

    ObjectParameterCollection objectParameterCollection =
        contactQuery.Parameters;
    ObjectParameter[] objectParameterArray =
        new ObjectParameter[objectParameterCollection.Count];

    objectParameterCollection.CopyTo(objectParameterArray, 0);

    // Iterate through the ObjectParameter array.
    for (int i = 0; i < objectParameterArray.Length; i++)
    {
        Console.WriteLine("Name: {0} Type: {1} Value: {2}",
            objectParameterArray[i].Name,
            objectParameterArray[i].ParameterType,
            objectParameterArray[i].Value);
    }
}
Using context As New AdventureWorksEntities()
    Dim queryString As String = "SELECT VALUE contact FROM AdventureWorksEntities.Contacts " & _
            " AS contact WHERE contact.LastName = @ln AND contact.FirstName = @fn"

    Dim contactQuery As New ObjectQuery(Of Contact)(queryString, context)

    ' Add parameters to the collection. 
    contactQuery.Parameters.Add(New ObjectParameter("ln", "Adams"))
    contactQuery.Parameters.Add(New ObjectParameter("fn", "Frances"))

    Dim objectParameterCollection As ObjectParameterCollection = contactQuery.Parameters
    Dim objectParameterArray As ObjectParameter() = New ObjectParameter(objectParameterCollection.Count - 1) {}

    objectParameterCollection.CopyTo(objectParameterArray, 0)

    ' Iterate through the ObjectParameter array. 
    For i As Integer = 0 To objectParameterArray.Length - 1
        Console.WriteLine("Name: {0} Type: {1} Value: {2}", _
                          objectParameterArray(i).Name, objectParameterArray(i).ParameterType, objectParameterArray(i).Value)
    Next
End Using

Aplica-se a