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