Note On <Programming Entity Framework 2nd Edition> -02: How to Use SqlExpress Profiler 2.0

Chapter 3: Querying Entity Data Models

Example 3-3. Querying with Entity SQL

The example code of Entity SQL in this chapter in page 57 doesn't work in Entity Framework 6.0. And in EF5.0, you need to change it in this way:

var queryString = "SELECT VALUE c " +
		"FROM PROGRAMMINGEFDB1Entities.Contact AS c " +
		"WHERE c.FirstName='Robert'";
					
ObjectQuery<Contact> contacts = ((IObjectContextAdapter)context).ObjectContext.CreateQuery<Contact>(queryString);

foreach (var contact in contacts)
{
	Console.WriteLine("{0} {1}",
	contact.FirstName.Trim(),
	contact.LastName);
}

If you compose the query with multiple items(Page 59), like this:

var queryString = "SELECT c.LastName, c.Title " +
					"FROM PROGRAMMINGEFDB1Entities.Contact