<< 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...Bulk Insert/Update in MS SQL This article explains how to insert/update bulk data in .net application. This way your applicatio...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...

Querying with Entity SQL

Related posts

Comments