ObjectParameterCollection.Count Propriedade
Definição
Obtém o número de parâmetros que estão na coleção no momento.Gets the number of parameters currently in the collection.
public:
property int Count { int get(); };
public int Count { get; }
member this.Count : int
Public ReadOnly Property Count As Integer
Valor da propriedade
O número de ObjectParameter objetos que estão atualmente na coleção.The number of ObjectParameter objects that are currently in the collection.
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 adiciona novos parâmetros à coleção e obtém a contagem dos parâmetros na coleção.The example adds new parameters to the collection and gets the count of the parameters in the collection. Em seguida, ele faz a iteração através do ObjectParameterCollection e exibe o nome, o tipo e o valor de cada parâmetro na coleção.Then it iterates through the ObjectParameterCollection and displays the name, type, and value of each parameter in the collection.
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;
Console.WriteLine("Count is {0}.", objectParameterCollection.Count);
// Iterate through the ObjectParameterCollection collection.
foreach (ObjectParameter result in objectParameterCollection)
{
Console.WriteLine("{0} {1} {2}", result.Name,
result.Value,
result.ParameterType);
}
}
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
Console.WriteLine("Count is {0}.", objectParameterCollection.Count)
' Iterate through the ObjectParameterCollection collection.
For Each result As ObjectParameter In objectParameterCollection
Console.WriteLine("{0} {1} {2}", result.Name, result.Value, result.ParameterType)
Next
End Using