.NET Framework Class Library ObjectParameter Class Represents a query parameter that is passed to an object query.
Inheritance Hierarchy
Namespace:
System.Data.Objects
Assembly:
System.Data.Entity (in System.Data.Entity.dll)
Syntax
Public NotInheritable Class ObjectParameter
public sealed class ObjectParameter
public ref class ObjectParameter sealed
[<Sealed>]
type ObjectParameter = class end
The ObjectParameter type exposes the following members.
Constructors
Methods
Remarks
Examples
The example in this topic is based on the Adventure Works Sales Model. The example adds new parameters to the collection. It iterates through the ObjectParameterCollection and displays the name, type, and value of each parameter in the collection.
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
' Iterate through the ObjectParameterCollection.
For Each result As ObjectParameter In objectParameterCollection
Console.WriteLine("{0} {1} {2}", result.Name, result.Value, result.ParameterType)
Next
End Using
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;
// Iterate through the ObjectParameterCollection.
foreach (ObjectParameter result in objectParameterCollection)
{
Console.WriteLine("{0} {1} {2}", result.Name,
result.Value,
result.ParameterType);
}
}
Version Information
.NET FrameworkSupported in: 4, 3.5 SP1 .NET Framework Client ProfileSupported in: 4
Platforms
Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core Role not supported), Windows Server 2008 R2 (Server Core Role not supported), Windows Server 2003 SP2
The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.
Thread Safety
Any public static ( Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
See Also
|
Biblioteca de clases de .NET Framework ObjectParameter (Clase) Representa un parámetro de consulta que se pasa a una consulta de objeto.
Jerarquía de herencia
Espacio de nombres:
System.Data.Objects
Ensamblado:
System.Data.Entity (en System.Data.Entity.dll)
Sintaxis
Public NotInheritable Class ObjectParameter
public sealed class ObjectParameter
public ref class ObjectParameter sealed
[<Sealed>]
type ObjectParameter = class end
El tipo ObjectParameter expone los siguientes miembros.
Constructores
Comentarios
Ejemplos
El ejemplo de este tema se basa en el Adventure Works Sales Model. En el ejemplo, se agregan nuevos parámetros a la colección. Se recorre en iteración la ObjectParameterCollection y se muestra el nombre, el tipo y el valor de cada parámetro de la colección.
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
' Iterate through the ObjectParameterCollection.
For Each result As ObjectParameter In objectParameterCollection
Console.WriteLine("{0} {1} {2}", result.Name, result.Value, result.ParameterType)
Next
End Using
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;
// Iterate through the ObjectParameterCollection.
foreach (ObjectParameter result in objectParameterCollection)
{
Console.WriteLine("{0} {1} {2}", result.Name,
result.Value,
result.ParameterType);
}
}
Información de versión
.NET FrameworkCompatible con: 4, 3.5 SP1 .NET Framework Client ProfileCompatible con: 4
Plataformas
Windows 7, Windows Vista SP1 o posterior, Windows XP SP3, Windows Server 2008 (no se admite Server Core), Windows Server 2008 R2 (se admite Server Core con SP1 o posterior), Windows Server 2003 SP2
.NET Framework no admite todas las versiones de todas las plataformas. Para obtener una lista de las versiones compatibles, vea Requisitos de sistema de .NET Framework.
Seguridad para subprocesos
Todos los miembros static ( Shared en Visual Basic) públicos de este tipo son seguros para la ejecución de subprocesos. No se garantiza que los miembros de instancias sean seguros para la ejecución de subprocesos.
Vea también
|