<< ADO.NET Entity Framework | Entity SQL query with parameters using ObjectQuery >>

Querying with Entity SQL

by Farooq Kaiser 9. June 2009 13:59

CreateQuery(T) Method creates an ObjectQuery(T) in the current object context by using the specified T-SQL-like query language. I will replace ADO.NET Entity Framework example with Entity SQL Query.

private void button1_Click(object sender, EventArgs e)

{

using (var context = new AdventureWorksEntities1())

{

var q = "SELECT VALUE c " +

"FROM Contact AS c " +

"WHERE c.LastName='Clark'";

var contacts = context.CreateQuery<Contact>(q);

dataGridView1.DataSource = contacts.ToList();

}

The above query will return all the contacts that have lastname equal to Clark.

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: ado.net entity framework, ado.net

.NET | C#

Entity Framework with ASP.NET MVC In this article, I will explore entity framework with ASP.NET MVC. We will modify Form valid...Reading and Writing BLOB Data to MS SQL or Oracle Database In this article, i will examine how to store and retrieve binary files such as image or PDF into M...Entity SQL query with parameters using ObjectQueryThis topic shows how to execute an Entity SQL query&nbs...