VKinfotek Inc.
  • Us
    About Us
    Contact Us
  • FAQs
  • Ready Software
    Ready ERP ASP Core Software for Azure Cloud
    Ready Web ERP Software
    Ready ASP.Net Azure Software
    Ready C# SQL Server Accounting Software
    Ready ASP.Net MVC and EF Software
First slide
Earn $100/hour in USA! Click Here

parameterized objectquery against a entity data model


What is an ObjectQuery ?
ObjectQuery is a class which is used to construct and execute queries against a Entity data model. Once the ObjectQuery has been executed, the results are returned as ObjectQuery<T>.

A parameterized ObjectQuery is an ObjectQuery with parameters. Adding parameters to queries makes the query more powerful. We can add parameters to the ObjectQuery after we instantiate the Object Query.

The statement
ObjectQuery Customers = new ObjectQuery(querystring,context);

Creates a new ObjectQuery instance using the Entity SQL query which is given below. The code below displays Customer ID of the selected customer named "Vam".

We know that this query returns an ObjectQuery objects. So, instead of writing a query with var keyword, we explicitly declared the type in the query.

We need to add parameters to the ObjectQuery prior to the execution. To work with ObjectQuery class, we need to add the System.Data.Objects namespace.

We also need to pass the ObjectContext as a parameter when we instantiate an Objectquery.
 
using (var context = new SalesOrderManagementEntities())
{
	string querystring = "SELECT VALUE Customer 
    FROM SalesOrderManagementEntities.Customer AS Customer 
    Where Customer.Name=@Name";
	ObjectQuery Customers = 
        new ObjectQuery(querystring,context);
	Customers.Parameters.Add(new ObjectParameter("Name", "Vam"));
	foreach (Customer result in Customers)
	Console.WriteLine(String.Format("{0} {1}",
	result.Name, result.CustomerId));
}


Entity Framework Articles
  • entity framework entity data model
  • entity framework orm object relational mapper
  • querying entity data model using objectcontext
  • using ado net entity data model in windows applications.html
  • create entity data model using ado.net entity framework designer in visual studio
  • create-sales-order-management-data-model-using-edmgen-tool.html
  • display data in a gridview using ado.net entity data source control
  • ways of querying entity data model
  • query entity data model using linq to entities
  • query entity data model with object services and entity sql
  • query entity data model using linq methods
  • query entity data model entity client
  • linq to entities query with projections in c#
  • entity framework - save changes to entities
  • entity framework - insert new objects
  • add an entity to associated entities
  • deleting entities using deleteobject() method of objectcontext
  • entity framework load method
  • eager loading using include method in entity framework
  • entity framework - retrieving a single entity
Most Viewed

Azure Q & A
Azure Platform
Grid-View
GridView CommandField example
Details-View
GridView and DetailsView Master/Detail page using SqlDataSource control
POCO
POCO overview and advantages - POCO class, Entity Framework in Enterprise Applications
Entity Framework
Query entity data model using linq to entities
Array List
Difference between arraylist and list collection
Web Services
How to create a Web service using Visual Studio.net
Form-View
FormView DataBound Event
Object Oriented Programming
Calling base class constructor in C#
Linq
Convert a sequence to a generic list using ToList()method
Project Ideas
Project ideas for students
AccountingSoftware
Accounting Software
MVC
Creating an ASP.Net MVC 3 application
.Net
Using assemblies in .net applications
ASP .Net
How to implement form validation using ASP.Net 2.0 Validation Controls
VB .Net
Constructors in Visual Basic.Net


  • SITEMAP
  • Terms of use
  • Testimonials

Back to top

Copyright © 2016 - All Rights Reserved - VKInfotek.com