Microsoft ADO.NET Entity Framework Step by Step

Chapter 7. Manipulating data using Entity SQL

After completing the chapter, you’ll be able to

• Understanding Entity SQL

• Selecting data

• Working with literals in Entity SQL

• Ordering data

• Grouping data

Chapter 4 provides a basic introduction to Entity SQL, but it doesn’t explore this method of interacting with the Entity Framework in detail. As described in the “Understanding the role of Entity SQL” section of Chapter 4, this technique of creating queries is focused on making use of SQL language knowledge that developers already possess. That said, Entity SQL provides a considerable array of features that makes it possible to extract data from a database quickly and relatively simply, as long as you know the Entity SQL language (the example in the “Creating ...